Viewing 15 posts - 1 through 15 (of 52 total)
Your question is one of my favorite interview questions. How they answer tells me a lot about their skills, and whether they are comfortable with scripting to automate mundane...
- Paul
http://paulpaivasql.blogspot.com/
February 27, 2012 at 8:13 am
You can use a global temp table, meaning you use double hash marks, ##MyTempTable.
The table will persist as long as you have a connection (spid) open that is accessing...
- Paul
http://paulpaivasql.blogspot.com/
February 23, 2012 at 9:45 am
Raja,
Excellent job, thanks for sharing the code! Worked perfectly for me.
Regarding the last two persons to post comments - you make good points that there are better and more...
- Paul
http://paulpaivasql.blogspot.com/
December 13, 2011 at 1:10 pm
I would love to know the answer to this, too!
Paul
- Paul
http://paulpaivasql.blogspot.com/
March 30, 2010 at 6:13 pm
Thanks for the code - nice and clean, with great comments. I'm using it and appreciate it.
- Paul
http://paulpaivasql.blogspot.com/
October 28, 2009 at 11:47 pm
Good points, Sylvia, that many including me would not have thought of.
Another to add to the list: Check the location of data and log files and separate them if...
- Paul
http://paulpaivasql.blogspot.com/
June 22, 2009 at 3:54 pm
I agree with Lowell - that's that best way, but keep in mind that you might fill your transaction log if it is a huge table.
In any case,...
- Paul
http://paulpaivasql.blogspot.com/
June 9, 2009 at 11:19 am
Hi Lempster,
No, I was not "aiming" my comments at you! I was just defending the author - I felt that he was NOT saying "always use script for send...
- Paul
http://paulpaivasql.blogspot.com/
June 8, 2009 at 10:21 pm
Great article Mainish, thanks.
As was clearly stated in the "Purpose/Scope" section of the article, the intention is to show how you can use a script task to send...
- Paul
http://paulpaivasql.blogspot.com/
May 7, 2009 at 2:48 pm
Nice thought-provoking article. It gives me the opportunity to voice a related opinion...
It seems to me that any good DBA would take pride in also being a developer. ...
- Paul
http://paulpaivasql.blogspot.com/
April 6, 2009 at 11:54 am
Excellent article, Andy.
SSIS can be daunting at first, even for experienced DTS developers. You have provided what is missing in Microsoft documentation.
I'm looking forward to other SSIS...
- Paul
http://paulpaivasql.blogspot.com/
April 6, 2009 at 11:09 am
Wow, this is an exceptional article. Well-thought out, well-researched. It is definitely the most useful article I've read this year, and possibly will be the best all year!
Thanks...
- Paul
http://paulpaivasql.blogspot.com/
April 3, 2009 at 1:21 pm
When I try setting 'allow updates' to a 1, I get the following message:
Msg 259, Level 16, State 1, Line 1
Ad hoc updates to system catalogs are not allowed.
So it...
- Paul
http://paulpaivasql.blogspot.com/
March 24, 2009 at 2:50 pm
SSC has been an immense help - There have been so many times that I've found code snippets just in the nick of time to solve a problem.
iPhone - especially...
- Paul
http://paulpaivasql.blogspot.com/
March 23, 2009 at 2:08 pm
Good article and everyone has brought up some good points.
However we should also investigate additional reasons that the log filled up in the first place.
Such as, a sole process may...
- Paul
http://paulpaivasql.blogspot.com/
March 18, 2009 at 2:08 pm
Viewing 15 posts - 1 through 15 (of 52 total)