Viewing 15 posts - 35,236 through 35,250 (of 49,552 total)
Are you using SQL 2005 enterprise edition?
December 17, 2009 at 10:52 am
novice_coder (12/17/2009)
We will probably have about 3-5 million records by the end of next year. I guess then I will have to think about partioning.
That's not a lot of...
December 17, 2009 at 10:52 am
BobMcC (12/16/2009)
I've read in various places that rebuilding indexes will update your statistics. This makes sense all of the data gets 'touched' in the rebuild.
It does. Rebuilding an index updates...
December 17, 2009 at 12:41 am
Don't use profiler on a busy production server. It has an overhead. A server-side trace is much lighter impact.
December 17, 2009 at 12:40 am
Checked the hardware requirements for SQL 2000 and you're right. Server OS only. Must have been one of the changes in SQL 2005.
SQL 2008 with compat mode 80 will help...
December 17, 2009 at 12:33 am
They are usually smaller than the source database. They contain the original version of pages that change in the source database.
Still, ask yourself how much of that source database changes...
December 16, 2009 at 1:41 pm
Ok, first thing that we need to do, before anything else, is work out why the database is suspect. Can you have a look through the SQL error log, find...
December 16, 2009 at 12:05 pm
Also do a consistency check, make sure there are no errors.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
December 16, 2009 at 12:01 pm
Several things to be aware of here.
Database snapshots cannot be backed up. If the source database has to be restored for any reason or the drive with the snapshots fails,...
December 16, 2009 at 11:52 am
As far as I'm aware, what's in the log is the uid, the database user id. If the person who deleted the data was a sysadmin, that'll be dbo and...
December 16, 2009 at 11:44 am
Just as an aside. Never rebuild the transaction log. That's something that should only be done if there are certain nasty types of corruption/database damage and no backup. If can...
December 16, 2009 at 11:35 am
one-1016367 (12/16/2009)
I must conclude that missing rows or counting them twice isn't a very likely scenario, but the fact that it can happen at all is very interesting. 🙂
That was...
December 16, 2009 at 11:34 am
El RoboCopo (12/16/2009)
One-off SHRINKING IS NOT POSSIBLE with more than 6000 databases.
Why not? If you've done an unusual archive/data deletion on a database, you'd know about it and could...
December 16, 2009 at 11:33 am
It is not possible to create a primary key on columns that have duplicates, it is not possible to insert duplicate values for a composite primary key.
However using nolock can...
December 16, 2009 at 6:32 am
Jeff Moden (12/16/2009)
Bhavesh_Patel (12/16/2009)
Is there a simple way,...
December 16, 2009 at 6:25 am
Viewing 15 posts - 35,236 through 35,250 (of 49,552 total)