Viewing 15 posts - 13,051 through 13,065 (of 49,552 total)
Bhaskar.Shetty (5/22/2013)
GilaMonster (5/22/2013)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 22, 2013 at 7:59 am
Where Createdate >= '2013-03-12 08:00' and createdate < '2013-03-12 09:00'
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 22, 2013 at 6:43 am
Restart SQL.
New questions in a new thread please.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 22, 2013 at 2:16 am
Viewing 15 posts - 13,051 through 13,065 (of 49,552 total)