Viewing 15 posts - 25,666 through 25,680 (of 49,552 total)
My uneducated guess (if someone asks for TempDB recommendations for a server I've never seen) is number of data files = 1/4-1/2 the number of cores in the system, do...
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
June 7, 2011 at 2:13 pm
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
June 7, 2011 at 1:39 pm
If you're intent on shrinking, don't waste your time defragmenting the indexes beforehand, as the shrink will result in them being far more fragmented than ever.
Shrink is something that should...
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
June 7, 2011 at 1:39 pm
GSquared (6/7/2011)
GilaMonster (6/7/2011)
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
June 7, 2011 at 1:31 pm
More emphasising that there's no single hard value where it's good above and bad below. I see the 'page life expectancy must be above 300' tossed around far too much...
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
June 7, 2011 at 1:03 pm
Elliott Whitlow (6/7/2011)
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
June 7, 2011 at 12:55 pm
Now I can look forward to working on fun, interesting, complex stuff (like automating an entire SQL environment from scratch, designing nasty-complex systems for forecasting) rather than producing lists of...
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
June 7, 2011 at 12:54 pm
SQLRNNR (6/7/2011)
GilaMonster (6/7/2011)
The client-from-hell is no more.You didn't do something drastic did you? 😀
Nah. My boss (MD of the consulting company) and laid out our issues and explained that we...
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
June 7, 2011 at 12:44 pm
Read committed snapshot is set at a database level, but you can enable snapshot isolation and set that for a connection with the usual SET TRANSACTION ISOLATION LEVEL statement.
If 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
June 7, 2011 at 12:37 pm
The client-from-hell is no more.
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
June 7, 2011 at 11:18 am
Please post execution plans, query, table definition, index definitions. See http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
June 7, 2011 at 8:00 am
Suspended = waiting for a resource
Sleeping = not currently running a query
Runnable = can be scheduled onto a processor.
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
June 7, 2011 at 7:40 am
Grant Fritchey (6/7/2011)
Does location matter? Meaning, could people work remotely? I know several people (including me) who have lower rates for remote work.
If you read the original thread over at...
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
June 7, 2011 at 7:32 am
I recommend the same person I recommended when you posted to SQLTeam. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=161474
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
June 7, 2011 at 7:19 am
Different execution plans so probably using indexes differently, so different ordering.
Seriously, without an order by there is nothing you can say about the order of the rows. It's however 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
June 7, 2011 at 7:16 am
Viewing 15 posts - 25,666 through 25,680 (of 49,552 total)