A Small Selection of SQL Azure System Queries
I had a question come up during my “Getting Started with SQL Azure” presentation at SQLSaturday #52 in Denver last...
2010-09-29
1,597 reads
Blog Posts
Common SQL Server Mistakes – Indexing Every Column
If one index helps speed up queries, than more indexes should help more, right? They do, but they also come...
2010-09-29
4,788 reads
Don’t Take me (too) Literally
Years ago I was part of a heated discussion about the ability/inclination of a team I was on to build...
2010-09-29
1,532 reads
Grabbing SWAG
It’s getting close to the time for the SQLServerCentral party events this fall, and time to start gathering up SWAG...
2010-09-29
1,818 reads
How to Prove a Fact (Again)
Sean’s latest rant – about a vendor with a dangerously small amount of SQL knowledge – has spurred me to talk about...
2010-09-29
1,476 reads
Index Operations Showdown: Drop & Create vs. Create With Drop_Existing vs. Rebuild
Every now and then you may have had to move nonclustered indexes between filegroups. There are two ways it can...
2010-09-29
4,960 reads
The Lone Ranger And Data Integrity
Many IT Pros can relate to the the Lone Ranger. With the aid of but one trusty side kick, the...
2010-09-29
2,203 reads
Upcoming Florida Events
Lots of events in Florida, easy to lose track! The Tallahassee Code Camp is October 23, 2010, details at http://www.tallycodecamp.org/...
2010-09-29
1,684 reads
Do You Have Influence? Part 3
I talked about the basics of Influence in Part 1 and Part 2, today I’m trying something harder, showing you...
2010-09-28
710 reads
Find the largest tables in a database
From time to time, I need to find the largest tables in terms of rows / used space / total space etc....
2010-09-28
33,054 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers