2010-10-04 (first published: 2010-09-29)
2,899 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,518 reads
2010-07-27 (first published: 2010-07-09)
2,152 reads
2010-07-20 (first published: 2010-06-23)
2,559 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,174 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,205 reads
Blogs
Renaming Files by Padding Numbers with PowerShell
By Steve Jones
Some time ago I had downloaded all the SQL Saturday XML files. I’ve been...
When do Statistics get updated?
Statistics objects are important for allowing the SQL Server Optimizer to make good estimates...
Power BI: Making Date & Time Keys
By DataOnWheels
Saving the Day from Delay Part 2 Creating DateKey and TimeKey columns can be...
Forums
Date format - being overridden?
Hi all, Got a strange one here that I hope someone can help with....
Best way to understand Querying much better
What's the best way to get better at T-SQL Querying? Something like Read/do the...
Intermittent "nesting level exceeded" error
We're having a very peculiar problem with the "Maximum stored procedure, function, trigger, or...
Ask SSC