Viewing 15 posts - 76 through 90 (of 98 total)
Nothing wrong with defrag the entire drive, or using the native defragger! That is, if you can afford the time and taking MSSSQL down.
Having used the Russinovich CONTIG.EXE util on...
May 20, 2009 at 5:15 pm
jmoss111 (2/13/2009)
I run contig.exe on specific databases to keep the files in one piece.Regards,
Jim
Right-O. Download Mark Russinovitch's CONTIG utility. Run it specifically against the .MDF file (then the LDF file...
May 20, 2009 at 6:50 am
OOps - a few incorrect memories above.
Found my code - it does call the DTEXEC utility with xp_cmdshell but not using the pathname.
The syntax is really difficult, but if you...
May 20, 2009 at 6:10 am
lzhang (5/19/2009)
Create a batch file. put the command in the bactch file.In the stored procedure just run this batch file. It will work.
There is no need to invoke the command-line...
May 20, 2009 at 5:57 am
Scott Coleman (5/19/2009)
You're...
May 20, 2009 at 5:39 am
steve.coleman (5/4/2009)
I've seen other people ask this question, but didn't see an answer. Has anyone applied service packs or CU's since moving the system data files to another file location?
Yes,...
May 4, 2009 at 10:56 pm
I am running the DTS packages on a SQL2005 server - no need to keep the 2k one running! In fact it's the same SQL2005 server that takes 5 hrs...
May 3, 2009 at 9:37 pm
Thanks for posting this - transfer rate may be the thing to watch for.
I am in a similar but desperate situation, so any ideas will be appreciated.
We have a data...
April 29, 2009 at 8:38 am
Jeff Moden (4/6/2009)
April 6, 2009 at 11:26 pm
Hugo Kornelis (4/6/2009)
David B (4/6/2009)
O' and unless Steve fixed it after the last post, it was a select list, not a multiple choice 🙂
Are you sure? I just replied to...
April 6, 2009 at 2:27 am
Hi guys,
MSDN might be right about the subselect scalar query, but I cannot PRINT the result as NULL .... it's just empty!
Regardless, none of the multiple choices listed BOTH...
April 6, 2009 at 12:31 am
ssismaddy (3/9/2009)
I have 7 stored procs, --I want to log their execution timings to a table....is it possible?? Pls advise me...Thank you
To write to a table, you may create a...
March 10, 2009 at 10:40 pm
ssismaddy (3/9/2009)
March 10, 2009 at 10:33 pm
James_DBA (2/10/2009)
It absolutely is wonderful to see the row count for each table, the purpose behind the final (total) count is very useful in cases of...
February 16, 2009 at 5:54 pm
SDM (2/16/2009)
At the risk of being redundant, excellent article, Gail. It should be compulsory "calm down and think" reading for any DBA facing an apparent catastrophe. ..Stephen
Same from...
February 16, 2009 at 4:13 pm
Viewing 15 posts - 76 through 90 (of 98 total)