SQL Server 2016 - Launch Get Ready
You've been waiting, you've been asking, some begging to know the magic date of when Microsoft's SQL Server 2016 will...
2016-05-06
1,125 reads
Blog Posts
Another Day, Another City
After a few days in Copenhagen for SQL Nexus, I traveled to London late last night, and am now making...
2016-05-05
456 reads
Free eBook – Azure SQL Databases
PuttingYour Head In the Cloud An Introduction to Cloud Computing and Azure SQLDatabases by David Postlethwaite has been revised in...
2016-05-05
620 reads
Optimization with temp tables - example
The code optimization is a mandatory task for the programmable objects in SQL Server. During the time some code can...
2016-05-05
224 reads
Optimization with temp tables – Example
The code optimization is a mandatory task for the programmable objects in SQL Server. During time some code can start working “badly” i.e. become slow. In that case a...
2016-05-05
5 reads
Optimization with temp tables – Example
The code optimization is a mandatory task for the programmable objects in SQL Server. During time some code can start...
2016-05-05
82 reads
Optimization with temp tables – Example
The code optimization is a mandatory task for the programmable objects in SQL Server. During time some code can start working “badly” i.e. become slow. In that case a...
2016-05-05
5 reads
Partition to Filegroup Mapping in SQL Server
Suppose you have a partition function and a corresponding partition scheme in SQL Server. The partition scheme maps each partition...
2016-05-05 (first published: 2016-04-25)
2,830 reads
Pensacola in June–SQL Saturday #491
One June 5, I’ll be back in Pensacola, FL for SQL Saturday #491. It’s been a few years since there...
2016-05-05
516 reads
SQL Saturday Iowa City Precon – The Complete Primer to SQL Server Infrastructure
I’m pleased to announce that I’m launching my next round of all-day precon training session at the upcoming SQL Saturday in Iowa...
2016-05-05
383 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
CMS server query & temp tables
I am annoyed. We have a CMS server that has hundreds of servers saved...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Question of the Day
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