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.