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...
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...
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...
December 13, 2011 at 1:10 pm
I would love to know the answer to this, too!
Paul
March 30, 2010 at 6:13 pm
Thanks for the code - nice and clean, with great comments. I'm using it and appreciate it.
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...
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,...
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...
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...
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. ...
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...
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...
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...
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...
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...
March 18, 2009 at 2:08 pm
Viewing 15 posts - 1 through 15 (of 52 total)