Currys having apostrophe trouble
Before I start I just want to say that much of this post is mere speculation on my part and...
2014-04-08
628 reads
Question of the Week -08/04/2014
Suppose we need to find out the name of all the months in a given year (Year will be given...
2014-04-08
504 reads
Answer - Objective Question (How many Null values in an unique constraint can be inserted in SQL Server)
Question:- How many NULL value allowed in a column in which Unique constraint is defined in SQL Server?
Options:-
a) 1
b) 2
c) More...
2014-04-08
594 reads
[SQL Snacks Video] SQL Server Table Partitioning 101
I hope you’re hungry for another SQL Snack! In fact, this will be one of a series of snacks (dare...
2014-04-08
641 reads
T-SQL Tuesday #53 Why So Serious
This month’s T-SQL Tuesday which is now at a staggering number 53, can it really have been going that long?...
2014-04-08
834 reads
Curation and Performance
I’m trying out a new web site from Microsoft called Curah! that is all about curation. Curation is basically what...
2014-04-08
807 reads
Read Flat File Contents to Variable – Write Variable Value to Flat File
When working with SSIS, you’ll often find the need to read the contents of a flat file to a variable,...
2014-04-22 (first published: 2014-04-08)
7,579 reads
The system_health Extended Event Session
When I first started poking around in SQL Server 2012, I noticed an extended event session called “system_health” was created...
2014-04-21 (first published: 2014-04-08)
4,067 reads
T-SQL Tuesday #53: Why so serious
Why so serious? If you ask anyone who knows me they will tell you I’m not a terribly serious person....
2014-04-08
394 reads
T-SQL Tuesday #53: Why so serious
Why so serious? If you ask anyone who knows me they will tell you I’m not a terribly serious person....
2014-04-11 (first published: 2014-04-08)
1,632 reads
Blogs
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...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
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...
Tracking All the Queries
Comments posted to this topic are about the item Tracking All the Queries
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