Viewing 15 posts - 18,376 through 18,390 (of 49,552 total)
Jeff Moden (5/29/2012)
You do realize how wrong durations in SET STATISTICS can be, right?
The durations show by statistics time are 'correct'. They may not show what people think, but they...
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 29, 2012 at 10:08 am
SQLKnowItAll (5/29/2012)
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 29, 2012 at 9:57 am
Drop the index and recreate it.
Edit, forgot there was an sp_rename for indexes. That's probably better.
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 29, 2012 at 7:30 am
No such concept as 'active' database.
For objects in your connection's current database you don't need to specify the database name. For objects from another, then it does need to specify...
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 29, 2012 at 7:28 am
Charmer (5/29/2012)
i googled for checking 'update top' command....but it is like "update top 100 table set column = value "...
Yup, that's the command.
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 29, 2012 at 6:44 am
I did see your previous post, and I would still recommend you look at something like UPDATE (TOP ... if you can. First though, check indexes make sure that you...
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 29, 2012 at 5:46 am
If it's a particular time of day, not a particular set of parameters, chedck what's running at that time and log what the query in question is waiting for.
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 29, 2012 at 5:44 am
No, a cursor is not likely to be good, neither is a while loop. What exactly are you trying to do? Iterative processing is typically slower than set-based in SQL...
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 29, 2012 at 4:58 am
Could you post the execution plan please?
Leading wildcard means SQL can't seek on an index. It can scan.
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 29, 2012 at 4:55 am
From when I worked at the bank...
Devs getting sysadmin on the shared development server - no. Db_owner on their databases, yes. Alter trace permissions, yes. DB_creator for some, yes. Not...
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 29, 2012 at 4:51 am
Perry Whittle (5/29/2012)
GilaMonster (5/29/2012)
The reason being that a properly tuned SQL Server should never be using the page file at all
While this is true, if you have SQL Server sucking...
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 29, 2012 at 4:38 am
Can't be parameter sniffing, cause of the with recompile.
Please don't just slam a maxdop on without investigating carefully.
Can you post estimated plan of the parameter values that run 'forever' and...
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 29, 2012 at 3:43 am
No, that's not what I said. What you're describing is a single instance cluster (what used to be called active-passive)
In a multi-instance cluster there are multiple instances of SQL, each...
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 29, 2012 at 3:00 am
Is it getting blocked?
Is that specific combination of parameters likely to return more rows than the others?
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 29, 2012 at 2:25 am
Don't call it active-active, that's a old term. These days it's called 'multi-instance clustering' (because 2 node clusters aren't the only ones you can have anymore).
What 'active-active' means is 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 29, 2012 at 2:16 am
Viewing 15 posts - 18,376 through 18,390 (of 49,552 total)