I write an editorial about why I thought tape still had a place in backups . There were some interesting responses that said disk works well for them and they wouldn’t go back to tape. I used to think the density was a big deal, along with cost, but maybe...
2009-04-08
1,399 reads
Evaluating risk is something we do every day. Steve Jones talks a bit about using this to make ourselves better.
2009-04-07
104 reads
I was joking with Buck Woody on Facebook the other day and he mentioned he’d been a data janitor at...
2009-04-07
756 reads
Lately I’ve gotten a lot of questions submitted to SQLServerCentral that have dealt with weird data type issues. We had...
2009-04-06
587 reads
One of the most interesting features in SQL Server 2008 is filtered indexes. This article starts with a quick explanation and then digs into the details and results.
2009-04-06
2,810 reads
SQL Server 2005 resource allocation policies treat all workloads equally, and allocate shared resources as they are requested. It sometimes causes a disproportionate distribution of resources, which in turn results in uneven performance or unexpected slowdowns whereas the new Resource Governor of SQL Server 2008 allows organizations to define resource limits and priorities for different workloads, which enables concurrent workloads to provide consistent performance to the end users.
2009-04-06
2,583 reads
Recently I posted LinkedIn (part 1) about my efforts to better understand and use it as a networking platform. It ended up generating a lot of good comments, always nice to see, and I'll be addressing some of those here and/or in part 3 coming up...
2009-04-06
3,009 reads
Evaluating risk is something we do every day. Steve Jones talks a bit about using this to make ourselves better.
2009-04-06
642 reads
Evaluating risk is something we do every day. Steve Jones talks a bit about using this to make ourselves better.
2009-04-06
575 reads
Evaluating risk is something we do every day. Steve Jones talks a bit about using this to make ourselves better.
2009-04-06
895 reads
Every organization I talk to has the same problem dressed up in different clothes....
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item The Problem Isn't Always Your...
Comments posted to this topic are about the item 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