Viewing 15 posts - 33,571 through 33,585 (of 49,552 total)
Google might be a good bet for him. Seems like he has lots of questions
http://www.sqlservercentral.com/Forums/Topic880137-146-1.aspx
http://www.sqlservercentral.com/Forums/Topic880152-146-1.aspx
March 10, 2010 at 6:42 am
http://www.sqlservercentral.com/articles/Indexing/68439/
http://www.sqlservercentral.com/articles/Indexing/68563/
http://www.sqlservercentral.com/articles/Indexing/68636/
http://msdn.microsoft.com/en-us/library/ms180978.aspx
http://sqlinthewild.co.za/index.php/category/sql-server/indexes/
March 10, 2010 at 6:41 am
Copy only backups have nothing to do with sparse files. Sparse files are used in database snapshots.
You're going to have to give a lot more details as to what you're...
March 10, 2010 at 6:39 am
TheSQLGuru (3/10/2010)
March 10, 2010 at 6:36 am
Chris Morris-439714 (3/10/2010)
Yes. In Swindon, computers change hands too quickly for any serious development to take place.
Sounds like Johannesburg. I'd probably feel right at home there.
March 10, 2010 at 6:20 am
I'll give my standard answer here.
Memorising questions will not help you in an interview. An experienced interviewer can easily tell the difference between someone who knows the material and someone...
March 10, 2010 at 6:18 am
Could you perhaps be a little more specific?
March 10, 2010 at 6:11 am
Pretty much nothing.
Distribution might grow, because of having to retain transactions.
March 10, 2010 at 6:10 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic880119-391-1.aspx
March 10, 2010 at 6:10 am
Indexes are essentially duplicate copies of data (think index at the back of a text book). Since the data's repeated, inserts and updates have to do more work.
How much more?...
March 10, 2010 at 12:57 am
Grant Fritchey (3/8/2010)
An unique index and a unique constraint are the same thing (in fact, creating a unique constraint creates a unique index).
Except for 2 points
Unique index can have include...
March 10, 2010 at 12:53 am
GTR (3/9/2010)
DBCC shrinkdatabase with notruncate first to compact pagesDBCC Shrinkdatabase with truncateonly option to free disk for OS
What's the reason for doing them separately when running Shrinkdatabase without options...
March 10, 2010 at 12:25 am
Just one point...
http://support.microsoft.com/kb/307487
From said article:
IMPORTANT: If you run DBCC SHRINKDATABASE, no other activity can be occurring with the tempdb database.
March 10, 2010 at 12:17 am
Partitioning's not in Standard Edition
March 10, 2010 at 12:13 am
Viewing 15 posts - 33,571 through 33,585 (of 49,552 total)