Billing rates – other side of the fence

The following is a guest post by Tim Morgan from Sullexis in response to a resent blog of mine:
Thanks for letting...

Explore file physical structure - Delete

1. Create sample db

use master
go
CREATE DATABASE [test] ON  PRIMARY
( NAME = N'test', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master\test.mdf' , SIZE = 2048KB , FILEGROWTH = 1024KB...

One Interview question. Many Answers

Conducting technical interview is an art.
Most likely I would start a discussion with simple questions like "What is your favourite topic in SQL...

SQL Server 2008 Diagnostic Information Queries (Nov 2012)

Here is the November 2012 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements...

Time Pass With Transaction Log - Part 5 INSERT

 In this article We are going to INSERT a record in a simple table and try reading Transaction log record.
Note:...

Unused Indexes

A sound indexing strategy is paramount to performance in an OLTP system.  Not having the correct indexes in place can...

What’s the deal with Excel & SSIS?

When it comes to importing data from an Excel sheet with SSIS, Excel has quite a reputation. And not a...

Can’t access Operations or Applications tabs from Central Admin WSS 3.0 SP 2

Hey Friends,
Sometime when we try to access central administration and certain tabs like operation and Application management we face issues....

Choose specific folders to sync with SkyDrive

Every time you run the SkyDrive Client on your device, a laptop in my case, all your files from the cloud are downloaded to...

Cyber Monday: Performance Indexing Book is $15

Ever thought you could learn a little bit more about indexing?  Now here’s the perfect opportunity.  Today only you can...