Reputation
79,170
Next tag badge:
903/1000 score
183/200 answers
Badges
10 114 221
Newest
 Nice Answer
Impact
~2.9m people reached

6h
comment Installing instances of older versions of SQL Server
@Sean mostly you just need to use the highest version. 2005's SSCM wouldn't show 2008 but the other way around was no problem.
7h
comment Installing instances of older versions of SQL Server
Engine should be fine and completely separate (though the superstitious side of me would prefer to do it the other way around). Just don't install client tools or anything - keep it to the engine. If you need visual studio, BIDS, SSDT, SSIS etc., good luck...
10h
comment SQL Server Developer Edition 2012 or 2014 - Download
Maybe you're thinking of Express Edition.
1d
comment Usage of ExecSQL in UDF?
No, unless you really like ugly hacks. stackoverflow.com/a/24434679
1d
comment SQL Server 2008 R2 - Memory Allocation
Where are you measuring 70GB? How big is your active data? What is the edition of SQL Server? What is max server memory set at? Is this a VM? Using what hypervisor? If you're using dynamic memory and Hyper-V see this post.
1d
answered How to create a dummy Linked Server in SQL Server 2012
1d
comment SQL Server 2012 - Insufficient memory to continue the execution of the program. (mscorlib)
@TomV why not post an answer?
2d
comment What is the recommended method to move databases?
Please do not use the mdf/ldf files as backups
2d
comment The module <''> depends on the missing object <''>
I'm just saying that in your first sentence you are calling a warning message an error.
May
18
comment Log File Size near 100% - How to find Active Transaction
You'll also have to accept that sometimes there is a downvote without a good reason at all.
May
18
comment Log File Size near 100% - How to find Active Transaction
Please review this conversation. You're just never going to get the feedback of why some person didn't like your answer, sorry. There was a time I agreed with you but now I agree with most that it is just noise...
May
18
comment Log File Size near 100% - How to find Active Transaction
wasn't me but people can down-vote for whatever reason they like. Age or state of the question doesn't prevent someone from finding and reading your answer, or reacting to it. Badgering people to leave a reason isn't going to have the effect you want.
May
18
comment The module <''> depends on the missing object <''>
As an aside, that's a warning message (black text), not an error (red text).
May
18
revised Load & traffic balance best practices
added 55 characters in body
May
18
revised Load & traffic balance best practices
deleted 3 characters in body; edited title
May
17
answered Load & traffic balance best practices
May
16
revised CTE Error (nvarchar to numeric)
added 158 characters in body
May
16
revised Order In WHERE Clause Matter For SARGability?
added 166 characters in body
May
16
comment Another bad execution plan!
Yes, there is a difference, highly recommend OPTION (RECOMPILE) over WITH RECOMPILE. See this post by Paul White: sqlperformance.com/2013/08/t-sql-queries/…
May
15
comment How do I pass or fail a job in SQL Server agent based on a return value from a stored procedure?
Can you define "the results"? Do you mean whether it returns an error, or returns a specific return value, or outputs a specific output parameter value, or returns a specific resultset?