Views are handy constructs for abstracting security and simplfying queries, but they can have unexpected results sometimes. Longtime DBA Peter He takes a look at subquery issues in views.
2008-01-02
6,681 reads
2008-02-18 (first published: 2007-12-27)
815 reads
2007-12-21
3,549 reads
2008-02-14 (first published: 2007-12-20)
1,035 reads
2007-12-18
2,938 reads
Simplify your SQL tasks by giving your queries and stored procedures the ability to iterate over arrays of table names or values.
2007-12-11
1,949 reads
This Workbench is about using Regular expressions with SQL Server via TSQL. It doesn't even attempt to teach how regular expressions work or how to pull them together. There are plenty of such resources on the Web. The aim is to demonstrate a few possibilities and try to persuade you to experiment with them if you don't already use Regex with SQL Server.
2007-12-10
4,542 reads
Just because it looks set based, doesn't mean it is. T-SQL Crackerjack Jeff Moden takes a look at a mistake that many query writers make.
2009-01-16 (first published: 2007-12-06)
60,535 reads
2008-01-28 (first published: 2007-12-03)
1,705 reads
2007-11-30
4,479 reads
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item DBCC CHECKDB Limits III
Comments posted to this topic are about the item CROSS APPLY Fundamentals: Part 1
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers