Insert Unknown Row to Dimension Table
When building a warehouse there is a common practice of adding an Unknown row to the Dimension tables. For me,...
2010-06-15
1,420 reads
Blog Posts
Networking – A Year Later
I was excited to attend the networking session last year at the PASS Summit. Andy Warren and I had talked...
2010-06-15
663 reads
oPASS Meeting Tonight June 15, 2010 – Featuring Kendal Van Dyke
We’re meeting from 6-8 pm as usual, with Kendal Van Dyke presenting Paging Dr Availability, You’re Wanted In the Recovery...
2010-06-15
310 reads
Report Render Duration
Every once in a while I come across a scenario where I really want to know how long it took...
2010-06-15
557 reads
Sarasota SQL Server Users Group
Tonight I’m presenting for the Sarasota SQL Server Users Group. If you’re interested in attending, you can join in using...
2010-06-15
711 reads
SQL Server XML Schemas
Ever been curious about the schema of , say an SSRS rdl file ? How about the execution plan ?
Not only should...
2010-06-15
494 reads
Teaching ICT 4462 – Transact SQL Programming at Denver University, University College
I will be teaching a special five week version of ICT 4462 – Transact SQL Programming at Denver University, University College...
2010-06-15
630 reads
The Value of an Artist
A short while ago someone complained that some of the headlines on SSC were deceiving in terms of what they...
2010-06-15
661 reads
Virtualizing Servers in Production
The company where I work has been using virtualization in development, QA, testing, etc., for many years now. We have...
2010-06-15
864 reads
Daily SQL Server 2008 New Feature – Day 22
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-06-14
399 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...
CMS server query & temp tables
I am annoyed. We have a CMS server that has hundreds of servers saved...
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...
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