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,019 reads
Blog Posts
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
853 reads
An Analogy is like a Tree….
For years, I’ve been trying to express how everything ties into everything else. A big part of understanding any given...
2011-03-25
491 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
721 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,057 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,750 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
625 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,697 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
751 reads
Fast File Copy With Managed Code: UBCopy update!
If you have been following my trials with working with C# and files you know it hasn’t been a bed...
2011-03-24
1,128 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers