Attention Speakers–Sign Up for SQLSaturday #85 in Orlando!
Our call for speakers for #85 will be open about another 10 days, and then Bradley Ball can jump into...
2011-06-28
615 reads
Blog Posts
Counting Licenses for VMs
This is old news, but I’ve had to explain SQL Server VM licensing to enough people recently that I thought...
2011-06-28
3,135 reads
Getting Ahead and Getting Involved
I spend a little time on AskSSC (that is the question and answer section on http://www.sqlservercentral.com). Quite often the question...
2011-06-28
869 reads
HASHBYTES – A T-SQL Function
Someone was asking if the HASHBYTES function was a good one to use in T-SQL as far as performance goes.....
2011-06-28
15,125 reads
Instead Of Trigger and OUTPUT clause headache
It is known that you cannot get inserted identity values using OUTPUT clause when inserting to view which has instead...
2011-06-28
1,797 reads
Let’s Get Registered! Registered!
The PASS Summit is only a few short months away. But before that happens there is an important deadline fast...
2011-06-28
679 reads
Miss SQLBits 8? No problem, all videos are online
OK, since this conference in is England, it’s a little harder to get to compared to TechEd. No matter, all...
2011-06-28
863 reads
My Favourite SQL Server Myths and Realities
It has been more than two months since I blogged. I have been blogging in my Organization internal blogging site on Management...
2011-06-28
3,805 reads
Pain of the Week: Understanding Your Indexes
Want to take a few minutes out of your day on to learn a bit more about indexes? On Thursday,...
2011-06-28
884 reads
SQLDIY: Database Space Detail
Continuing to build up our data gathering library we shift our focus to tracking database file growth. This particular procedure...
2011-06-28
563 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