How Do I Spot Identity Columns That Are About to Max Out?
Every so often, usually in the middle of the night or on a holiday weekend, an identity column will hit...
2010-10-05
913 reads
Adventures in SQL
Can Deadlocks be Resolved by Adding an Index?
Can Deadlocks be Resolved by Adding an Index? Yes. Really, I’m not kidding. Here, I’ll show you how.
First, let me...
2010-09-27
1,109 reads
A Little Help with Azure Please
Not long ago Microsoft announced a new product called Azure AKA “SQL Server in the Cloud”. I have to say...
2010-09-23
320 reads
What Did that Geek Just Say?
Working in a technical field has it’s ups and downs. One of the more common annoyances I run into is...
2010-09-21
320 reads
What Did that Geek Just Say?
The National Institute of Standards and Technology, NIST, maintains a Dictionary of Algorithms and Data Structures. The dictionary is a great place to go to find out what people...
2010-09-21
1 reads
What Did that Geek Just Say?
The National Institute of Standards and Technology, NIST, maintains a Dictionary of Algorithms and Data Structures. The dictionary is a great place to go to find out what people...
2010-09-21
How is Fill Factor Impacting My Indexes?
The theme for this month’s T-SQL Tuesday is indexes so it seemed like the perfect excuse to blog about a...
2010-09-14
839 reads
How is Fill Factor Impacting My Indexes?
The theme for this month's T-SQL Tuesday is indexes so it seemed like the perfect excuse to blog about a script that I have written to see what choices...
2010-09-14
18 reads
How is Fill Factor Impacting My Indexes?
The theme for this month's T-SQL Tuesday is indexes so it seemed like the perfect excuse to blog about a script that I have written to see what choices...
2010-09-14
1 reads
Quote of the Day
I do not usually post a quote of the day but since this is my own quote I decided to...
2010-09-13
350 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...