Viewing 15 posts - 17,236 through 17,250 (of 22,214 total)
When you're testing, take a look at the estimated rows for the actual values and the variables. I suspect you'll see substantial differences. For the variables you'll see an average...
June 10, 2009 at 7:44 am
Grant Fritchey (6/10/2009)
Lynn Pettis (6/10/2009)
MarkusB (6/10/2009)
Grant Fritchey (6/10/2009)
MarkusB (6/10/2009)
Any psychics around who can help this onehttp://www.sqlservercentral.com/Forums/Topic732091-266-1.aspx
I can't read minds, but I can see the future...
I see... I see... a dba-wanna-be...
June 10, 2009 at 7:40 am
Lynn Pettis (6/10/2009)
MarkusB (6/10/2009)
Grant Fritchey (6/10/2009)
MarkusB (6/10/2009)
Any psychics around who can help this onehttp://www.sqlservercentral.com/Forums/Topic732091-266-1.aspx
I can't read minds, but I can see the future...
I see... I see... a dba-wanna-be on the...
June 10, 2009 at 7:39 am
WayneS (6/10/2009)
Grant Fritchey (6/10/2009)
Well done. Extremely thorough, accurate, well written... but what's with the attached Word file?
I wrote the article in Word, and I had asked Steve to include it...
June 10, 2009 at 7:38 am
Grumpy DBA (6/10/2009)
Developer 1: "Hey, it's almost quitting...
June 10, 2009 at 7:33 am
Actually, based on what you describe, I'm not sure I'd use SSIS to do the job. I think I'd drop out to PowerShell to manage this. If you do it...
June 10, 2009 at 7:29 am
Yes, getting that many updates into a single statement is the best mechanism. You should experiment between using XQuery directly on the XML and loading the data into a temporary...
June 10, 2009 at 7:26 am
Percentage costs are based on the estimated costs and as Christopher pointed out, estimated costs are just that, estimated. They're based on the statistics available to the optimizer and are...
June 10, 2009 at 7:21 am
sys.dm_tran_locks is going to have the locking information, although I'm not sure if it will show lock escalation as it occurs. Once you're in there, you can get the sessionID...
June 10, 2009 at 7:16 am
When in doubt about thing released by Microsoft, the best source is Microsoft. You can go to the MSDN web site. Finding "What's New in SQL Server 2005 SP3" will...
June 10, 2009 at 7:09 am
It sounds like parameter sniffing (do a search on that phrase for volumes of information).
But, statements like this in your WHERE clause
abs(abs(a.value)-abs(b.value)) >= @threshold
Are going to prevent index use in...
June 10, 2009 at 7:01 am
The very nature of SQL Server is try to make it possible for lots of people to read the same data at the same time. Reading data, not updating/deleting it,...
June 10, 2009 at 6:51 am
There used to be several tools available for reading log files. I know that Idera had one as did Red Gate. I'm pretty sure Red Gate's is gone. I'm not...
June 10, 2009 at 6:44 am
Yeah, it was the number of plan guides that you'd need that made me balk. You can create a plan guide for an ad hoc query, but any variation in...
June 10, 2009 at 6:25 am
Well done. Extremely thorough, accurate, well written... but what's with the attached Word file?
June 10, 2009 at 6:15 am
Viewing 15 posts - 17,236 through 17,250 (of 22,214 total)