SQLSaturday Finally Listed in PASS Connector
If you subscribe to the Connector (the main communication email from PASS.org) you should have gotten one yesterday that finally...
2007-10-25
1,398 reads
If you subscribe to the Connector (the main communication email from PASS.org) you should have gotten one yesterday that finally...
2007-10-25
1,398 reads
I've been following Steve's exploits trying to learn the podcasting business and we usually talk about it once a week...
2007-10-25
1,461 reads
Views are one of the more basic constructs in SQL Server, but often it seems that developers are not sure when to use them. SQL Server expert DBA and trainer Andy Warren brings us a look at views as an abstraction layer in your database.
2007-10-25
5,098 reads
This went up today and there is one great comment about possibly using snapshot isolation as an alternative to the...
2007-10-25
1,354 reads
If you do any coding in .Net using aspx pages you'll recognize this one. Each page has a title attribute...
2007-10-24
1,472 reads
Had a friend call me recently to ask about how to do this, had an nvarchar(2000) column that needed to...
2007-10-22
1,450 reads
If exists is a well known way to improve performance because it returns as soon as it matches a single...
2007-10-21
1,836 reads
We're at 215 registered with 3 weeks to the big day! This week I'll be having the last planning meeting...
2007-10-21
1,460 reads
The most recent ACM Queue Magazine (Vol 5 #6, Sep/Oct 2007) had two really interesting articles. The first was about...
2007-10-21
1,501 reads
PASS is the global users group for SQL Server DBAs, but there are a number of people who have never heard of it. Longtime author Andy Warren has a few suggestions for PASS and encourages you to submit your own.
2007-10-18
2,036 reads
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...
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
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