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
824 reads
I make a point of reading DBAReactions on a fairly regular basis and today while reading it I was lead...
2013-07-17
824 reads
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,539 reads
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,181 reads
A little while back I wrote Best practice recommendations for writing Dynamic SQL where I made a number of suggestions...
2013-07-01
2,708 reads
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,417 reads
What is a metadata function? According to BOL a metadata function is one that returns data about the database or...
2013-06-24
799 reads
I’m going to get slammed for the title by someone but I stand by it. First some definitions.
Disaster Recovery...
2013-06-20
930 reads
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,767 reads
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,566 reads
Over the last few years I’ve learned quite a bit about different techniques in SQL Server. This particular one has...
2013-06-10
679 reads
By Brian Kelley
I did a post last month titled RTO and RPO are myths unless you've...
By Steve Jones
ioia – n.the wish that you could see statistics overlaid on every person you...
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
First off, my apologies for what could potentially be a bad title! I am...
I've inherited a couple of rather large databases from my ex-colleague when I join...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers