Reputation
5,138
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
22 59
Newest
 Nice Answer
Impact
~248k people reached

2d
comment Creating Stored Procedure with TableName as parameter
... also make sure you you use identifiers
Jun
25
comment How to recover a database?
DAMMIT JIM! I'M A DBA, NOT A WORD-PROBLEM SOLVER.
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?
May
22
comment LDF files vs. TRN files vs. Tempdb.MDF+LDF files.:
You mention that this is "in a virtual environment, so it’s more than likely all of these drives are all on the same array anyway" but I think that's a rather important fact. What's your hypervisor? How is the host connected to the storage (fiber channel? iscsi?)? How is the storage provisioned within the hypervisor (e.g. do you have multiple guests sharing one big storage container? do you have separate storage allocated to each guest? if vmware, are they vmdk? are you using raw device mapping?)? how many guests are on the host? etc.
May
18
awarded  Necromancer
May
11
awarded  Good Answer
Apr
28
comment high PAGEIOLATCH_SH waits on server
Which question do you want answered? The PAGEIOLATCH_SH question or how to optimize the query. My sense is that they're related (you're getting the page latch waits because you're doing some large scans due to inefficient index usage). Please post the actual execution plan (not as a picture).
Apr
23
awarded  Notable Question
Apr
16
revised SQL Script - SSMS Good, Job Bad
added 1075 characters in body