2010-10-04 (first published: 2010-09-29)
2,912 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,770 reads
2010-07-27 (first published: 2010-07-09)
2,161 reads
2010-07-20 (first published: 2010-06-23)
2,575 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,188 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)
3,329 reads
Blogs
The trade-offs associated with low-code solutions
Low-code solutions often accelerate development and make tasks accessible to people who can’t or...
Monday Monitor Tips: Looking Back in Time
By Steve Jones
Often we find out about a problem reported by a customer after the incident...
Can You Tell Why a Plan Didn’t Go Parallel?
Let’s face it, most of the time, you probably don’t want your SQL Server...
Forums
Where to see how a Partition schema and function is defined
Please see the below. The dependencies of a table(the table depends on) shows Partition...
Is there a way to determine an Azure Data Factory Trigger's "next run time"?
Many job schedulers (e.g., SQL Agent, Airflow, Azure Logic Apps) can report when a...
The Table Backup
Comments posted to this topic are about the item The Table Backup
Question of the Day
The Table Backup
I run this code in SQL Server 2022. What happens?
BACKUP TABLE beercount TO DISK = 'beercount.bak'See possible answers