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
9,838 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
9,838 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)
6,071 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)
18,790 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)
359 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,629 reads
2015-05-13 (first published: 2013-03-14)
7,174 reads
Be carefull when replacing a defective (FLASH) storage device, its sector sizes may vary without you knowing it.
2011-12-27
4,605 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,300 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,666 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)
864 reads
By Chris Yates
In today’s data-driven economy, organizations are no longer asking if they should invest in...
By Rohit Garg
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...
By Arun Sirpal
Do you know what happens when you enable zonal redundancy for your SQL managed...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item Databases and Disasters
Comments posted to this topic are about the item Automating SQL Server Access Review
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers