Beware the defaults! (in windowing functions)
Some time ago I was writing some windowing functions on a set of data. Basically I was looking for the...
2014-10-15 (first published: 2014-10-07)
6,645 reads
The full text error and why I was happy to see it.
The Situation: I was recently involved in the migration of a group of core databases from three SQL Server 2005 instances to...
2014-10-15 (first published: 2014-10-07)
6,151 reads
Making Better Presentations–Practice
This is part of a series of tips for speakers on how to make your presentations better.
There’s one thing that...
2014-10-06
847 reads
Number of VLFs and Autogrowth Settings Colour Coded to Excel with PowerShell
So you have read up on VLFs
No doubt you will have read this post by Kimberly Tripp and this one...
2014-10-06
719 reads
Does Full Backup contain data inserted during backup ?
Question : When you take full backup, do it capture data till the time backup start time or till the time backup end. Answer : Full backup capture database...
2014-10-06
16 reads
Carolina Technology Conference: Presentation Materials
For those able to attend my session at this year’s Carolina Technology Conference, thank you! As promised, here are the...
2014-10-06
805 reads
The Question – Why?
The question I get asked a lot by other data professionals at conferences, events, speaking engagements, family, friends, etc. is...
2014-10-14 (first published: 2014-10-06)
5,963 reads
Thoughts on the Student to IT Pro Seminar
Miscellaneous notes as I think on this.
I’ve been reading through feedback from the students. Reading the raw feedback is interesting...
2014-10-06
766 reads
You can’t use aggregate/windowing functions with CROSS APPLY
One of my favorite features of CROSS APPLY is the ability to use it instead of a calculated variable. Well...
2014-10-13 (first published: 2014-10-06)
9,198 reads
Does Full Backup contain data inserted during backup ?
Question : When you take full backup, do it capture data till the time backup start time or till the time...
2014-10-06
769 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Trigger isn't working
Hi, I have a trigger, that works fine elsewhere but is not working at...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers