Steven Whaley

Retrieve SQL Instance Connect Info

This script quickly returns Server Name, Cluster Node, Default Drive Letter for MSDB database, IP address and port

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (2)

You rated this post out of 5. Change rating

2013-04-11 (first published: 2013-03-24)

1,449 reads

Recently a customer asked how they could get index changes to be captured in...

giltwrights – n. the imaginary committee of elders that keeps a running log of...

Hey folks, fun personal post today. A few weeks ago, I got married! My...

USE [DBName] SELECT QUOTENAME(SCHEMA_NAME(sOBJ.schema_id)) + '.' + QUOTENAME(sOBJ.name) AS [TableName] , SUM(sPTN.Rows) AS [RowCount]...

Comments posted to this topic are about the item Backing Up Master

Comments posted to this topic are about the item Window Function Basics - PARTITION...