Reputation
4,852
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
3 26 40
Impact
~350k people reached

Apr
21
revised Rstudio (on Linux) Connectivity to SQL Server 2012
deleted 5 characters in body; edited title
Apr
21
revised SQL Server 2008R2 - BAK file backup performance issue
added 7 characters in body; edited title
Apr
21
revised Help undoing an accidental restore on SQL Server 2014
deleted 29 characters in body
Apr
21
revised Windows Authentication fails with “Cannot generate SSPI context”
added 10 characters in body
Apr
21
revised Patching SQL Server 2012
edited body; edited title
Apr
15
revised Query against sys.schemas and sys.synonyms runs very slow for one user
added 61 characters in body
Apr
15
revised calculate a column based on existing columns
deleted 25 characters in body
Apr
15
revised Query orders in recent 5 years
added 4 characters in body
Apr
15
revised Query orders in recent 5 years
added 5 characters in body
Apr
15
revised Autocomplete in SQL Server Management Studio showing too much
added 30 characters in body; edited title
Apr
15
revised How to get one MAX() between SUMs of several columns in SQL?
added 10 characters in body; edited title
Apr
15
revised SQL Server: migrating masters databases between clusters by detaching/attaching them
edited body; edited title
Apr
15
revised Tempdb log file was growing continuously on SQL Server 2008 R2-SP2. Could a pending insert statement which uses temporary table be a cause?
edited title
Apr
15
comment Use of Trigger on table which can have 100 hits / second. Will it hamper performance?
Make sure to keep your trigger very lightweight and nimble - do NOT do any heavy lifting (massive calculations) or time-consuming tasks (like sending e-mails, calling external web services) in your trigger. And make sure to use a proper, set-based approach to writing your trigger - DO NOT use a cursor inside your trigger! Be aware that the trigger will be called once per statement and that your Inserted (and Deleted) pseudo tables will contains multiple rows!
Apr
15
revised T-SQL script doesn't delete files when run as an agent job - does if run manually
added 1 character in body
Apr
15
revised Changing database name based on project environment
deleted 9 characters in body; edited title
Apr
15
answered Get Stored Procedure Result Column Types
Apr
15
revised Get Stored Procedure Result Column Types
deleted 8 characters in body
Apr
12
revised Reporting Services Configuration Manager - error message “Could not connect to server…server was not found..”
added 5 characters in body
Apr
12
revised I run the script and it freezes me but varchar(max) and nvarchar(max) -1 always the ones with throws. How max turns -1
added 67 characters in body