Miscellaneous

Technical Article

Drop a Column and its Constraints and Indexes

  • Script

Drops the specified column from the specified table as well as any constraints and indexes that depend on the column. By default the script will just find the corresponding column, constraints, and indexes.Comes in handy for patching databases.

3.5 (2)

You rated this post out of 5. Change rating

2007-01-24 (first published: )

2,449 reads

Technical Article

Date String format with optional Timestamp

  • Script

I find it so annoying to format dates. Sometimes I want to include the timestamp, but if it is a midnight time stamp, the time is irrelevant. Sending in a datetime will return either the date string or a date string with a timestamp up to the seconds with either AM or PM.

5 (1)

You rated this post out of 5. Change rating

2007-01-02 (first published: )

195 reads

SQLServerCentral Article

Introduction to Bitmasking in SQL Server 2005

  • Article

The use of bitmasking is usually limited to decoding values in the system views, but it can be useful in other places when you want to save space. New author Lee Everest brings us an introduction to bitmasking and its use in SQL Server 2005.

4.57 (28)

You rated this post out of 5. Change rating

2007-12-05 (first published: )

18,587 reads

SQLServerCentral Article

Developers and DBAs

  • Article

The battle between developers and DBAs can be a rough one at times. However DBAs are often outnumbered by developers and need to be sure they fit in. DBA Janet Wong brings us one of her experiences about how you can better go with the flow.

2.94 (16)

You rated this post out of 5. Change rating

2007-11-29 (first published: )

8,930 reads

Technical Article

Function Used to Reformat Phone Numbers

  • Script

Can use this to select , insert and update phone fields into a standard format. Select FormatPhone(phone_column) from table Update Table set phone_column=FormatPhone(phone_column)Where ...Insert Into Table ( column1, phone_primary ...) Values ( 'qwerty', FormatPhone(1455846677)And the like --

You rated this post out of 5. Change rating

2007-01-25 (first published: )

447 reads

Blogs

Unused Indexes in SQL Server: Find them, vet them, and drop them safely

By

 Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...

T-SQL Tuesday #191 Round Up

By

I hosted this month, late as it turns out, but we still had a...

Come See Me at the PASS Data Community Summit

By

I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Slip Streaming Installs

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Slip Streaming Installs

Stairway to Azure SQL Hyperscale Level 4: Log Service and Transaction Management

By Chandan Shukla

Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...

Visit the forum

Question of the Day

Slip Streaming Installs

What does a slipstream installation mean?

See possible answers