Slide Deck for Introduction to Statistics
Here is the slide from the presentation today for the PASS Performance Tuning Virtual Chapter. Thanks to all those that...
2010-09-07
495 reads
Blog Posts
Tagxedo
I found this while looking for a quick way to throw some words into a slide, was thinking something along...
2010-09-07
597 reads
Unique and non-unique non-clustered indexes on a non-unique clustered index
In the last weblog post I have talked about the differences in unique and non-unique
non-clustered indexes on a unique clustered...
2010-09-07
4,099 reads
Upcoming Engagements
I haven’t been speaking a lot lately as I’ve been busy working, planning SQLSaturday #49 – Orlando, and planning PASS SQLRally,...
2010-09-07
480 reads
Virtual Labs - A Great Resource for SQL Server
I had someone send me a note recently asking some questions about how to get set up to work with...
2010-09-07
1,062 reads
What is Normalization in SQL ?
=> What is normalization ?
Defination :Normalization is the process of efficiently organizing data in a database. There are two goals of...
2010-09-07
303,366 reads
24 Hours of PASS coming over the next two days
Hey folks,
The 24 hours of PASS is coming very quickly.http://www.sqlpass.org/24hours/fall2010/. There are so many great sessions that I don’t know...
2010-09-06
506 reads
An impossible case
In a previous blog entry (Inconsistent NullIf behaviour), Jeff Moden and Dan Halliday(twitter) both made a very similar observation.
When executing...
2010-09-06
547 reads
Awards for SQL Heroism
Motivational time again!
Have you ever worked on a project where someone was seeking their moment in the sun for an...
2010-09-06
216 reads
Building your 1st Performance Point Dashboard in Sharepoint 2010
Hey there gang
The PASS BI Virtual Chapter is presenting some great stuff this fall. September 14th I’m doing a new session on...
2010-09-06
379 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
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