Reputation
5,158
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
22 60
Newest
 Caucus
Impact
~257k people reached

5h
awarded  Caucus
Jul
24
comment Should I use ReFS for a new SQL Server
at this point i'd say that there's no compelling reason to move from NTFS. the real advantage is tied to the integrity stream checks which you have to disable for the sake of SQL Server.
Jul
23
comment SQL Server : Tracking a slow running query on completion
for the exact statement you'd relate the two based on the sql_handle (assuming you've captured that). for similar queries, you'd related the two based on the query_hash.
Jul
23
comment Do Triggers in the Active Secondary Database of an AlwaysOn Group Execute?
The documentation language is a bit muddy, but it seems like it's saying that if you have triggers on objects, they're going to fail if a user/process fires that trigger on a non-primary database Therefore, build a check into the trigger to determine if this is the primary database and only execute if it is.
Jul
20
comment Why are these two HADR DMVs reporting different states?
i'm seeing NOT_HEALTHY on both the SYNC and ASYNC replicas.
Jul
20
revised Why are these two HADR DMVs reporting different states?
added 347 characters in body
Jul
20
asked Why are these two HADR DMVs reporting different states?
Jul
1
comment Creating Stored Procedure with TableName as parameter
... also make sure you you use identifiers
Jun
16
comment How to pass parameter in select query(In with clause) and not in where condition in SQl Server SSIS Package?
missing complementary @dis1 variable
Jun
16
comment LinqToSql query is having intermittent problems
please post the sql that it's generating.
May
29
comment Using NOCOUNT to Improve Procedure Performance
@AaronBertrand i swam competitively in high school. i never once shaved my knuckles. perhaps that's why i never got a scholarship.
May
29
comment How do you see which database on a Server uses most resources
@MaxVernon i was young and dumb. also, i lifted the base code from Kimberly Tripp :)
May
29
awarded  Nice Answer
May
29
awarded  Nice Answer
May
29
comment Dealing with Difficult DBAs
just remember that what you perceive as efficient may actually be inefficient from another's perspective. i'd recommend actually talking through things with the DBAs in question. you may learn something along the way.
May
28
comment System.OutOfMemoryException SQL Server 2012 and 2008R2
if only microsoft packaged a free reporting tool that allowed users to save/export query results as csv/text/excel. perhaps one of these days they'll see the light. i'd suggest that they name it "sql server reporting services" so that people could clearly identify its function
May
26
awarded  Popular Question
May
26
comment Should I delete disabled windows Active Directory accounts from SQL 2008?
ideally you would have this set up through AD and remove SQL from the equation altogether. create groups in AD that have the permissions sets that are required (and nothing more), and then have your AD admin manage from there. employee leaves the company? disable account and remove from groups.
May
25
comment Do I need a database license for my application?
Community edition for visual studio is also an option
May
22
comment Trace Flag 4199 - Enable globally?
Have you read through the changes enabled by the flag to see if they'd be of benefit to you?