Tuesday
PASS Application Development Virtual Chapter - Next-Level SQLCLR: Parallel Processing and Bulk Load - Adam Machanic
Pragmatic Works - Performance tuning the cube - Adam...
2010-09-24
776 reads
Not long ago Microsoft announced a new product called Azure AKA “SQL Server in the Cloud”. I have to say...
2010-09-23
327 reads
How often have you seen someone write a DML trigger like this:
createtrigger mytrigger on Mytable forinsertas
declare @id int
select @id = id...
2010-09-23
15,412 reads
/*I'd be very surprised if you've ever used the old COMPUTE clause in SQL Server. It is a bit mad,...
2010-09-23
1,618 reads
Yes, it is. As I mentioned a few months back, it is important to pay attention to when Microsoft releases...
2010-09-23
500 reads
Since there has been a bit of a furor over the PASS election process the past 2 years I thought...
2010-09-23
477 reads
I saw a post recently that said that braindumps were the best way to prepare for certifications. It was posted...
2010-09-22
1,887 reads
Last week, I mentioned in my TSQL2sDay index summary post, that I’d be writing a few posts on the information...
2010-09-22
1,452 reads
On September 21, 2010, Microsoft released SQL Server 2008 SP1 Cumulative Update 10, which is Build 2799. I count 29...
2010-09-22
1,287 reads
According to BOL, "Key-range locks protect a range of rows implicitly included in a record set being read by a...
2010-09-22
1,044 reads
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...
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
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