Viewing 15 posts - 40,501 through 40,515 (of 49,552 total)
Investor_Ennui (3/6/2009)
For my purpose, I'm using 2 for Monday, and 3 for Tuesday. Is it possible that the query isn't considering this?
The query's considering exactly what you write 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
March 6, 2009 at 12:44 pm
GSquared (3/6/2009)
We probably need to keep in mind that "MVP" != "Highly knowledgable about T-SQL".
No, but MVP for SQL Server does (or at least should) mean highly knowledgeable...
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
March 6, 2009 at 12:40 pm
The number of rollover files is one of the optional paramters for sp_trace_create
(From Books Online)
sp_trace_create [ @traceid = ] trace_id 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
March 6, 2009 at 12:31 pm
Mangal9i (3/6/2009)
Talking about execution plan, run both my query and your query and see cost of the query.Its 1% VS 99%.
SQL mis-estimates recursive CTEs very badly. The cost is based...
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
March 6, 2009 at 12:27 pm
Can you post table structure (as create table), some sample data (formatted as insert statements) and your desired output please. Is hard to test without.
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
March 6, 2009 at 9:29 am
liam (3/6/2009)
Thanks for the reply. Would DBCC be any use in this situation?
No. Firstly SQL can't start up with a damaged master so there's no way to run checkdb....
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
March 6, 2009 at 9:21 am
gregory.anderson (3/6/2009)
So...question, in your experiences, what is the confidence rating of these scripts?
Fairly low. The logic that goes into producing the missing index entries is a portion of what...
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
March 6, 2009 at 9:19 am
Roy Ernest (3/6/2009)
And all of you are trying to raise your post counts.... :hehe:
Indeed. I wonder if I can manage another 20 tonight. :w00t:
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
March 6, 2009 at 9:05 am
RBarryYoung (3/6/2009)
You know this is the most amazing part to me, how can an MSDN moderator act like this?
Something occurred to me...
How much of that came about because 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
March 6, 2009 at 9:01 am
Samrat Sen (3/6/2009)
Can anyone say whether serialization isolation level is prone to deadlock??
Transactions running under serializable are more likely to deadlock than any other, because of the extend of the...
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
March 6, 2009 at 8:55 am
Error: 9003, Severity: 20, State: 9.
The log scan number (268:480:1) passed to log scan in database 'master' is not valid. This error may indicate data corruption or that the log...
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
March 6, 2009 at 8:34 am
IF.. ELSE is a control flow statement that affects what statements are run. It can't be used inside a SQL statement. With a SQL statement, use CASE.
So, I would use...
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
March 6, 2009 at 8:31 am
ALZDBA (3/6/2009)
Nowadays, 500MB isn't that huge, but if OP needs to keep his drive space and this is a yearly event, I wouldn't mind shrinking.
I wouldn't either, as a once-off...
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
March 6, 2009 at 8:12 am
Shamshad Ali (3/6/2009)
what would you suggest now?
That you ask the DBA who recommended that why he recommends such a low fill factor.
The main reason for something like that...
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
March 6, 2009 at 3:04 am
Take a look at this article. There's a section on these catalog errors. http://www.sqlservercentral.com/articles/65804/
Bad news, the fix is not easy.
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
March 6, 2009 at 3:01 am
Viewing 15 posts - 40,501 through 40,515 (of 49,552 total)