Nov
28
revised Using computed column in CharIndex
Moved wild card to end for first name.
Nov
27
revised Using computed column in CharIndex
added 28 characters in body
Nov
27
revised Using computed column in CharIndex
added 195 characters in body
Nov
21
revised What's a good use case for SELECT * in production code?
added 200 characters in body; added 27 characters in body
Nov
19
revised msdb.dbo.sp_send_dbmail temp table does not exist
General clarity, asked an actual question, formatting.
Nov
11
revised Calculate nth business day of the current month
edited tags
Nov
11
revised How to find difference between two columns in one table across the rows (T-SQL)?
added 519 characters in body
Oct
25
revised Is fragmention limited to indexes in sql server?
deleted 30 characters in body
Oct
24
revised What is the best way to check for matching sets of rows?
added 395 characters in body
Oct
24
revised What is the best way to check for matching sets of rows?
added 235 characters in body
Oct
24
revised What is the best way to check for matching sets of rows?
added 63 characters in body
Oct
24
revised What is the best way to check for matching sets of rows?
added 77 characters in body
Oct
22
revised How to copy table content before deleting to flat file using BCP
added 149 characters in body
Oct
17
revised Why would shrinking TEMPDB log lead to slowness?
added 431 characters in body
Oct
16
revised How can I find where FK = PK in the same table?
added 51 characters in body
Oct
16
revised DB Maintainance Job Fails Single User Mode
added 156 characters in body
Oct
16
revised Backup too big to restore
added 8 characters in body
Oct
15
revised Why would shrinking TEMPDB log lead to slowness?
added 151 characters in body
Oct
15
revised Why would shrinking TEMPDB log lead to slowness?
added 151 characters in body
Oct
15
revised Sql query to Clear existing email addresses from table
added 10 characters in body