Build DATELOOKUP table

This script creates a table named DATELOOKUP which is used for looking up date related values. Each record represents date related info about the date in the column dtDate. For example the iMonth column stores the integer value of the month of dtDate and sShortMonth stores the abbreviated name of that same month. Use this […]

5 (1)

2004-12-13 (first published: )

181 reads

Blogs

Containers: Create a Custom Container

By

Creating a custom container is where things get truly exciting. There’s actually a ton...

Mini-Rant: Spoofed Phone Numbers and Trust

By

I’ve seen this more and more over the last year: I receive a phone...

Speaking at SQL Saturday Dallas

By

Speaking at SQLSaturday Dallas! I’m proud to announce that I will be speaking at SQL...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

SQL Server health check

By 892717952

If I want to do a SQL Server health check, which aspects should be...

CPU?Memory and IO bottleneck check

By 892717952

Which indices will show  cpu bottleneck?memory bottleneck and IO bottleneck? for example: which indices...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers