Scary Scalar Functions series overview
Part One: Parallelism
Part Two: Performance
Part Three: The Cure
Foreword
In the first two parts, we have seen why the Scalar functions (UDFs) are a problem for the...
2022-07-29 (first published: 2022-07-24)
568 reads
Foreword
This month’s invitation is from Deborah Melkin (b|t), about venting anything you want. So let’s start this rant.
There are only two hard things in Computer Science: cache invalidation and...
2022-07-29 (first published: 2022-07-12)
281 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-07-28
27 reads
I recently passed the second anniversary of the start of my stay in the hospital. A lot has happened since ... Continue reading
2022-07-28
32 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-07-27
41 reads
Good morning dear reader. Today I am writing this blog while sitting at a trampoline park. My six-year-old son loves this place, and we tend to find ourselves here...
2022-07-27 (first published: 2022-07-12)
275 reads
It’s T-SQL Tuesday again! Deborah Melkin (blog|twitter) is our host this month and she’d like to hear our opinion. A ... Continue reading
2022-07-27 (first published: 2022-07-12)
386 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-07-26
9 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-07-25
22 reads
In the last Database Fundamentals post, I explained what a unique constraint was and how you can create them using the GUI. Using TSQL to create a constraint is...
2022-07-25
90 reads
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Comments posted to this topic are about the item Liability for AI Errors
Hello , I would like to run a stored procedure on a secondary replica...
Comments posted to this topic are about the item Pro SQL Server Internals
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