Generic Dynamic SQL Stored Procedure
Recently I came across a post on http://www.StackOverflow.com that basically asked how to write a generic stored procedure to handle...
2013-07-31 (first published: 2013-07-22)
3,629 reads
SQLStudies
Amusing SQL Trick – Hide yourself from SQL Server
I make a point of reading DBAReactions on a fairly regular basis and today while reading it I was lead...
2013-07-17
838 reads
Scripting a partitioned table or index, a caution.
I was researching a problem with a partitioned table that had somehow become unpartitioned and discovered something rather interesting.
First here...
2013-07-22 (first published: 2013-07-15)
2,555 reads
Ordering steps in a SQL Agent job
Generally if I need to do any form of complicated control flow I’ll end up using SSIS, however there is...
2013-07-15 (first published: 2013-07-08)
2,195 reads
Writing Dynamic SQL (A how to)
A little while back I wrote Best practice recommendations for writing Dynamic SQL where I made a number of suggestions...
2013-07-01
2,739 reads
Using OUTPUT to back up a change
How will you back out if your change doesn’t work?! Always take a backup! There should always be a back...
2013-06-26
2,426 reads
Metadata Functions (OBJECT_NAME for example)
What is a metadata function? According to BOL a metadata function is one that returns data about the database or...
2013-06-24
844 reads
Disaster Recovery’s big brother Operational Recovery
I’m going to get slammed for the title by someone but I stand by it. First some definitions.
Disaster Recovery...
2013-06-20
942 reads
ORDER BY the numbers
Have you ever needed to order by a calculated column? You might have written it something like this:
SELECT LoginID, YEAR(HireDate)...
2013-06-19 (first published: 2013-06-17)
2,780 reads
Best practice recommendations for writing Dynamic SQL
Note this is not “Best Practices when USING Dynamic SQL”. These are just good habits I’ve come up with over...
2013-06-13 (first published: 2013-06-12)
5,593 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers