Silent truncation can happen while SQL Server evaluates a bounded expression. These examples compare the lost characters with a max expression and a max REPLICATE input. Check stored lengths before blaming a clipped display.
SQL SERVER – CASE Statement/Expression Examples and Explanation
The CASE Statement/Expression works anywhere an expression can, from the SELECT list to WHERE and HAVING. Here are its two basic forms with examples.
SQL SERVER – Fix : Error: 18452 Login failed for user ‘(null)’. The user is not associated with a trusted SQL Server connection.
Error: 18452 Login failed for user ‘(null)’ means the server only allows Windows Authentication. Switch to Mixed Mode and enable the sa login to fix it.
SQL SERVER – Stored Procedures Advantages and Best Advantage
My take on stored procedures advantages, and the best one of all: execution plan retention and reuse, since the rest can be had without them.
SQL SERVER – Script to Find SQL Server on Network
I manage lots of SQL Servers and forget their names, so I use xp_CMDShell and ISQL -L to find SQL Server on network machines. A short video is included.
SQL SERVER – 2005 – Disable Triggers – Drop Triggers
Two ways to stop a trigger from firing in SQL Server 2005: drop it or disable it. I prefer DISABLE TRIGGER and show the syntax to disable triggers.
SQL SERVER – Fix : Error 1702 CREATE TABLE failed because column in table exceeds the maximum of columns
Error 1702, CREATE TABLE failed, happens when a table goes past the 1024 column limit in SQL Server 2000. The fix is to cut the columns to 1,024 or fewer.