Reblog: March 8 to March 14
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-03-15
713 reads
StrateSQL
Pragmatic Works Webcasts This Week #passwit
Every week, Pragmatic Works offers up its “Training on the Ts” webcast series and this month, in honor of Women’s History Month,...
2013-03-11
565 reads
Last Weeks Top 20 “Reading” Links #23
Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet....
2013-03-11
558 reads
Reblog: March 1 to March 7
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-03-08
627 reads
Index Analysis March Update
In yesterdays duplicate index blog post, I mentioned that there would be an update to the index analysis stored procedure...
2013-03-07
712 reads
That’s Actually A Duplicate Index
As I’ve worked with clients on performance tuning through index improvements, one of the common areas that I discuss with...
2013-03-06
2,433 reads
March 2013 – Monthly SQL Server Checklist
It’s the first Monday of the month, do you know where your servers are?
Hopefully, they are still in your data...
2013-03-04
803 reads
Last Weeks Top 10 “Reading” Links #22
Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet....
2013-03-04
585 reads
Reblog: February 22 to February 28
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-03-01
926 reads
Presentation Materials “A Function is a Function”
Here are the presentation materials for today’s Pragmatic Works Training on the T’s session A Functions Is A Function – Comparison of...
2013-02-28
1,275 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
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...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
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-...
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