Viewing 15 posts - 31,351 through 31,365 (of 49,552 total)
Read through the material covered and make sure you're familiar with it all.
http://www.microsoft.com/learning/en/us/certification/cert-sql-server.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
August 9, 2010 at 2:00 pm
Refresh Object Explorer. It doesn't refresh automatically.
There's no 'associating' a trigger with a object in a database. When you create a trigger, you specify what table it's created on 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
August 9, 2010 at 1:45 pm
Melissa, I suspect that you're going to have to script all the foreign keys, drop the constraint and then recreate the whole lot. I tried altering a pk using CREATE...
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
August 9, 2010 at 1:33 pm
bitbucket-25253 (8/9/2010)
... or teaching him you catch more flies with honey than vinegar?
Thing is, he's not behaving that way out of ignorance. He's behaving that way because he wants 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
August 9, 2010 at 1:28 pm
blackbird (8/9/2010)
Here is what MSDN said you can do:http://msdn.microsoft.com/en-us/library/aa259130%28v=SQL.80%29.aspx
That link is for SQL 2000. Is it still relevant for SQL 2008?
I'm not sure what you are trying to change about...
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
August 9, 2010 at 1:23 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic966186-5-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
August 9, 2010 at 1:20 pm
blackbird (8/9/2010)
Why are you using a WHERE IN instead of an INNER JOIN? Generally the INNER JOIN has a better performance
It does?
http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/
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
August 9, 2010 at 1:19 pm
Why? What does shrinking in small chunks each day give you that a once off shrink doesn't? (other than a massive waste of time and resources)
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
August 9, 2010 at 10:17 am
The interval between log backups should be the maximum allowable data loss for the database. If you have no need of point-in-time recovery (restoring to point of failure), rather set...
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
August 9, 2010 at 9:45 am
dba_neo (8/9/2010)
we want to shrink it down from it's enormous size now
Do a once-off shrinkfile and shrink it down to around 170GB.
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
August 9, 2010 at 9:42 am
Shrinking will do nothing for your backups. Backups only back up used space, not empty space.
If you're going to shrink, do a once-off shrink, then rebuild all your indexes 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
August 9, 2010 at 9:05 am
(as posted over at SQLTeam)
Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.
Shrinking causes massive fragmentation and will...
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
August 9, 2010 at 8:41 am
david.r.nicholson (8/9/2010)
Could one of these dropped connections cause an index to get corrupted?
Unlikely (unless there's a bug in SQL 2000 that I've forgotten about). Vast majority of the time corruption...
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
August 9, 2010 at 7:59 am
Rebuild indexes - yes.
Update statistics - yes
Empty caches - no. You're just forcing SQL to work harder to repopulate them.
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
August 9, 2010 at 7:10 am
Brandie Tarvin (8/9/2010)
If'n anyone's in the mood to read a new webcomic:
Oh my. I wanted to murder the character by the second comic.
Here's a couple of my...
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
August 9, 2010 at 6:49 am
Viewing 15 posts - 31,351 through 31,365 (of 49,552 total)