Buzzword Bingo
Grant Fritchey (b/t) is our host for T-SQL Tuesday this month and surprise surprise he’d like to talk about DEVOPS....
2017-06-13
967 reads
SQLStudies
UDP vs TCP
If you’ve worked much with named instances you’ve probably had to deal with the question “What port is that instance...
2017-06-07
535 reads
Backup to NUL
Yes, I spelled that correctly. NUL not NULL. NUL is basically a location you can send a backup to. In...
2017-06-05
4,483 reads
SQL Crossword
I thought I’d do another crossword. Enjoy! If you need any help with it feel free to let me know...
2017-06-16 (first published: 2017-05-31)
2,802 reads
Running multiple queries at the same time.
I read an interesting question today. Someone wanted to be able to run the same stored procedure multiple times, at...
2017-06-08 (first published: 2017-05-24)
9,267 reads
What’s in a partition?
In my last post on partitioning I used the $Partition command in passing. I’ve been thinking it deserves a bit...
2017-05-22
502 reads
T-SQL FizzBuzz
I was looking around for something to write about this evening and came across one of Russ Thomas’ (b/t) old...
2017-05-17
2,860 reads
Why shouldn’t I shrink my database log file?
TL;DR: It’s pretty pointless and can cause performance issues.
Let’s start by asking why you might want to shrink your log....
2017-05-15
476 reads
Dynamic SQL and the joys of QUOTENAME
I’m a big fan of dynamic SQL. In the past I’ve written a How to, a Best Practices and even...
2017-05-11
583 reads
Continuous Integration
It’s T-SQL Tuesday again! This month we are being hosted by James Anderson (b/t). Thanks James! He has asked us...
2017-05-09
413 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