Cade Bryant

Modified sp_who - more info & extra parameter

This procedure, sp_who3, is based on the system-supplied sp_who2, but is modified to return the actual text of the commands executed by each spid.  Very helpful for troubleshooting!  In addition, I have added a @hostname parameter to allow the user the option of viewing activity originating from only one computer, if desired.

2004-05-06

628 reads

Parsing an IP address into its separate octets

IP addresses are represented as xxx.xxx.xxx.xxx, where xxx is an integer between 0 and 255.  Each three-digit integer is called an octet, and all IP addresses comprise four octets.Help-desk applications and administrative tools often store the IP addresses for a company's PCs in a database.  An IP address can be represented either as a single […]

2.5 (2)

2004-02-25

756 reads

Creating a Dynamic Crosstab Query

Crosstab queries (also called "pivot tables") in which you know beforehand the number of column values to aggregate by, can easily be performed in T-SQL using CASE statements wrapped in the SUM function.  Where things get tricky, however, is when you don't know how many aggregation values exist, and you are required to write a […]

5 (1)

2003-09-26

2,748 reads

A faster way to count rows in a table

SQL Server includes the COUNT function for counting a table's rows - however, it can be slow.  Although querying the "rows" column from the sysindexes table is faster, it is not always accurate (e.g., if a bulk load process has recently taken place).  In addition, you would not be able to use this method in […]

1.33 (3)

2003-09-11

380 reads

A more efficient ForEach routine

SQL 2000's sp_MSForEachDB and sp_MSForEachTable are useful procedures for performing operations against multiple objects; however, they aren't always extremely efficient, because internally they use cursors to do their work.These 2 sprocs, sp_ForEachDB and sp_ForEachTable, perform many of the same tasks as their Microsoft-shipped twins, but run faster because they dynamically build the SQL string without […]

5 (1)

2003-08-19

2,198 reads

Blogs

Quick Blog: Making the Power BI PowerShell cmdlets easier to use

By

One of the top reasons I love PowerShell so much is that from the...

Trouble writing? Join the club. #JustWriteTech

By

I was talking with  a couple of excellent SQL people* recently, and we were bemoaning...

Check Query Progress with Live Query Stats

By

This is something I touched on back in 2017 a little after the Live...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Printing the String

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Printing the String

how to list index corresponding to statistics using select statement

By ebooklub

Hi , with query bellow I  can list DTA  statistic that is not updated...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers