This post is about the importance of a right index to a query. The following simple query was considered. [crayon-5e81b52eda1f0195410103/] Even simple, this query was causing troubles on our production...
2016-11-11
4 reads
This post is about the importance of a right index to a query. The following simple query was considered.
SELECT
[GroupBy1].[A1] AS...
2016-11-11
260 reads
Major sponsors in our space get hundreds of emails from us each year, all asking for money. Those are all...
2016-11-11
398 reads
With Windows Server 2016 just been released, now is the perfect time to build an Azure VM with SQL Server...
2016-11-10
997 reads
I am in the middle of some research regarding CHECKDB and learnt something new. From SQL Server 2014 onwards the...
2016-11-10
462 reads
I’ll be at the last big SQL Server conference in the US for 2016 this December. VS Live is a...
2016-11-10 (first published: 2016-11-02)
918 reads
I recently wrote an introductory post about the importance of statistics. I just received a reinforcement on how important they...
2016-11-10 (first published: 2016-11-03)
1,221 reads
One of the coolest things to release with SQL Server 2016 was “Number of Rows Read” information in execution plan....
2016-11-10
831 reads
One of the topics I forgot to mention from the Roundtable was a swell of dissatisfaction with the GAP. Not...
2016-11-10
388 reads
I know that more and more of you are moving more and more resources into the Azure Data Platform. In...
2016-11-09
610 reads
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...
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
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