Creating Dimension Table ==> Time (Example)

Script for Dimension table for Time.
Here Date_ID is the primary key which can be used as the foreign key...

Cumulative Update – 7 for SQL Server 2012 RTM Is Now Available !

The 7th cumulative update release for SQL Server 2012 RTM is now available. Cumulative Update 7 contains all the hotfixes...

Last Weeks Top “Reading” Links #29

For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...

Native SSMS a second class citizen no longer…

Intellisense can be a boon to adding quick development. Quick hints on scope specific variables, syntax suggestions, function descriptions and...

PowerShell – Get an UNC of a remote folder

To Read/Write/Rename/Copy/Delete a file configured across ‘N’ of servers in the same path, this script is going to be very...

Resolving data redundancy up front

 
Introduction
As all of us do when confronted with a problem, the resource of choice is to ‘Google it’.
This is where...

SQL – Table data – HTML Format & Email Sending using T-SQL

1) Configure DBMail  - In this case the ‘TEST’ profile being created for the demo
2) Create Table – TLOG_Metrics

3) Insert the dumnmy...

SQL Server – How to check if you are running 32-bit or 64-bit version

There are two different command you can use to check if you are running 32-bit or 64-bit version of SQL...

SQL Server : Part 10: Importance of Key Column Position While Creating Index

Now we have discussed about different types of indexes in the last posts. In this post, let us discuss about...

SQL Server Training in the Summer Time

Its been a long winter so far this weekend has seen the first signs of spring here in South Wales,...