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
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
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/
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
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...
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
March 10, 2010 at 6:39 am
TheSQLGuru (3/10/2010)
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
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.
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
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...
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
March 10, 2010 at 6:18 am
Could you perhaps be a little more specific?
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
March 10, 2010 at 6:11 am
Pretty much nothing.
Distribution might grow, because of having to retain transactions.
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
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
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
March 10, 2010 at 6:10 am
http://www.sqlservercentral.com/articles/Indexing/68563/
http://www.sqlservercentral.com/articles/Indexing/68636/
http://sqlinthewild.co.za/index.php/2008/09/23/do-wide-indexes-slow-queries-down/
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
March 10, 2010 at 5:58 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?...
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
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...
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
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...
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
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.
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
March 10, 2010 at 12:17 am
Partitioning's not in Standard 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
March 10, 2010 at 12:13 am
Viewing 15 posts - 33,571 through 33,585 (of 49,552 total)