There are few parts of SQL Syntax as familiar as the GROUP BY clause of the SELECT statement. On the other hand, CUBE and ROLLUP remain mysterious despite their usefulness and GROUPING SET is positively arcane, especially if you are too shy to reveal your ignorance of the subject by asking! William Brewer saves you the hassle.
2015-11-17
4,187 reads
SQL Server 2016 brings a new feature called Stretch Database, which allows a database to keep transactional data on local instance and warm and cold data on the Azure SQL database platform.
2015-11-16
5,347 reads
Paul White explores some less well-known query optimizer features and limitations, and explains the reasons for extremely poor hash join performance in a specific case.
2015-11-16
3,593 reads
Erin Stellato of SQLskills shows how to use Extended Events to monitor for query plans with certain characteristics, such as joins missing predicates, columns missing statistics, and unmatched filtered indexes.
2015-11-13
2,571 reads
In this article I go through the installation and configuration processes of my Baseline Collector Solution.
2015-11-12
3,046 reads
If you're making a report from table-based data, an MS Word document is often a good option. In the second part of his introduction to SQL Server best-practice monitoring, Laerte Junior shows how to use PowerShell scripts to create a Word-based report with colour-coded alerts where there are problems or best practices aren't being followed.
2015-11-12
8,610 reads
2015-11-11
241 reads
Learn how a new feature in SQL Prompt 6.4 can help you avoid costly mistakes in coding.
2015-11-11 (first published: 2015-01-12)
7,791 reads
David Fitzjarrell looks at how and why to use a feature called Automatic Column Group Detection to recognize column dependencies and create extended statistics on recognized groups in Oracle 12.1.0.2.
2015-11-11
3,177 reads
In this article, see how to add a dependency to a SQL Server Resource in a Windows 2003 cluster.
2015-11-10
1,143 reads
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
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