Unexpected truncation in FETCH
Yes I’m talking about FETCH as in a cursor, yes everyone hates cursors. But you know cursors are like anything...
2013-10-23
726 reads
Blog Posts
Webcast Follow-Up: Choosing Your Clustered Index
Earlier this month, I presented a session for Pragmatic WorksTraining on the T’s on the selecting the clustered index for a...
2013-10-23
967 reads
Webcast Follow-Up: How Do Non-Clustered Indexes Improve Performance?
Earlier this month, I presented a session for Pragmatic WorksTraining on the T’s on the selecting the clustered index for a...
2013-10-23
960 reads
Back to basics: Transact-SQL programming fundamentals – (Part 1)
SQL Server users use Transact-SQL programming to create sets of statements for ad-hoc execution. The aim of the Transact-SQL programming...
2013-10-22
1,137 reads
Back to basics: Transact-SQL programming fundamentals – (Part 2)
In the first of this three-part series, you will learned how to use scripts and batches, and basics of T-SQL...
2013-10-22
1,217 reads
Children at Technical Conferences
I have had the pleasure of taking my son with me on a number of trips where I was a...
2013-10-22
830 reads
Monitoring Structure Changes
Most everyone I know works with environments that are carefully controlled and structured. All changes go through rigorous testing and...
2013-10-22 (first published: 2013-10-15)
2,298 reads
PASS Summit 2013
Adam and I attended PASS Summit for the first time this year in Charlotte, NC. We had a great time and enjoyed meeting new people. The following are a...
2013-10-22
12 reads
PASS Summit 2013
Adam and I attended PASS Summit for the first time this year in Charlotte, NC. We had a great time and enjoyed meeting new people. The following are a...
2013-10-22
4 reads
PASS Summit 2013
Adam and I attended PASS Summit for the first time this year in Charlotte, NC. We had a great time...
2013-10-22
944 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