• Interests: Classical music (especially Bruckner and Shostakovich), beer, fishing, whiskey, theology, wine, trombone, martinis, not necessarily in that order.

Technical Article

Bitmap an Integer Value

Do you hate using bitwise operands?  I do, a lot.  I wrote the following function to try to minimize the need for using them.  When testing 'status' variables in the 'sysobjects' table, for example, I decided there just had to be an easier way to see if bit 31 is set than asking if STATUS […]

You rated this post out of 5. Change rating

2003-03-07

657 reads

Blogs

Enabling an Index: #SQLNewBlogger

By

I don’t do a lot of work with disabled index, but I learned how...

Back to Boston for SQL Saturday

By

I’m leaving again tomorrow for a trip. This time I head back to Boston...

T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?

By

Most of us who work with data have, at least a few times, been...

Read the latest Blogs

Forums

How are statistics stored?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How are statistics stored?

Where's the Printer Friendly Option?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Where's the Printer Friendly Option?

Switch from MSSQL SVC to MSA - Unable to start services

By sunilgk595@gmail.com

Using MSSQL 2019 standard edition It was installed using SVC Account. But now I...

Visit the forum

Question of the Day

How are statistics stored?

How are the statistics for query optimization stored in SQL Server?

See possible answers