Reputation
29,985
Next tag badge:
97/100 score
24/20 answers
Badges
5 62 107
Newest
 Enlightened
Impact
~2.1m people reached

Jun
5
comment Can I install SQL Server 2012 on a machine with 2008 R2 already?
+1 Here's also a lot of great considerations for side-by-side instances, and depending on what the major and minor versions it'll point out shared items and possible contention. SQL Server 2012 isn't mentioned, but the ideas remain the same: technet.microsoft.com/en-us/library/ee210714(v=SQL.105).aspx
Jun
4
revised How should I best handle a rapidly growing database?
added 4 characters in body
Jun
4
answered If I update a column record in a table, will indexes that do NOT have this column in it be affected?
Jun
4
awarded  Nice Answer
Jun
4
revised Why don't databases create their own indexes automatically?
edited tags
Jun
4
revised How should I best handle a rapidly growing database?
edited title
Jun
4
answered How should I best handle a rapidly growing database?
Jun
4
comment Strategies for summary data in parent record based on detail data?
"...but it does require reading all the records in CustomerOrders." So? I'd take this approach instead of embedding unneeded data. Set-based queries, tuned as good as possible, will be your best bet in my opinion.
Jun
4
comment Why don't databases create their own indexes automatically?
@FreshPrinceOfSO DBA...DBDev....data professional. If you think outside of that, then please expand.
Jun
4
answered Why don't databases create their own indexes automatically?
Jun
4
comment TempDB MDF file huge after update script ran
support.microsoft.com/kb/307487
Jun
3
comment Execution Plan not matching Stored Proc
Ha good eyes! +1
Jun
3
comment Execution Plan not matching Stored Proc
Do you have some sample DDL (CREATE TABLE and INSERT INTO commands) for these two tables to test with?
May
31
comment Linked Server Login Timeout but SqlCmd works
Could be a Kerberos problem. Can you verify the necessary SPNs are created? You can use the new Kerberos tool for SQL Server: microsoft.com/en-us/download/details.aspx?id=39046
May
31
awarded  Popular Question
May
31
awarded  sql-server
May
30
revised Autogrow. Primary vs additional data files
edited tags
May
30
answered Autogrow. Primary vs additional data files
May
30
comment Do I really need to keep .LDF files?
@Nurgle I just tried the link and I see it no problem. You may need to be registered on the site to read the article, I'm not sure. But it works on my end.
May
30
comment Verify Query Request Received
Sure. Monitor the SQL:StmtStarting event then.