Index Info
I recently came across an interesting script to help show index info and usage. As I began to dissect the...
2010-03-31
1,998 reads
Blog Posts
Intel Xeon 7500 Series aka Nehalem-EX
Intel has finally released the long awaited (at least by me) 45nm Xeon 7500 series processor. This beast has eight...
2010-03-31
2,004 reads
The Vacation Crash
The family returned back from the UK last night, after traveling for something like 14 hours, plus an early morning...
2010-03-31
1,548 reads
Auditing Report Executions with Free Source Code
Have you been looking for a way to measure report performance? Want to know who accesses your reports most frequently? ...
2010-03-30
1,716 reads
Building a Wiki
I’ve long admired the value that I get from Wikipedia and like the concept of crowd sourcing knowledge, just never...
2010-03-30
1,639 reads
Didn't I Just Post about Slipstream making Installs Easier?
So the other day I posted, Slipstream - Makes installs simple, and this afternoon I needed to do a SQL Server...
2010-03-30
1,401 reads
FizzBuzz Revisited
I had bigger plans for this series than what has transpired. I think that is a testament as to how...
2010-03-30
1,946 reads
2010-03-30
1,462 reads
Instructables Contest: Paracord
Instructables has a Paracord contest going that requires some portion of a project include paracord (often referred to as 550...
2010-03-30
1,855 reads
SP_change_users_login and SQL Server 2008 onwards
Today I discovered, from a post on the forums and a follow up dig into BOL that sp_change_users_login is to...
2010-03-30
5,804 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