What is an execution plan? When would you use it? How would you view the execution plan?
An execution plan is basically a road map that graphically or textually shows the data retrieval methods chosen by the...
2015-12-28
865 reads
What does that N in nvarchar really mean?
In any study of Data Types in SQL Server you are going to have to look at the various string...
2015-12-28
2,392 reads
Thank You for More Than You Realize
Blogging and presenting have changed me for the better, and in ways I didn’t see coming. However, I know I wouldn’t have had them if it wasn’t for three things. Getting...
2015-12-28
10 reads
Thank You for More Than You Realize
Blogging and presenting have changed me for the better, and in ways I didn’t see coming. However, I know I wouldn’t...
2015-12-28
697 reads
Presentations & Blogging of 2015 in Review
Another year is coming to an end and I am doing a review of which goals I have managed to...
2015-12-27
767 reads
Top 10 Enhancements to Azure SQL Database in 2015
Top 10 Enhancements to Azure SQL Database in 2015
DECEMBER 27, 2015
Introduction2015 has been a massive year for Azure SQL Database. This year has seen the product mature from "an...
2015-12-27
29 reads
Top 10 Enhancements to Azure SQL Database in 2015
Top 10 Enhancements to Azure SQL Database in 2015DECEMBER 27, 2015
Introduction
2015 has been a massive year for Azure SQL Database....
2015-12-27
1,022 reads
Type 6 or Hybrid Type 2 Slowly Changing Dimension with Biml
In my previous post, I provided the design pattern and Biml for a pure Type 2 Slowly Changing Dimension (SCD). When...
2015-12-27
613 reads
Columnstore Indexes – part 75 (“Stretch DB & Columnstore”)
Continuation from the previous 74 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post focuses on one of...
2015-12-26
534 reads
Learn How to Insert Data From Stored Procedure Into Table?
Stored Procedures are considered most efficient way for calling and retrieving data and hence users always look forward to encapsulate...
2015-12-26
764 reads
Blogs
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers