Reputation
3,038
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
7 20
Newest
 Yearling
Impact
~73k people reached

16h
answered Why would SQL Server remain unresponsive after a slow query completes?
1d
comment Can SQL Server Audit be used to track hostnames or IP adresses of the users performing DML on a table?
@Shanky hmm... it's a LOT of code and explanation. I don't think I can do that. I can do my best to keep it running and URLs unchanged instead. I understand that link-only answers are discouraged, but there's a line to draw at some point. I provided an overview of the technique and a link to the code: I think it's enough.
1d
answered Can SQL Server Audit be used to track hostnames or IP adresses of the users performing DML on a table?
2d
answered Totals(sums/counts) across multiple child tables query optimization
2d
comment Using a Linked Server to import data from Excel
Why not investigate that "some reason" instead? SSIS is the suggested way to import/export data to/from SQL Server. Linked Servers have security/stability and performance issues. They're actually good for transfering small amounts of data and perform distributed transactions in T-SQL.
2d
comment How to measure the performance improvement that NUMA brings?
Enterprise edition is hardly about performance: it's in general HA/DR or manageability features (with some exceptions).
Aug
27
answered How to backup the current code of a stored procedure and its permissions as well?
Aug
26
answered How is an idle SQL Server connection causing blocking?
Aug
26
answered Setting maxdop 1 vs setting the threshold for parallelism high
Aug
26
revised Using mysqldump and command line client
removed inappropriate sqlserver tag
Aug
26
revised how to get the information about sleeping processes that are causing blocking?
added 120 characters in body
Aug
26
answered how to get the information about sleeping processes that are causing blocking?
Aug
26
comment Translate query using APPLY to run under compatibility level 80
What do you mean with "I need it compatible level 80"? Can't you run the query in a database with compatibility level 90 or higher, such as tempdb?
Aug
24
comment “Specify SQL Server administrators” - unusual default value
There is a way to impersonate a service SID. Take a look at this: sqlblog.com/blogs/argenis_fernandez/archive/2012/01/12/…
Aug
24
answered “Specify SQL Server administrators” - unusual default value
Aug
24
comment How to resolve COM server application local activation permission for machine account
The error message seems to indicate so. Why is this surprising to you? NETWORK SERVICE means that the service will try to access external resources using the machine account. In the DCOM config, it is not different from any other users.
Aug
23
awarded  Yearling
Aug
3
awarded  Constituent
Jul
28
awarded  Caucus
Jul
7
comment should we keep the log file or the data file on the fastest drive?
@AaronBertrand agreed. Thanks for pointing it out