Viewing 15 posts - 2,866 through 2,880 (of 5,843 total)
weevil (7/5/2012)
July 5, 2012 at 4:25 pm
ronald.dirkx (7/3/2012)
we need to set up Transaction Log Shipping on a production server. The issue we are facing upfront is that it will be virtually impossible to make a...
July 5, 2012 at 4:21 pm
Les Cardwell (7/2/2012)
>>Just a hunch Les, but have you tried replacing the delete & update with MERGE?
Unfortunately, I can't alter the code. The utility has been replacing in-house developed...
July 2, 2012 at 11:18 am
Not sure why no one recommended trace flag 1222, nor this series of blog posts: http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx
I note that deadlock investigations and fixing can be a VERY complex undertaking. ...
July 2, 2012 at 9:21 am
People, there is no need to look any further than the fact that the OP is trying to return 35 MILLION RECORDS to the calling entity (presumably SSMS).
July 2, 2012 at 7:27 am
ChrisM@Work (6/27/2012)
Hadrian (6/27/2012)
Thanks to all!I succeded to solve the problem using pre-fetch hints .
Please share. Others with a similar problem in the future may benefit.
I agree.
I also wonder...
June 28, 2012 at 8:04 am
GilaMonster (6/26/2012)
Probably because it's a heap.
That would be my vote too. I have seen that at quite a number of clients over the years!
June 28, 2012 at 7:59 am
first guess is blocking. use sp_whoisactive from sqlblog.com to see that as it happens in real time. use wait stats analysis over a 3-5 minute period to see...
June 28, 2012 at 7:57 am
I want you to tell me EXACTLY what makes up the drive that windows sees that holds your database, and what else might be on the same spindle(s) on the...
June 28, 2012 at 7:55 am
opc.three (6/26/2012)
ScottPletcher (6/26/2012)
June 26, 2012 at 3:27 pm
Lynn Pettis (6/26/2012)
ScottPletcher (6/26/2012)
June 26, 2012 at 2:35 pm
ScottPletcher (6/26/2012)
You're more likely to lose a complete RAID1 mirror, than you are 3 drives out of a 4 disk RAID10 array
OK, but it's not the odds against losing it,...
June 26, 2012 at 12:56 pm
>>use a windows scheduled task to execute scripts via SQLCMD
Been doing that for a LONG TIME...
SCHTASKS is what you want to use. See here for nice documentation: ...
June 26, 2012 at 8:50 am
ScottPletcher (6/25/2012)
With RAID1 you lose spindle aggregation - such that it is with just 4 drives in the RAID10.
Even with my specified condition of:
database filegroups with two files, one on...
June 25, 2012 at 5:29 pm
ScottPletcher (6/25/2012)
agree on the whole but you would almost certainly notice some performance degradation whilst the RAID1 or 5 array is being rebuilt.
True, but RAID1 with a good controller should...
June 25, 2012 at 4:13 pm
Viewing 15 posts - 2,866 through 2,880 (of 5,843 total)