(Rohit Garg) Some days back, I received one query on my facebook page that user want to create Database Snapshot frequently & want to delete the oldest with same frequency. Quite interesting scenario. I did not go in deep why he has such requirement but I am clear that It can be done very easily.

(Nakul Vachhrajani) Informational and alert messages during execution of a T-SQL script are the most preferred method to update the user on the progress of the task being executed. These messages are generated by the various PRINT statements embedded in the script.

(Pinal Dave) Yesterday we discussed about the Basics of Delayed Durability in SQL Server 2014. Today we will learn one more topic about this subject – How to Setup Delayed Durability for SQL Server 2014?

(David Dye) MSDN documents the log chain as: A continuous sequence of log backups is called a log chain. A log chain starts with a full backup of the database. Usually, a new log chain is only started when the database is backed up for the first time or after the recovery model is switched from s

(Percy Reyes) When we are querying SQL Server tables with/without the NOLOCK hint we may get a page corruption error like this: “Could not continue scan with NOLOCK due to data movement”. Today we will learn how to deal with this issue.

(Chris Webb) Market basket analysis is a fairly well understood problem for SSAS – it’s best handled using many-to-many relationships, as shown in the excellent The Many-to-Many Revolution white paper. However the other week I was asked a question that was an interesting variation on this problem,

(John Pertell) I’m in the process of reviewing my notes and demos for my upcoming session, Introduction to FileTables, at SQL Saturday Orlando. There’s a few things I’ve been meaning to write about, so this post will be on some of the topics I’ve skipped. Some have come from questions I’ve be asked,

(Kenneth Fisher) Trace flags are one of those things that I’ve heard about more and more over the last five or six years. But only in the past year or so have I started to understand what they are and how to use them

(Charles Sterling) Almost everyone who IT Operations for a large company can tell you war stories about apps whose performance died within 18 mths of going live. Many don’t even last 6 mths.

(Andrew Pruski) Who are your worst offenders? By offenders I mean, queries that are consuming the most resources on your server(s).