SQL Database Status with sys.databases
I was creating a Powershell script for a SQL Server checkout procedure after a reboot , and used the state_desc column...
2011-12-09
857 reads
Reduce heap table fragmentation
A table that does not have a clustered index is referred to as a Heap. While a lot has been...
2011-12-09
7,177 reads
Re-blog – December 2 – December 8
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2011-12-09
562 reads
My Recipe for Chocolate Pie
One of our small holiday traditions is that we bake at least one home made dessert. Hard to beat the...
2011-12-09
658 reads
#sqlfamily
Microsoft is supporting an effort by PragmaticWorks targeted at supporting technical training for returning veterans. I can’t think of a...
2011-12-09
1,704 reads
SQL Server is Smarter Than You
I had a brief email discussion recently, which could be effectively be boiled down to:
Them: “Are foreign key constraints more...
2011-12-08
848 reads
Data Usage
This is somewhat shocking to me. I was reading about ATT’s decision to throttle some high bandwidth users, and there...
2011-12-08
1,113 reads
The #Meme15 On Social Networking
During a recent conversation with a few fellow bloggers, the conversation turned to how we each got started with blogging...
2011-12-08
478 reads
SQL Server A to Z – XML
I can’t believe it’s already December. This year has just flown by. The rush of holiday events has already started,...
2011-12-08
1,753 reads
DBA in Space: Behind the Scenes—Question 14
Part 1 of Question 14—The question.Part 2 of Question 14—The follow up to the question.This is a continuation of my...
2011-12-08
717 reads
Blogs
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers