Reputation
1,877
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
2 11 27
Impact
~164k people reached

Apr
29
revised How to find the AD user that logged in to SQL Server using SQL Login
Defiantly a SQL server question.
Apr
29
comment How to find the AD user that logged in to SQL Server using SQL Login
Could you please further clarify the question.
Apr
29
suggested approved edit on How to find the AD user that logged in to SQL Server using SQL Login
Apr
22
revised Should I disable HyperThreading
added 765 characters in body
Apr
20
comment Should I disable HyperThreading
I'm not suggesting that cxpacket waits are a sign of a problem. What I want to know is if hyper threading can cause these spikes in context switches, and if those switches can negatively impact parallel queries
Apr
20
comment Should I disable HyperThreading
@kin high performance is set currently.
Apr
20
comment Should I disable HyperThreading
To piggyback on @aaronbertand 's comment. Current Maxdop is 8 for 32 logical cores. I'll have to double check the cost threshold as I don't recall the number off hand.
Apr
20
asked Should I disable HyperThreading
Mar
19
comment Large Variation in Bulk Insert time
Can't post table definition but it's information a out imaged documents.
Mar
16
comment Large Variation in Bulk Insert time
@Kin We have told SSIS that it is Sorted.
Mar
16
revised Large Variation in Bulk Insert time
added 306 characters in body
Mar
16
comment Large Variation in Bulk Insert time
@DanielHutmacher this was on a UAT server so it's simple recovery with no backups. It's restored from a production copy nightly.
Mar
16
comment Large Variation in Bulk Insert time
No the logs are on a different drive. Raid Controller is PERC H800 with 1 GB cache size. (For UAT) Prod is a PERC(810)
Mar
16
revised Large Variation in Bulk Insert time
added 571 characters in body
Mar
16
comment Large Variation in Bulk Insert time
Local. Raid controlled drives.
Mar
16
asked Large Variation in Bulk Insert time
Mar
9
comment Find the missing numbers in a given range
Join to a numbers table. Then just return the values that have NULL where your columns are and limit the range. Without seeing what you're actually doing and what you've attempted this is the best I can give you.
Mar
9
comment Can there be situations where using (noexpand) on an indexed view is undesirable?
Depends on how up to date your SQL server is. I know this probably isn't what you mean but it's the only negative I could think of.
Mar
9
revised SELECT DISTINCT TWO columns not ranged
I don't like scrolling.
Mar
9
suggested approved edit on SELECT DISTINCT TWO columns not ranged