|
Category: Development
#TSQL2SDAY (8) Administration (41) AI (2) AlwaysOn Availability Groups (11) Azure (12) Career (25) Community (37) Continuous Integration / Deployment (7) Development (12) Disaster Recovery (27) General (20) High-Availability (9) Microsoft SQL Server (20) Performance (30) PowerShell (12) SQL Agent (8) SQL Server Management Studio (2) SSAS (1) SSIS (1) SSRS (2) T-SQL (14) Uncategorized (191) Windows Clusters (7)
-
Redgate SQL Prompt Grid Features
/
I love Redgate tools. Most of all, I love SQL Prompt because its features increase my productivity on a daily basis. Recently I discovered…
-
Unique Indexes and Computed Columns in SQL Server
/
In the last post of this blog series, I discussed what a non-clustered index is and how to choose an ideal non-clustered index key.…
-
Non-Clustered Indexes in SQL Server
/
In the last post of this blog series, I discussed what a clustered index is and how to choose an ideal clustered index key.…
-
A better way to search dates
/
SARGability is the ability of the query to properly search the arguments that you pass it. When your query is not sargable you cannot…
-
Clustered Indexes in SQL Server
/
In the last post of this blog series, I discussed what a heap is and how it impacts query performance. In this post, I…
-
Query Store for Everyone
/
SQL Server 2016’s Query Store feature is, without a doubt, one of the most exciting new features for this version. The Query Store will keep…
-
Heap tables in SQL Server
/
In the last post of this blog series, I discussed what a B-Tree index was and briefly explained its history. Before we dive into the…
-
Favorite SQL Server Feature – #TSQL2SDAY #77
/
Today is the 77th T-SQL2SDAY! If you’re not familiar, T-SQL Tuesday is a blogging party hosted by a different person each month. It’s a…
-
The ‘B’ in B-Tree – Indexing in SQL Server
/
Some people advocate we should count by twelve rather than ten. This is because you can easily count the twelve segments of your fingers…
-
T-SQL Tuesday #74 – Be the change (MERGE static data)
/
Each month, on the first Tuesday of the month, the announcement for the blog party T-SQL Tuesday comes out. Those that are interested then…