Reputation
30,658
Next tag badge:
93/100 score
23/20 answers
Badges
5 63 112
Newest
 Nice Answer
Impact
~2.4m people reached

Jun
5
comment Move database files if database runs
The following points need to be clarified: What do you mean when you say "if the database runs"? What do you want to move and when? What do you mean by "if done then switch between DB files"? Right now, your question doesn't make much sense to me.
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.