Constraints and SELECT Statements
I’ve posted previously about how a foreign key constraint can change how a SELECT query behaves. Logically that just makes...
2015-04-16 (first published: 2015-04-06)
7,517 reads
I’ve posted previously about how a foreign key constraint can change how a SELECT query behaves. Logically that just makes...
2015-04-16 (first published: 2015-04-06)
7,517 reads
Recently, I was working on a Peer-to-peer replication automation project. When I switched from my local test servers to some...
2015-04-16
740 reads
Although , It is out of box but I would like to share here. I am very choosy in food. When...
2015-04-16
550 reads
Just would like to take a moment to say thank you to Paul Randal, who is busy with his own...
2015-04-16
335 reads
2015-04-16
538 reads
Every now and then we will need to convert datetime to string for display, and would you remember all the...
2015-04-16
445 reads
Just a brief note today to point to an article by Time Ford on SQLMag.com announcing that SQL Server 2014 SP1 has...
2015-04-16
630 reads
Today we’ll learn how you can use T-SQL to calculate your zodiac sign from your birthdate.
“Heeeeeere’s Johnny!” – Ed McMahon introducing...
2015-04-16
1,339 reads
At the Charlotte BI Group meeting last night, one of the questions I was asked after I gave my talk...
2015-04-16 (first published: 2015-04-08)
5,456 reads
In the first article on this topic (which can be read here), I discussed the problem of having a database...
2015-04-15 (first published: 2015-04-07)
4,743 reads
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
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