SQL Server Crossword #3 – Solution
Here’s the solution to SQL Server Crossword #3.
I hope you enjoyed it. Let me know if you would like me...
2011-03-27
1,022 reads
Cluster failover – what’s the best way to get notified?
G’day,
I look after several clustered instances of SQL SERVER. One of the tasks that I do every morning is to check...
2011-03-27
2,836 reads
Designing Reports with Custom MDX Queries – part 1
This article is the first in a three-part series
On the Microsoft Developer Network (MSDN) forum for Reporting Services and other...
2011-03-27
1,376 reads
Index Black Ops Series
Previously, in a TSQL2sDay index summary post, I started a series on the DMV sys.dm_db_index_operational_stats. The series investigates how the...
2011-03-26
856 reads
DevWeek 2011 – Day 1
Unfortunately, I couldn’t be in two places at one time, there were two tracks dedicated to the SQL Server DBA...
2011-03-25
722 reads
OUG Back to Basics Event – London Mar 2011
First Things First
At UKOUGs’ Back to Basics Special Event held in London today (Mar 24th), Niall Litchfield presented a very worthwhile...
2011-03-25
626 reads
Why I don’t like NULLs and Nullable Columns
As I imagine (or hope), the majority of us adhere to some form of standards in the environment that they...
2011-03-25
755 reads
How Many Bytes Are In My Column? – T-SQL Functions
One of the things you want to be aware of when writing T-SQL is using the proper function for a...
2011-03-25
4,059 reads
The Mystery Of The Slow Last Row
Things Go South
Recently I was troubleshooting a piece of software that archives data out of a very active import table....
2011-03-25
1,699 reads
NOLOCK for Developers
What is NOLOCK?
NOLOCK is a table hint for SQL Server that tells the engine to not take locks and ignore...
2011-03-25
1,755 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
Forums
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
A Worse Computer; A Better Car
Comments posted to this topic are about the item A Worse Computer; A Better...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers