South Alabama Day of .NET 2014
About 200 miles east of Baton Rouge there lies a beachside town called Mobile, AL that will settle down long...
2014-03-27
747 reads
Blog Posts
Tally Tables in T-SQL
The Tally (or Numbers) table is one of the most useful constructs in intermediate-level SQL. Have you ever written a...
2014-03-27
57,028 reads
The power of the baseline
There is one thing we all have in common, and a lot of us probably don’t even realize it, baselines!
...
2014-03-27 (first published: 2014-03-21)
2,527 reads
5 Top Features Your Company Can Use in SQL Server 2014 Standard Edition
In a few days SQL Server 2014 will be made available, we’re not all lucky enough to be running Enterprise...
2014-03-26
1,159 reads
Collation: Expression
I had a recent run in with collation problems and it got me started reading. As I read I started...
2014-03-26
513 reads
Conditional Coloured Bar Charts in Excel with Upper and Lower Targets
I was just trying to gauge my BI knowledge level the other day and decided to chart it for visibility....
2014-03-26
576 reads
Error 701 - Insufficient System Memory - Now what?
This story begins, as so many often do, with a few key elements:1) A client who experienced a problem on...
2014-03-26 (first published: 2014-03-20)
9,557 reads
Getting an INDEX SEEK to Speed up LIKE “%string%” Searches
In today’s blog I will attempt to challenge the popularly held notion that LIKE “%string%” wildcard searches must be slow...
2014-03-26
20,700 reads
Speaking at OPASS – April 2014
If my blog history is correct the last time I presented at oPASS was January 2012 – that seems like a...
2014-03-26
627 reads
SQL Saturday Oklahoma City precon: Becoming an Enterprise DBA
We’ll be at OKC this summer for their SQL Saturday on August 23, and we’re presenting our precon “Becoming an...
2014-03-26
615 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
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...
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