Tempdb quick notes from Professional SQL Server 2008 internals and troubleshooting
I spent sometime to understand more about tempdb today. posting some key points for our quick reference.
some key books/links on...
2012-03-15
2,278 reads
Blog Posts
Webcast: What Are You Waiting For?
What was the number one question from today’s webcast on wait statistics? Where can the slides and sample code be...
2012-03-15
739 reads
Creating cards in Trello via the REST API and parsing the returned JSON all in a SQL CLR
I recently blogged about how good I thought Trello was and shortly afterwards I found out that they did provide...
2012-03-14
8,587 reads
Distinct Count in Analysis Services
Business users are often interested in finding distinct counts in addition to other aggregations. They may want to know the...
2012-03-14
1,249 reads
Error 0xC0014062: Unable to complete login process due to delay in opening server connection
Sometimes on a heavy loaded server(many databases/connection). You may get an error log when your backup maintenance plan job gets...
2012-03-14
7,270 reads
Happy #Pi Day
Here’s wishing you a Happy Pi Day…
If my picture isn’t good enough, here’s a better representation of pi.
3.14159265358979323846264338327950288419716939937510
Related posts:Happy Pi...
2012-03-14
580 reads
How Resilient Is Your Recovery Plan?
In this modern age of technology DBA’s face an ever increasing demand from businesses; our databases must perform, be secure,...
2012-03-14
611 reads
Idera ACE Program
On March 9th a tweet went out by David Fargo announcing the 2012 Idera ACE’s and my twitter handle was...
2012-03-14
611 reads
Looking for a DBA? Looking for a New Job?
Ryan Recruiter meet Dave DBA…
As a contractor and consultant I get to speak to many agents and recruiters and over...
2012-03-14
709 reads
Ownership Chains in SQL Server
Someone asked the question recently about allowing a user to run a process,but not execute the individual pieces of the...
2012-03-14
4,195 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