More Free Training
Quest Connect 2009, taking place in October 21 for 24 hours, looks like it’s going to have 64 different sessions, live...
2009-09-15
696 reads
Blog Posts
Multiple Execution Paths
It’s not uncommon to find stored procedures that have multiple IF statements controlling the flow of execution within the procedure....
2009-09-15
755 reads
Networking Sins
I ran across this article about networking sins a while back and have had it on my list to share....
2009-09-15
1,364 reads
Networking While On Vacation
There's been a lot of attention given to professional networking (e.g. Andy Warren's blog posts) recently and if you recall...
2009-09-15
601 reads
No Join Predicate
You could be looking at an execution plan on a query and see this message: Warning, No Join Predicate. With...
2009-09-15
3,204 reads
Orlando PASS Meeting
Tonight is the OPASS bi-monthly meeting. Todd Holmes will be giving a mini presentation on SQL Server Backups and out...
2009-09-15
485 reads
Blobs and Filestreams
In the next week or so I’ll be upgrading the SQL 2005 server that has the SQLSaturday database and I’m...
2009-09-14
1,582 reads
Denver Area SQL Server User Group Week
All the Denver area groups are having their meetings this week. If you're in the area, try to attend a...
2009-09-14
975 reads
Editorial on SQL Server Central
My first one over there. It’s discussing whether or not you should do two things, build your own monitoring tool,...
2009-09-14
814 reads
Getting Into the Biz, Part 3
In a couple of previous posts (Part One and Part Two), I shared some thoughts about starting a career path...
2009-09-14
1,358 reads
Blogs
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...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
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