SQL Server Infernals – Circle 5: Inconsistent Baptists
There’s a place in the SQL Server hell where you can find poor souls wandering the paths of their circle,...
2015-07-23 (first published: 2015-07-17)
2,935 reads
There’s a place in the SQL Server hell where you can find poor souls wandering the paths of their circle,...
2015-07-23 (first published: 2015-07-17)
2,935 reads
Choosing the right data type for your columns is first of all a design decision that has tremendous impact on...
2015-07-10 (first published: 2015-07-02)
2,227 reads
Constraints are sometimes annoying in real life, but no society can exist without rules and regulations. The same concept is...
2015-07-07
827 reads
Object-Oriented programming taught us that generalizing is a good thing and, whenever possible, we should do it. Complex class hierarchies...
2015-06-29 (first published: 2015-06-24)
983 reads
There’s a special place in the SQL Server Hell for those who design their schema without following the Best Practices....
2015-06-17
876 reads
Today I’m starting a new blog series called “SQL Server Infernals”.
Throughout this series, I will take your hand and walk...
2015-06-09
671 reads
I usually don’t post small things like this, but today I fought with this obnoxious problem long enough to convince me that...
2015-06-02 (first published: 2015-05-26)
1,572 reads
Don’t be fooled by the title of this post: while counting the number of rows in a table is a...
2015-05-25 (first published: 2015-05-18)
9,259 reads
One of the things I hate the most about “old” databases is the fact that unused tables are kept forever,...
2015-04-29 (first published: 2015-04-20)
16,629 reads
If you want to have faster turnaround on your forum questions, you will need to provide enough information to the...
2015-04-24
2,284 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