Viewing 15 posts - 13,051 through 13,065 (of 49,552 total)
Bhaskar.Shetty (5/22/2013)
GilaMonster (5/22/2013)
May 22, 2013 at 8:20 am
Bhaskar.Shetty (5/22/2013)
but adding indexes for each and every column mince adding overheads on index maintanance also.
You wouldn't want to do that and it would be entirely useless to do. Adding...
May 22, 2013 at 8:17 am
jhager (5/22/2013)
There are (currently) 54 single-use plans with this exact text.
There's a lot of things that could be going on here and it's hard to tell what without a...
May 22, 2013 at 8:14 am
John Mitchell-245523 (5/22/2013)
jhager (5/22/2013)
Upon further digging, I've also come across a large number like this:
...
There...
May 22, 2013 at 8:08 am
Case in point.
Q: I'm seeing multiple plans in cache for the same procedure
A: It might be due to parameter sniffing. Add WITH RECOMPILE to the procedure.
May 22, 2013 at 8:04 am
shettybhas (5/22/2013)
If the EXEC are calling inside a Stored Procedure then this may be because of Paramete r Sniffing, alter the stored procedure with 'WITH RECOMPILE' and try once.
Parameter sniffing...
May 22, 2013 at 8:02 am
I would disagree there, stats that are more than a day old and have a single row change absolutely do not need updating. That's almost as bad as blanket updating...
May 22, 2013 at 8:01 am
ChrisM@Work (5/22/2013)
If OTOH someone posted "Don't do this yet, there's insufficient evidence to support it and it will cost you three hours to find out", I'd be pretty darned grateful.
Apologies,...
May 22, 2013 at 7:59 am
Where Createdate >= '2013-03-12 08:00' and createdate < '2013-03-12 09:00'
May 22, 2013 at 6:47 am
Those aren't parameters, they're being concatenated into th strong hence are essentially literal values once the concatenation is done. Concatenated into the string as they are they'll result in multiple...
May 22, 2013 at 6:43 am
Restart SQL.
New questions in a new thread please.
May 22, 2013 at 6:39 am
ChrisM@Work (5/22/2013)
Is it just me or is there really a hike in hideously BS answers this week? Not on this thread of course, the "worker threads"
Yes. Very much so.
May 22, 2013 at 6:37 am
No way to tell really. TempDB isn't the same as Oracle's redo space, so you can't use that as a basis.
Tempdb is used for temp tables, table variables, some internal...
May 22, 2013 at 6:33 am
Problem is, by doing that you've changed what the query does and it may well return differernt data after your modification.
One of the worst things you can do while tuning...
May 22, 2013 at 5:50 am
I don't have time right now to write it for you. If you want someone to give you a solution, post the table definitions (as CREATE TABLE), some sample data...
May 22, 2013 at 2:16 am
Viewing 15 posts - 13,051 through 13,065 (of 49,552 total)