Altering an indexed view will drop all indexes on it without warning, even if nothing is changed.
This will prevent accidental alters.
Script is divided into 4 parts, included testing and cleanup scripts.
2015-09-01 (first published: 2015-08-13)
981 reads
Returns server and instance information via a registered server query, regardless of SQL version.
This script is more of how to get the data, and not so much about the data returned by my choice of columns.
Tested on 2008+
2015-08-28 (first published: 2015-08-07)
1,338 reads
Retrieving XML data to Table from dm_os_ring_buffers for better readable purpose
2015-08-27 (first published: 2015-08-03)
992 reads
Generate Script from Logins of Sql Server to recreate in another instance
2015-08-25 (first published: 2015-08-10)
1,740 reads
Using Powershell, Cleanup Older than 30 days of Files & Folder through SQL Job
2015-08-24 (first published: 2015-08-04)
2,609 reads
A script to help you cleanup Files/Folders & Sub-folders.
2015-08-20 (first published: 2015-07-30)
72 reads
In this article, I would like to demonstrate about Filestream and FileTable implementation in SQL Server 2012.
2015-08-19 (first published: 2015-07-24)
1,582 reads
This script was designed to help make importing data from any SQL2008+ database to an APS much easier.
2015-08-12 (first published: 2015-07-14)
1,130 reads
2015-08-10 (first published: 2015-07-16)
1,559 reads
List Out All User Defined Triggers, along with the database where the triggers are disabled. is_ms_shipped = 1 denotes that its an user written trigger.
2015-08-06 (first published: 2015-07-07)
842 reads
By Arun Sirpal
Until now, a CRITICAL finding did the right internal routing, but the last mile...
By Steve Jones
This is actually inspired by an article SQL Server Central, which taught me something...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
I installed a new SQL server 2025 Enterprise developer edition for our development environment....
Comments posted to this topic are about the item How Clustering can be Used...
Comments posted to this topic are about the item Moving the Error Log
How can I change the location in which the SQL Server error log is written in SQL Server 2025?
See possible answers