Answer - Objective Question (Which table is called Heap table in SQL Server)

Question:-

   Which table is called Heap table in SQL Server.

1) Table without any indexes

2) Table without any clustered index (Correct...

Are CHECKSUMs being performed with a Compressed Backup?

Now, why in the world would I be asking a question like this?

Well, in BOL (BACKUP) is this little blurb:
CHECKSUM

Specifies...

Day 12 – High CPU and Bloat in Distribution

This is the final installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...

Day 12 – High CPU and Bloat in Distribution

This is the final installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...

January 2014 – Monthly SQL Server Checklist

image source
It’s the first Monday of 2014.  Time for a new year and some resolutions to be a better DBA....

Last Weeks Top “Reading” Links #65

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...

Looking Back At the Droid Razr Maxx

It’s been 18 or 19 months since I upgraded from the Droid X to the Maxx. The X was a...

Posts I've Found Interesting:

This is a question I had until I came across a great script by The Scripting Guys. The script below...

PowerShell – Find OS architecture (32 bit or 64 bit) of local or remote machines Using Powershell

Method 1: Environment Variable
PS:\>$ENV:PROCESSOR_ARCHITECTURE
Method 2: Using Win32_OperatingSystem
ps:\>$computername=’abcd’
ps:\>(Get-WmiObject Win32_OperatingSystem -computername $computername).OSArchitecture
Method 3: Using Win32_Processor
ps:\>$computername=’abcd’
ps:\>Get-WmiObject -Class Win32_Processor -ComputerName $ComputerName| Select-Object AddressWidth
Method 4:[IntPtr]::Size - Gets the...

South Alabama Day of .Net

Just received an email from my friend Ryan Duclos announcing the South Alabama Day of .Net in  Mobile, Alabama, on...