TSQL Tuesday #84: Zip to Speaker
Well, it’s that time of the month again. It’s T-SQL Tuesday yet again, and this time round it’s Andy Yun (b/t)...
2016-11-08
466 reads
SQLStudies
New indexes, hypothetically
I saw something like this the other day. My first thought was “Hu, never seen that before.” My second thought...
2016-11-02
858 reads
The Halloween Problem
DBA: Help me! Help me! It’s Halloween! I have a problem! Oh won’t you please help me!
Ok, so that’s really...
2016-11-07 (first published: 2016-10-31)
2,723 reads
It’s a small world
As I write this we are packing to leave for Disney World, where my family and I will spend close...
2016-10-26
374 reads
Synchronous vs Asynchronous
You’ll hear these terms thrown around in programming all the time, but what do they mean and why do we...
2016-10-24
778 reads
Installing SQLCMD
For anyone who wasn’t aware SQLCMD is a command line tool for running T-SQL statements and scripts. Before anyone says...
2016-10-19
908 reads
Using Snippets
A while ago I talked about Templates. This is an easy way to get a, well, template of a piece...
2016-10-17
465 reads
Too many indexes!
Indexes are great. They speed up our queries. In fact, without them relational database systems wouldn’t work.
Different indexes work best...
2016-10-13
585 reads
If backups are taken in silence can a recovery still take place?
My friend Andy Mallon (b/t) is hosting T-SQL Tuesday this month. In case you aren’t aware T-SQL Tuesday is a...
2016-10-11
422 reads
Floor, Round, and Ceiling
I saw an interesting question today about rounding. Specifically they always wanted to round down. Now as it happens that...
2016-10-05
635 reads
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers