SQL Server – Find all the LOB Data Type Columns in a Database Using T-SQL Script
Today morning when I was working on a huge database containing lots of LOB data, I was required to know...
2013-09-12
879 reads
SqlServerZest.com - SQL in simple style
SQL Server – How to Perform Striped Database Backup & Restore Using T-SQL Command
Even though there are more pros than cons, Striping database backups are often overlooked by many DBAs. Based on my...
2013-09-03
1,668 reads
SQL Server – Why is the ‘sa’ Login Account Disabled & How to Enable ‘sa’ Login Account
Ever noticed and wondered why the well-known SQL Server system administrator (sa) login is in a disabled state? The reason...
2013-08-20
741 reads
SQL Server – How to Move Database Files – Data File and Log File – From One Drive Location to the Other
Most of the DBAs at some point of time in their career should have faced at-least one of the below...
2013-08-10
1,395 reads
SQL Server – Automating Backup Files Cleanup Task Using Maintenance Plans
Cleaning/deleting the old backup files is equally important as taking the backups. Doing so we can (i) Avoid overhead cost for...
2013-08-07
1,002 reads
SQL Server – Get all Login Accounts Using T-SQL Query – SQL Logins, Windows Logins, Windows Groups
Earlier today I was required to pull the list of all SQL Login Accounts, Windows Login Accounts and Windows Group Login...
2013-08-06
1,416 reads
SQL Server – How to Download and Install the ‘right’ AdventureWorks Sample Database
One of the first things I did when I began my journey with SQL Server was installing a sample database....
2013-07-31
1,603 reads
SQL Server – Understanding ‘sp_spaceused’ Results for Database Size Information
From a recent conversation with a customer, I noticed even some of the experienced DBAs are not very clear about...
2013-06-28
1,622 reads
SQL Server – How to Insert Explicit Values Into An Identity Column
By default, SQL Server automatically assigns a value to the Identity Column for each new row inserted into the table....
2013-06-02
665 reads
SQL Server – Get the Default Data File and Log File Location using T-SQL Query
In SQL Serve 2012, we can get the default data file and log file locations using a simple T-SQL query...
2013-05-23
656 reads
Blogs
SQL Server Journey Part 2: Modern Era (2017 – 2026) – AI/Cloud First
By Vinay Thakur
Following up on my Part 1 baseline, the journey from 2017 onward changed how...
Google Moves Up Post-Quantum Cryptography Timeline
By Brian Kelley
In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography...
The Book of Redgate: No Politics
By Steve Jones
In today’s world, this might mean something different, but in 2010, we had this...
Forums
Auto Update Statistics not triggering on filtered indexes
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
What is the difference between SQL Server and SQL Database?
I created a SQL Database in Azure Portal but I've just noticed it also...
An Unusual Identity
Comments posted to this topic are about the item An Unusual Identity
Question of the Day
An Unusual Identity
What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
id
FROM dbo.IdentityTest2 See possible answers