Viewing 15 posts - 35,236 through 35,250 (of 49,552 total)
Are you using SQL 2005 enterprise edition?
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
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...
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
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...
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
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.
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
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...
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
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...
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
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...
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
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
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
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,...
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
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...
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
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...
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
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...
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
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...
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
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...
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
December 16, 2009 at 6:32 am
Jeff Moden (12/16/2009)
Bhavesh_Patel (12/16/2009)
Is there a simple way,...
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
December 16, 2009 at 6:25 am
Viewing 15 posts - 35,236 through 35,250 (of 49,552 total)