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
461 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
842 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,709 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
367 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
770 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
802 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
459 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
573 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
415 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
622 reads
Blogs
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Free Online Sessions – Building the €100 DWH and Indexing for Dummies
I’m giving two online sessions soon on virtual events that are free to attend....
Forums
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Revisiting SQL Server Window Functions- A Practical Walkthrough
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
Tables with a SPARSE Column and Consumption
Comments posted to this topic are about the item Tables with a SPARSE Column...
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers