Nov
19
revised How to get rid of comma if no other value comes after the string
added 90 characters in body
Nov
19
revised How to get rid of comma if no other value comes after the string
added 81 characters in body
Nov
12
revised check linked servers database status
Code formatting
Aug
19
revised Log file won't shrink - suggestions?
added 17 characters in body
Jul
24
revised Non Clustered Index using INCLUDE
deleted 23 characters in body
Jul
15
revised alwayson read only routing
added 180 characters in body
Jul
11
revised Get ids only where one id is null and other isn't
added 76 characters in body
May
21
revised Example of MS Access SQL IIF to T-SQL
added 283 characters in body
May
2
revised SQL Extended Events Session for deadlock detection
added 341 characters in body
Feb
20
revised Questions on database table and index partitioning in SQL Server
added 4 characters in body
Feb
18
revised Datetime conversion fails when filtered index is placed on partition column
added 447 characters in body
Feb
18
revised Datetime conversion fails when filtered index is placed on partition column
added 447 characters in body
Feb
5
revised Query where condition take from the list of value
added 154 characters in body
Feb
4
revised How to find tempdb reside in drive location with drive size and tempdb usage details in single query in sql server?
added 86 characters in body
Jan
9
revised Operand data type time is invalid for add or subtract operators
edited body
2018
Dec
4
revised Removing duplicates values with join
deleted 5 characters in body
Nov
27
revised Slow query on large table with 50M plus data (especially with larger offset)
added 12 characters in body
Oct
9
revised Log shipping - Bulk logged recovery mode doesn't log bulk operations, yet it is allowed for Log Shipping config? Why?
added 28 characters in body
Jun
19
revised How to set space usage alert for database using SQL Server 2012 with Amazon RDS as managed service?
added 2 characters in body