Viewing 15 posts - 41,176 through 41,190 (of 49,552 total)
On databases created in 2005, or ones from earlier versions where the data purity check has run once successfully, that option is default and all checkDB executions (excluding ones where...
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 6, 2009 at 1:38 pm
Which edition of SQL 2008 do have? There's no basic edition. There's express (free), web, workgroup, standard, enterprise and developer.
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 6, 2009 at 1:20 pm
Have a look through these:
http://msdn.microsoft.com/en-us/subscriptions/subscriptionschart.aspx - Different MSDN subscriptions
http://technet.microsoft.com/en-us/subscriptions/bb892756.aspx - Different Technet subscriptions
http://msdn.microsoft.com/en-us/subscriptions/dd362338.aspx - Comparison between technet and MSDN
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 6, 2009 at 7:59 am
Grant Fritchey (2/6/2009)
As an aside, too many indexes will slow down inserts, but the right indexes, especially the right clustered index, will speed up insertions.
Indeed, and by too many...
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 6, 2009 at 7:38 am
Continued here - http://www.sqlservercentral.com/Forums/Topic651434-5-1.aspx
No more replies to this 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
February 6, 2009 at 1:09 am
Krishna (2/6/2009)
and finally Tail Backup with STOPAT (Recovery)
You only need STOPAT if there are some commands in the log that you don't want to restore (for eg a user dropping...
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 6, 2009 at 12:10 am
Depends how the DB crashed.
If the log is still accessible and SQL's still running, then you back up the tail of the log (no truncate, no recovery options), and restore...
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 6, 2009 at 12:01 am
Those are typically monitored through Performance Monitor (The windows tool), not through 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
February 5, 2009 at 11:59 pm
krypto69 (2/5/2009)
I looked into using plan guides.
Don't. Plan guides are a last resort fix for a query that's always generating a bad plan and that cannot be changed. They're...
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 5, 2009 at 11:55 pm
You can't. If you did not start an explicit transaction, then the changes were committed as soon as the statement completed and no rollback is possible
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 5, 2009 at 11:49 pm
shivani.suri2 (2/5/2009)
Need a suggestion...
As has been mentioned several times, use the status column. That is populated even for traces running through profiler. The status will tell you if the trace...
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 5, 2009 at 11:43 pm
The only time an adhoc plan will be reused is if the sql matches exactly to the one that create the plan. Exactly meaning down to the white space 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
February 5, 2009 at 3:24 pm
Jack Corbett (2/5/2009)
I believe that if you reorganize or rebuild stats for that index are updated automatically.
Rebuild, yes. Reorganise, no.
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 5, 2009 at 1:59 pm
Steve Jones - Editor (2/5/2009)
The limits change at times in versions, but to date I haven't heard anyone talking about reaching the limits.
If anyone in the world has a 500...
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 5, 2009 at 1:54 pm
Post the deadlock graph?
Two selects should not be able to deadlock unless there are strange locking hints used.
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 5, 2009 at 1:52 pm
Viewing 15 posts - 41,176 through 41,190 (of 49,552 total)