Viewing 15 posts - 38,701 through 38,715 (of 49,552 total)
Simon_L (6/3/2009)
p.s is that the babylon rangers motto I see ?
Yup.
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 3, 2009 at 7:46 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic728028-357-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 3, 2009 at 7:46 am
rvz (6/3/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
June 3, 2009 at 7:30 am
Eswin (6/3/2009)
SQL Server doesn't immediately shrink log files when you issue the DBCC Shrinkfile command.
Yes it does. When you issue a SHRINKFILE, the file in question is shrunk. How...
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 3, 2009 at 7:27 am
In my opinion, yes. Every table should have a clustered index. There are a few disadvantages to having heaps. That said, a badly chosen clustered index is worse than 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
June 3, 2009 at 7:26 am
Simon_L (6/3/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
June 3, 2009 at 7:23 am
sateesh.kamalakar (6/3/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
June 3, 2009 at 7:09 am
bhuvnesh.dogra (6/3/2009)
But how would you go for JOBs migrations ?????
Method 1:
Script the jobs out, run the script on the new server
Method 2:
Use the SSIS Transfer Jobs task.
Either way, jobs...
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 3, 2009 at 7:08 am
I would still do some analysis before dropping them, ie review stored procs and views and make none of them would need that 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 3, 2009 at 2:40 am
Eswin (6/3/2009)
always issue checkpoint before executing dbcc shrinkfile ().
Why?
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 3, 2009 at 2:35 am
Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.
If you shrink the log is is going to 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 3, 2009 at 2:34 am
The open tran indicates that this was once replicated (publisher) or was restored from a backup of a published database. Either way, there's left-over replication that's preventing the log from...
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 3, 2009 at 2:34 am
It's stored in a different place in SQL 2008 and it's treated almost as if it was a dll.
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 3, 2009 at 2:32 am
TheSQLGuru (6/2/2009)
alter PROCEDURE Test4 ( @ProdID int = null, @Qty int = null)
AS
select TransactionID
from [Production].[TransactionHistory] -- with (index = [IX_TransactionHistory_ProductID])
where ProductID BETWEEN coalesce(@ProdID, 0) AND coalesce(@ProdID, 99999999) --should use actual...
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 3, 2009 at 2:29 am
Dave Ballantyne (6/3/2009)
Can you post a full XML query plan of one of your queries that Seek ?.
If you could try to make the query as simple as...
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 3, 2009 at 2:23 am
Viewing 15 posts - 38,701 through 38,715 (of 49,552 total)