Viewing 15 posts - 34,171 through 34,185 (of 49,552 total)
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Do you really have to check every single columns. Can't you do an exists check just on the primary...
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 7, 2010 at 3:09 am
Jeff Moden (2/6/2010)
Voting by the general public smacks of a popularity contest rather than a public service award (which is what being an MVP is really all about).
Agreed. While...
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 7, 2010 at 2:59 am
I would rather not see a list of requirements, weightings or things like that. Having such a list being known makes it possible for people to 'game' the award. 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
February 7, 2010 at 2:50 am
I'm sure there's an article somewhere (but I don't have any links). Try your favourite search engine.
From enterprise manager, generate the scripts. I don't use EntMan any longer, and I...
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, 2010 at 12:38 pm
The Dixie Flatline (2/6/2010)
Do you set 120 'ON' or 'OFF' in the event of a syzygy?
Depends on the state of Schrodinger's Cat at the exact instant. I prefer using...
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, 2010 at 10:21 am
The Dixie Flatline (2/6/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
February 6, 2010 at 10:16 am
sanjeev.k (2/6/2010)
I have same server and having suppose more than 1000 tables and each table can have millions of records. I've to show these records in my .NET applications.
Who...
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, 2010 at 7:11 am
Ignore the pages/sec. 9-50 is pretty low. I'm going to hazard a guess that your bottleneck is IO probably due to poor indexing (and poor queries) possibly exasperated by non-optimal...
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, 2010 at 7:04 am
You can only rollback if you ran the operation within a transaction and did not run the COMMIT TRANSACTION statement. I doubt that applies here.
Find a backup, restore it alongside...
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, 2010 at 6:58 am
I wouldn't recommend moving the system DBs from one server to another. What are you trying to 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
February 6, 2010 at 2:12 am
The Dixie Flatline (2/5/2010)
Even less well known are the 137 optional and undocumented parameters necessary to use DBCC Timewarp correctly.
One thing to note is that you should be especially...
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, 2010 at 2:07 am
The Dixie Flatline (2/5/2010)
I loved the touch of Ella, bb.Wayne, and anyone else, I've taken the liberty of creating a forum specifically for DBCC TIMEWARP here.
So much for my April...
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, 2010 at 2:06 am
You have irreparable corruption here, there's damage to the system tables and to some allocation pages. There's no way to fix this.
Your options are:
1) restore from your last good backup,...
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, 2010 at 2:03 am
Please post new questions in a new thread. Thank 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
February 6, 2010 at 1:56 am
Edwin-376531 (2/5/2010)
In addition, should the sql database recover model set to Full?So, I can back up the transaction logs?
Depends. If it's necessary to be able to restore 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
February 6, 2010 at 1:55 am
Viewing 15 posts - 34,171 through 34,185 (of 49,552 total)