Do *not* place TEMPDB on a local disk in a SQL failover cluster
What happens with tempdb on a local disk in a cluster? Read on to see that you will not get a failover if the local disk fails
2021-01-04
8,086 reads
What happens with tempdb on a local disk in a cluster? Read on to see that you will not get a failover if the local disk fails
2021-01-04
8,086 reads
This article shows how to download sqlserverbuilds.blogspot.com to build your own automated sql patch level check.
2020-12-24 (first published: 2017-07-03)
4,937 reads
Generate an HTML page with the timeline of your SQL jobs using Google graph and sp_send_dbmail
2016-10-28 (first published: 2015-07-28)
17,067 reads
This is an version independent stored procedure to get the backup date from a backup file.
It's tested for SQL 2005, 2008(R2), 2012 and 2014.
Consider it a template to which you can add more output parameters from the headerinfo to meet your requirements.
2016-04-21 (first published: 2016-03-31)
341 reads
This script generates a graphical timeline of all SQL jobs with a variable zoom level
2015-09-17 (first published: 2013-01-14)
6,094 reads
2015-05-13 (first published: 2013-03-14)
6,038 reads
Be carefull when replacing a defective (FLASH) storage device, its sector sizes may vary without you knowing it.
2011-12-27
4,406 reads
There are many ways 2 compare datasets to find differences, this is one of them.
2011-11-04 (first published: 2011-10-21)
2,270 reads
This SQL script returns a recordset with all the index information for all tables for all databases in a SQL server(instance)
2006-10-30 (first published: 2005-10-07)
2,522 reads
This SQL script returns a recordset with all the index information for all tables within a database
2005-10-18 (first published: 2005-10-07)
855 reads
One of the nice things about the Microsoft Connector for Oracle is that it...
By Steve Jones
I get asked questions by salespeople all the time. Usually this is because a...
By Steve Jones
jouska – a hypothetical conversation that you compulsively play out in your head –...
Hi folks I would like to get your views about partitioning a huge table...
Introduction to SQL Website Development What is SQL? Importance of SQL in web development...