In this tip, we will discuss the process of generating test data to verify query logic without relying on real-life data, along with some helpful guidelines. We will also cover various scenarios and their corresponding solutions.
The PASS Data Community Summit is back in Seattle this November, with hundreds of speakers covering a wide variety of database topics, including cloud computing. We feature two of those speakers in this webinar: Bob Ward of Microsoft and Steve Jones of Redgate.
Today we have a guest editorial from Andy Warren as Steve Jones is on vacation. Today Andy looks at the ways we can cope when we have been working too much.
Several methods on how to pass an array of values from a client to SQL Server, and performance data about the methods.
I’ve long been a huge advocate for always referencing objects with a schema prefix in SQL Server.
In spite of what may be a controversial title to many of my regular blog readers, I don’t really want you to stop that practice in most of your T-SQL code, because the schema prefix is important and useful most of the time. At Stack Overflow, though, there is a very specific pattern we use where not specifying the schema is beneficial.
I recently changed jobs and my commute time doubled, I found myself with more time to think and I started asking questions.
In SQL and relational databases, NULL values are an important part of managing data and information stored in SQL tables. A NULL value is used as a placeholder for missing values or values that are unknown in a database column or cell.
A year ago, I started a monthly blogging event for the PostgreSQL community, inspired by T-SQL Tuesdays. I decided to call it PGSQL Phriday. (Time will tell if my insistence on trying to use a literation was a good idea or not.) Like the event for the SQL Server community, we ask someone to be […]
You will learn how a blockchain works and then use a SQL database to analyze data from a series of transactions.
Steve asks about your team at work today. What you like, what you need, even what you want to see in those with whom you work.
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
By Vinay Thakur
Following up on my Part 1 baseline, the journey from 2017 onward changed how...
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
I created a SQL Database in Azure Portal but I've just noticed it also...
Comments posted to this topic are about the item 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