Most people run SELECT * FROM sys.tables to list tables. If you do not need all those details, sys.sp_tables returns tables and views with schema names.
datetime2 Precision: Rounding Can Cross Midnight
datetime2 precision changes can round into the next second or date. Compare typed seven-digit values with millisecond and whole-second conversions.
Where a Self-Service Report Actually Gets Its Data
Trace self-service BI numbers through source data, transformations, refresh schedules, credentials, gateways, and the owner of each step.
SQL SERVER – 1500 Posts – A MileStone – Origin of Blog Name Revealed
For my 1500th blog post, I keep a promise and reveal the origin of blog name SQLAuthority.com, inspired by a ColdFusion site called Fusion Authority.
SQL SERVER – Visiting Alma Mater – Delivering Session on Database Performance and Career – Nirma Institute of Technology
I went back to my alma mater, Nirma Institute of Technology in Ahmedabad, to deliver a session on database performance and career. It felt wonderful.
SQL SERVER – Indexed View always Use Index on Table
A table can have only one clustered index, but what about an indexed view built on the whole table? My T-SQL Tuesday post tests which index SQL Server uses.
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.
SQL SERVER – Simple Explanation of Data Type Precedence
A simple explanation of data type precedence: filter an INT and a VARCHAR column with N’1′ and N’First’, then see what the execution plan shows.










