Viewing 15 posts - 32,101 through 32,115 (of 49,552 total)
Sam Phillips (6/30/2010)
No, I meant for my non-clustered index creation statements (put on after my data is already loaded up).
Yes, so did I.
Both of those exec plans were...
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 30, 2010 at 9:41 am
Sam Phillips (6/30/2010)
Shame the executition plan of "create index" doesn't mention wether other indexes are consulted.
It does. See below. Index1 was a table scan, Index2 SQL used an existing index...
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 30, 2010 at 9:29 am
WebTechie38 (6/30/2010)
As my manager said he needed, "intelligent scripts" to do our administering.
Don't script for the shear sake of scripting. Take a look at your environment, decide if you need...
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 30, 2010 at 9:08 am
Could someone who knows their way around deadlocks take a look at this please? Not going to be able look at it before the weekend
http://www.sqlservercentral.com/Forums/Topic944536-338-1.aspx
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 30, 2010 at 9:02 am
WebTechie38 (6/30/2010)
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 30, 2010 at 8:46 am
mattmc (6/30/2010)
We have a scheduled process each night which drops and recreates index’s on one of our main Databases.
Why drop and recreate? So that you can do some large...
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 30, 2010 at 8:35 am
maskew (6/30/2010)
As far as I understand this, it is now not possible to become certified in sql server 2000.
Correct. All the exams are retired and can no longer be written....
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 30, 2010 at 8:00 am
That won't work. You won't be able to restore the backup from 2008R2 onto the 2008 server.
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 30, 2010 at 8:00 am
Call Microsoft's customer support and open a case. There are very few people that can debug a stack dump effectively and most work for MS.
Just make sure that you have...
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 30, 2010 at 7:27 am
Sam Phillips (6/30/2010)
Sounds like SQL Server is consulting my new index to speed the creation of the next index.
It can. It'll use the best option it has 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
June 30, 2010 at 7:19 am
The broker-related processes are supposed to be waiting most of the time. They're idle the vast majority of the time waiting for something to do. They should have high wait...
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 30, 2010 at 7:13 am
balasach82 (6/30/2010)
Is the default trace (which is in Log folder) also available in SQL 2000?
No.
If so, then what is the equivalent of fn_trace_getinfo?
fn_trace_getinfo works on SQL 2000, for traces 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 30, 2010 at 7:13 am
David BAFFALEUF (6/30/2010)
The CONTINUE_AFTER_ERROR option will force SQL Server to carry on the execution even if it finds a checksum error.
I wouldn't recommend that as a default option. It's...
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 30, 2010 at 7:10 am
Rohit Chitre-274613 (6/30/2010)
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 30, 2010 at 2:53 am
http://sqlinthewild.co.za/index.php/2008/11/04/what-are-statistics-and-why-do-we-need-them/
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 30, 2010 at 2:21 am
Viewing 15 posts - 32,101 through 32,115 (of 49,552 total)