I mentor, teach, and consult about SQL Server. It’s an incredible tool –it is an extremely flexible, adaptable, and complex data environment. SQL Server is capable of bringing tremendous...
2014-06-25
7 reads
I mentor, teach, and consult about SQL Server. It’s an incredible tool –it is an extremely flexible, adaptable, and complex data environment. SQL Server is capable of bringing tremendous...
2014-06-25
8 reads
There may be an easier way, but this was a quick way to find ALL the checked out files in...
2014-06-24
1,411 reads
ISSUE : FIX for Data loss in clustered index occurs when you run online build index in SQL Server 2012
Microsoft release...
2014-06-24
889 reads
No Files For You is another Question Of The Day. I ended up making this one just a little more...
2014-06-24
477 reads
This post follows on from Partitioning Basics – Part 2
In this final part, I want to go through how partitions can...
2014-06-24 (first published: 2014-06-20)
3,228 reads
It’s always an honour to be able to speak at an event, but events can be expensive to attend and...
2014-06-24
687 reads
Retrieve data about size and space used for all the files in the current database with this script.
Some tips on...
2014-06-24
761 reads
In order to reduce Tempdb contention one of the best practices is to maintain multiple sized Tempdb data files, matching the...
2014-06-24
1,241 reads
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2014-06-23 (first published: 2014-06-18)
4,292 reads
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Is there a good syllabus for reading these two together? (Yes, it's called the...
Comments posted to this topic are about the item GPX distance and time analysis...
Comments posted to this topic are about the item The DBA is Dead; Long...
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers