• Interests: SQL Server, VB (old & .Net both)

Technical Article

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: )

191 reads

Blogs

A Live Conference Experience at Data Minds Connect 2021

By

Last week I was privileged to attend a live conference in Belgium. dataMinds Connect...

Daily Coping 25 Oct 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

A New Form of Address: Mx

By

When I was presenting at the dataMinds Connect conference, I called on someone in...

Read the latest Blogs

Forums

Need advice with backup plan and transaction log file

By dubem1-878067

I am missing something I guess.  Here's our backup Plan Full backup weekly Differential...

cannot generate SSPI context

By premkuttan

We have one user who face this issue while connecting to SQL server ''Cannot...

Database Corruption - LOB

By database diva

Hello, I have recently inherited a SQL 2012 database (no backups available), running in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

A Simple Error

See possible answers