Viewing 15 posts - 26,041 through 26,055 (of 49,552 total)
ramadesai108 (5/19/2011)
I have over 91 million records. Deleting in small chunks will take long time.
You'd think so, but in general deleting in chunks is faster than a massive delete....
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
May 19, 2011 at 11:45 am
jpSQLDude (5/19/2011)
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
May 19, 2011 at 9:34 am
Deletes are logged operations. They are always logged operations. The log needs to be big enough to accommodate ((size of row being deleted + size of log headers) * number...
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
May 19, 2011 at 9:18 am
Check your SQL jobs. Highly likely there's an index rebuild scheduled for that time.
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
May 19, 2011 at 9:11 am
Suresh B. (5/19/2011)
You can use snapshot to query mirror/standby databases.
Mirrored DBs only. Standby DBs are read-only already, and a snapshot cannot be taken of a DB in the recovering state...
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
May 19, 2011 at 6:45 am
forsqlserver (5/19/2011)
DBCC Shrinkfile and DBCC ShrinkDB which Creates more fragmentation.
ShrinkDB just runs ShrinkFile on each and every file in the DB. Nothing fancier than that.
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
May 19, 2011 at 6:44 am
It is not a backup. It's nothing close to a backup (which is why it's not called one)
http://msdn.microsoft.com/en-us/library/ms175158.aspx
http://msdn.microsoft.com/en-us/library/ms187054.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
May 19, 2011 at 4:59 am
Alter index on each nonclustered index or ALTER INDEX ALL On <table>
Heaps cannot be rebuilt in SQL 2005.
Someone is sure to suggest adding and dropping a clustered index. While that...
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
May 18, 2011 at 12:45 pm
coronaride (5/18/2011)
Egads - on a production system? 🙂
No. In a lab environment (and 2 instances installed on your local machine can be a lab environment)
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
May 18, 2011 at 11:00 am
Everything that gets logged (and that's every single change of any form within the database) is transfered by log shipping.
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
May 18, 2011 at 10:38 am
sqlnaive (5/18/2011)
On Second Point, I want to clear is whether the joins between the tables first takes place and then the condision based on WHERE cluase is applied ?
Nope.
Run 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
May 18, 2011 at 10:31 am
CREATE INDEX with ONLINE?
You can't restore a backup onto reporting, create the indexes and then start log shipping. The log restores will fail saying there are no files ready to...
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
May 18, 2011 at 10:26 am
Yes. "memory associated data." The swap file. It is NOT reads/writes from random files on disk. It is memory-related reads from the swap file.
These are all windows-level counters. Windows...
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
May 18, 2011 at 10:25 am
DBANewbie (5/18/2011)
GilaMonster (5/18/2011)
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
May 18, 2011 at 9:28 am
Yup, and 0 is what you want. So much for that train of thought
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
May 18, 2011 at 9:25 am
Viewing 15 posts - 26,041 through 26,055 (of 49,552 total)