SQL Server-Table Variable

Table variable:- SQL Server provides an variable known as table variable which is used to store data in a similar way as we...

[BUG] Inserts to tables with an index view can fail

Unfortunately some of the more troubling bugs can be very hard to reproduce succinctly.  Here is one that has been...

A Tale of Two Cities - SQLSaturday Goes Global..

 
It was a day of warm weather, it was a day of cold weather.  A tale of two cities on...

Are you allowed to use social networking at Work?

I was reading this article about internet usage by staff who work for local authorities in Wales http://www.bbc.co.uk/news/uk-wales-16394916 The content...

Arithmetic overflow error and isdate sql

Executing a t-sql statement with a convert function
 convert(datetime, my_date_column)            ,           
 threw an arithmetical overflow error with the message :
Message
Arithmetic overflow...

Creating Strong Passwords

I was writing a presentation recently on encryption and one of the important things to show in the presentation is...

Database uplevel Restores

Today I've been reading Paul Randal's collection of Blogs from a series called A SQL Server DBA myth a day....

Q.How Many Weeks in the Year? A.It depends

ISOWEEK 52 Weeks in the Year

Stardate 12:20:2011 Week 51 SSC.Com Web Blog, Planet Earth.  With only approximately two weeks left...

Re-blog – December 30 – January 5

Welcome to the Friday Re-Blog summary post.  The aim of these posts is to bring some old posts that newer readers may...

SQL Server 2012 FileTable – Part 1

In a series of blog posts we will have a look at the new SQL Server 2012 table type called...