Viewing 15 posts - 14,446 through 14,460 (of 49,552 total)
Case statement is probably what you're looking for, but not enough information to be sure.
All this is in one table? What do you want the model size column to show...
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
February 4, 2013 at 6:15 am
sqlfriends (2/1/2013)
SQL Pizza (2/1/2013)
as you've already learned, memory management in sql server is a very complicated topic. Could you please describe your problem more precise, to give us 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
February 4, 2013 at 5:36 am
SQL Pizza (2/4/2013)
For example : Page Life Expectancy should be well above 300 (which are seconds, so they should last longer than 5 Minutes)
That was a poor threshold when Microsoft...
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
February 4, 2013 at 5:24 am
sqlfriends (2/1/2013)
Sorry, I mean Total server memory is much lower than target server memory.
No, it means that SQL is ramping up its memory usage.
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
February 4, 2013 at 5:21 am
Which command did you run? The repair? If so, what was the output?
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
February 4, 2013 at 5:21 am
Do you know what those killed sessions were doing and the consequences of killing them?
Blocking: chapter 6 of http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/
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
February 4, 2013 at 1:57 am
Stop SQL agent.
ALTER DATABASE msdb SET Single_User WITH ROLLBACK IMMEDIATE
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
February 4, 2013 at 1:51 am
Exec plan without forceplan please, need to see what SQL's doing wrong to help.
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
February 4, 2013 at 1:48 am
Sergiy (2/3/2013)
Because there is no way any index can be used SQL Server needs to build the recordset from the subquery as 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
February 4, 2013 at 1:47 am
Considering how many times Seacom has developed faults off the Senegalese coast, sometimes I think they don't.
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
February 3, 2013 at 12:53 pm
Robert Davis (2/3/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
February 3, 2013 at 12:23 pm
GilaMonster (2/3/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
February 3, 2013 at 12:09 pm
Uwe Ricken (2/3/2013)
Hi Gail,your words frighten me 😉
I was so confident that problems will not occur when I have my own infrastructure (6 Mbit).
Well that's about 3 times the best...
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
February 3, 2013 at 11:55 am
Missing, no, seriously, majorly overcomplicating, yes. For what you describe you'll need unsafe CLR, elevated permissions on the client computer (so that SQL can talk to the client machine), lots...
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
February 3, 2013 at 10:18 am
Shane Clarke (6/21/2012)
How would you do it on a SQL cluster (active/passive)? Would you need to run it while each node is active?
Same way. No, just once. The settings...
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
February 3, 2013 at 9:15 am
Viewing 15 posts - 14,446 through 14,460 (of 49,552 total)