Comparing the contents of two tables
I’ve been working on tuning a query for the last week and I’ve had to make several changes to the...
2016-05-16 (first published: 2016-05-12)
3,569 reads
I’ve been working on tuning a query for the last week and I’ve had to make several changes to the...
2016-05-16 (first published: 2016-05-12)
3,569 reads
One of the things I like best about joining in on Adam Machanic’s (b/t) TSQL Tuesday blog party is that...
2016-05-10
498 reads
It always amazes me how often these three commands get confused. Heck it amazes me how long I confused them....
2016-05-04
900 reads
You have a database with one or more filegroups, and one or more of those filegroups has multiple files. You’ve...
2016-05-02
1,626 reads
Oh Noes! I have a job that requires me to run an SSIS package, cmdshell script, etc. And I need...
2016-04-27
2,571 reads
I’m a big fan of certifications as a training exercise. However not everyone has the same interests. With the new...
2016-04-25
1,823 reads
Me: I think I’m going create a new playground instance.
Myself: Make sure you use a case sensitive (CS) collation when...
2016-04-20
411 reads
Everyone makes mistakes right? And sometimes you create an object and decide later that you messed up and need to...
2016-04-18
468 reads
It’s T-SQL Tuesday again and this month we are hosted by Jens Vestergaard (b/t) who want’s us to talk about...
2016-04-18 (first published: 2016-04-12)
1,668 reads
I love this somewhat obscure mathematical operator. All it does is return the remainder of a division statement but even...
2016-04-14
492 reads
By Chris Yates
I get asked a lot about why or how I began working with databases...
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Comments posted to this topic are about the item SQL Server 2025 Unveiled: The...
Hi, we lost our sever sql2000 To restore database to a new one we...
Comments posted to this topic are about the item Do You Really Need HA?
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers