Viewing 15 posts - 35,731 through 35,745 (of 49,552 total)
Maybe.
By primary key, do you mean clustered index? The pk is only clustered by default, it can be enforced by a nonclustered index. I'm going to assume you meant clustered...
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
November 19, 2009 at 8:17 am
Snapshot replication or transactional replication? Very important to know the difference.
Backup with truncate will do nothing for the bloated log if the problem is replication. It'll just break 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
November 19, 2009 at 8:15 am
Depending who you read, recommendations for TempDB range from 0.25 files/core to 1 file/core. Regardless, the X files per Y cores is a standard recommendation for TempDB and is done...
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
November 19, 2009 at 7:55 am
jasona.work (11/19/2009)
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
November 19, 2009 at 7:29 am
What recovery model? Are you doing log backups? Is the replication log reader running? (check the replication monitor)
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
November 19, 2009 at 7:14 am
Please read through this - Managing Transaction Logs[/url]
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
November 19, 2009 at 7:12 am
Take a look at the new system views. sysdatabases and many others that you would know from SQL 2000 are now deprecated and will be removed in a future version.
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
November 19, 2009 at 7:09 am
Johnc (11/19/2009)
We don't update the key column but rows can be deleted. Would this deletion be the cause of the fragmentation?
No. Deletes can't cause fragmentation. They can result in pages...
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
November 19, 2009 at 7:08 am
Spam. Reported
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
November 19, 2009 at 4:21 am
Sorry, don't understand the question.
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
November 19, 2009 at 4:19 am
Since you're using SQL 2005 (or I assume you are, since this is posted in the SQL 2005 forums), use sys.databases instead. The statuses are neatly broken down in a...
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
November 19, 2009 at 4:18 am
GilaMonster (11/19/2009)
Please post table definitions, index definitions and execution plan, as per 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
November 19, 2009 at 4:17 am
Edwin-376531 (11/18/2009)
During my testing, I run into some issues that indicated the publisher database is in Simple recovery model.
Transactional replication does not depend on recovery model. http://sqlinthewild.co.za/index.php/2008/12/05/a-new-sql-myth/
What issues did 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
November 19, 2009 at 3:17 am
Jack Corbett (11/18/2009)
j_braclin (11/18/2009)
i dunno. This kind of confused me.
Well then ask some questions. What are you confused about? I'm sure Gail, the author, will try to clarify,...
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
November 19, 2009 at 3:14 am
A clustered index scan is a table scan, so that's usually a bad thing.
Please post table definitions, index definitions and execution plan, as per 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
November 19, 2009 at 3:11 am
Viewing 15 posts - 35,731 through 35,745 (of 49,552 total)