What is a CTE
CTEs (Common Table Expressions) are one of the most interesting and useful tools added to T-SQL in the last decade....
2015-04-06
697 reads
Blog Posts
Clustered Columnstore Indexes – part 50 (“Columnstore IO”)
Continuation from the previous 49 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
This blogpost is focused on the reading part of the IO subsystem...
2015-04-04
881 reads
Hello SQL Server world!
Hi folks! Look, my very first post, yay!
I’ve been thinking about starting my own SQL-related blog for a long time and I guess...
2015-04-04
537 reads
Port numbers and SQL Server
I made a mistake the other day. I’ll admit it. I was wrong. Now I know all of you are...
2015-04-03 (first published: 2015-03-30)
9,062 reads
Power Query – Controlling M Query Functions with User Driven Parameters
Have you ever had a user run a query against one of your largest tables only for them to immediately...
2015-04-03
16,274 reads
Speaker of the Month: April 2015
One of my favorite events of the year is the SQL Saturday in Silicon Valley. They’ve had four of them...
2015-04-03
605 reads
Toggle Functionality Looses In excel--ssrs 2005
Hi Folks
Highlighting on the issue that I faced last week while working on reporting services 2005.
Requirement :- A data region (table)...
2015-04-03
636 reads
tSQLt with TRY..CATCH
Someone asked me the question recently about how tSQLt works with TRY..CATCH blocks and the exceptions that we might test...
2015-04-03 (first published: 2015-03-25)
8,288 reads
Availability Groups - Where Did My Disks Go?
The TL;DR - beware of Failover Cluster Manager trying to steal your non-shared storage!
--At a client recently two availability groups on...
2015-04-02
12,967 reads
Can Log Shipping Work Without Shipping the Log?
When you configure log shipping, there are 4 SQL Server Agent jobs that are set up:
Backup: Performs a backup log...
2015-04-02 (first published: 2015-03-30)
6,891 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
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...
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...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
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