2010-10-04 (first published: 2010-09-29)
2,901 reads
Atif-ullah Sheikh
Way to Check Multiple LIKE without dynamic SQL
I was asked to do so by one of my colleague. So, I thought to share it with you how to use multiple LIKE conditions.
2010-09-16 (first published: 2010-09-15)
3,552 reads
2010-07-27 (first published: 2010-07-09)
2,156 reads
2010-07-20 (first published: 2010-06-23)
2,562 reads
Parsing / breaking character separated values in a table in one query
At times, we have situation to parse the character separated string in the table column.
2010-07-14 (first published: 2010-06-17)
2,177 reads
Get default values of parameters in stored procedures
Helps to get the default value of parameters from stored procedures and functions.
2010-06-22 (first published: 2010-05-26)
2,362 reads
Blogs
Power BI Meets Programmability – TOM, XMLA, and C#
By DataOnWheels
For anyone who read the title of this and immediately thought, “Oh no, I...
Do Full Backups Break Log Shipping?
By Kevin3NF
TLDR: Nope. Keep on doing your full backups. Make sure that any databases you...
Daily Coping 15 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Disabling all access to the server
Hello everyone! We have a small group of users (4) using MS Access 2000...
How to remove data and index fragmentation in a table
The picture is showing the results that I used sp_spaceused for OldTable and NewTable,...
Database Recovery but DB is 7GB and log file is almost 3
I have had a server crash and although I was able to recover the...
Ask SSC