J. T. Shyman


SQLServerCentral Article

Using XP_EXECRESULTSET To Obtain Database Size Information and More

Have you ever used XP_RESULTSET in SQL Server? If you're like most DBAs, this procedure is rarely used and can be a little complicated to setup. New author J. T. Shyman brings us a look at just how useful this command can be in executing a command on every database.

You rated this post out of 5. Change rating

2006-06-27

12,839 reads

Blogs

Spark Connect Dotnet Variant Data Type

By

All Spark Connect Posts I recently published the latest version of the Spark Connect Dotnet...

A New Word: Opia

By

opia – n. the ambiguous intensity of eye contact The entry for this says...

Friday Flyway Tips: Searching a Migration

By

This was actually a cool tip I saw internally from one of the product...

Read the latest Blogs

Forums

restore a cdc db from 2016

By Sailor

RESTORE DATABASE [mydb] FROM DISK = N'e:\sqlbackups\mydb.bak' WITH FILE = 1, keep_cdc, NOUNLOAD, REPLACE,...

Serverless Gets Faster

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Serverless Gets Faster

sqlclient data provider .net provider connection

By jaango123

I have a task to check the connection managers as part of ssis integration...

Visit the forum

Question of the Day

Statistics Histograms

I have a statistics objects with 2 key columns from my tables. How many histograms and their type are stored?

See possible answers