A simple way to change column datatypes in SQL Server with ALTER TABLE ALTER COLUMN, shown on a sample table and checked with sp_help.
Accent-Insensitive Searches: Finding Jose and José Together
Build accent-insensitive searches with explicit collations, compare case rules, and index a computed search column for consistent lookup.
SQL SERVER – Encrypted Stored Procedure and Activity Monitor
Can you see the definition of an encrypted stored procedure in Activity Monitor? The answer is No. Here is a quick test that proves it.
The New Go-Based sqlcmd: What Changed
The Go-based sqlcmd adds modern commands and contexts, but ODBC sqlcmd scripts need flag, output, and exit-code tests before a swap.
Indexed View Quiz: The Table and Clustered Index Confusion
An indexed view and its base table can each own a clustered index because they are separate objects. Inspect both owners in a SQL example and see why a view index does not give its base table a second clustered index.
SQL SERVER – Find Total Number of Transactions on Interval
How many Transactions run on your server per minute? A handy script reads sys.dm_os_performance_counters twice with a WAITFOR DELAY between the reads.
SQL SERVER – The Limitations of the Views – Eleven and more…
I had earlier written, interesting article series on the limitations of the views. I had a great time writing this series. I got many many requests.