SQL Server Locking Overview
Locking is a necessary part of transaction processing when working in a multi-user Online Transaction Processing (OLTP) environment. You use...
2012-10-21
12,349 reads
Does a Clustered Index really physically store the rows in key order?
The Myth
One misconception that I see a lot deals with how data is stored in a clustered index. Specifically – is...
2012-10-21
8,177 reads
Ask The Unicorn: SQL Saturday Registration Is Closed
Right before the last Minnesota SQL Saturday, I was asked a few questions about learning about SQL Server which led...
2012-10-20
772 reads
fn_OBJECT_TYPE
I recently started using OBJECT_NAME, OBJECT_SCHEMA_NAME and OBJECT_ID functions; unfortunately I really could have used OBJECT_TYPE but it doesn’t exist...
2012-10-19
1,256 reads
SQL Server 2008 Diagnostic Information Queries (Oct 2012)
Here is the October 2012 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-10-19
1,712 reads
Reblog: October 12 to October 18
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-10-19
520 reads
This December–SQL Server Consolidation and Virtualization
This December (5th - 7th) I will be presenting SQL server Consolidation and Virtualization: Hands-On for Learning Tree in New York....
2012-10-19
933 reads
A Minor Problem of Access
A colleague sent this - they received a trouble ticket where a user who had "all access" to the database couldn't...
2012-10-19
636 reads
this is what I do when I install SQL. How about you?
Whenever I install a standalone SQL instance (installing on a failover cluster adds a few more steps) on a x64...
2012-10-19
877 reads
Address Clean-up for Mail Merge using SSIS
Remember the good ol’ days of going through a list of addresses and manually cleaning up hundreds if not thousands...
2012-10-19
747 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Absolute and Relative References
Comments posted to this topic are about the item Absolute and Relative References
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I