Jamie Thomson

Create a table of dates

This script creates a table and populates it with information about all dates between a (configurable) start date and end date.It creates a table called MyDates in a database called MyDB in which this is done but the script can be easily edited create the table in whichever DB you want it with whatever name […]

5 (1)

2004-10-28 (first published: )

321 reads


VMworld 2020 – Top 10 Database Sessions (Part 1)


Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...

Daily Coping 24 Sep 2020


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

VMworld 2020 SQL Server session preview


Join me, David Klee, Microsoft Data Platform MVP and VMware vExpert, for a preview...

Read the latest Blogs


Where do I start from ?

By Corobori

Following with a user complain about SQL timeout I bumped into one issue with...

Function Code

By sizal0234

Hi, I have a fn with below code I want to understand the highlighted...

Backup size

By caz100

Hi Is it possible to have a database size showing 75 gigs and then...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers