Viewing 15 posts - 4,066 through 4,080 (of 5,685 total)
MB-400824 (2/10/2011)
February 10, 2011 at 1:32 pm
A very handy article, Jeremiah, especially the revised one. Thanks for pointing it out. Much reading to be done!
February 10, 2011 at 1:25 pm
adonetok (2/10/2011)
SSCommitted, thank you so much. It works great!!!
Heheh, my pleasure, glad it works for you. You understand what it's doing, I hope?
Also, just an FYI, my name's Craig...
February 10, 2011 at 1:05 pm
aksheela (2/9/2011)
I am doing multiples deletes at a time using the front end of the application that is through ADO.Net recordset.
Do you...
February 10, 2011 at 12:32 pm
Chrissy321 (2/9/2011)
So the only place I use the parameters is in the SELECT not the WHERE. Would that still be considered to be parameter sniffing? Or some type of variant...
February 10, 2011 at 1:18 am
Portlander (2/9/2011)
Craig Farrell (2/9/2011)
I'd really like to see the full proc and ddl here, this thing is a tragedy.
No arguments there. Hence the subject (How to improve performance...
February 10, 2011 at 1:13 am
I don't know the answer offhand, but out of curiousity, why do you care? Are you just simply curious or do you have a distinct criteria for it?
Now, if...
February 9, 2011 at 5:23 pm
A number of them. To answer your first question, yes, a bad execution plan can get stuck in cache. Look up 'parameter sniffing', you'll find an eyeful. 🙂
February 9, 2011 at 5:20 pm
|--Stream Aggregate(DEFINE[Expr1009]=MIN([testdb].[Table1].[id])))
|--Nested Loops(Left Semi Join)
|--Nested Loops(Left Semi Join)
...
February 9, 2011 at 5:16 pm
^ What Grant said. 🙂
I personally prefer individual scripts and jobs for my backups (and maintenance in general) to fine tune my control... and to make sure backup #23 failing...
February 9, 2011 at 5:13 pm
I just took a second look at your code. Okay, that is a significantly STRANGE clause.
and exists
(select id from Table1 where calendar_id = 'Test1'...
February 9, 2011 at 5:04 pm
Portlander (2/9/2011)
UPDATE STATISTICS Table1
WITH FULLSCAN, NORECOMPUTE
And verified that it has no impact on...
February 9, 2011 at 4:46 pm
It won't be able to happen immediately until the snapshot is sent over and in place before the transactions can start being shipped. You can trigger that to occur...
February 9, 2011 at 4:05 pm
The squares simply mean they're out of the standard character set for the font.
There's no gentle way to do this, you need to loop to each character, evaulate the CHAR()...
February 9, 2011 at 4:03 pm
The first and most likely cause of a slowdown after a version upgrade in SQL Server is table statistics.
Take all the tables in the offending query and rebuild the statistics...
February 9, 2011 at 3:50 pm
Viewing 15 posts - 4,066 through 4,080 (of 5,685 total)