My Vista Windows Authentication login failed with Error 18456 after installing SQL Server 2005, while sa worked. Adding my login as administrator fixed it.
SQL SERVER – Find Table in Every Database of SQL Server – Part 2 Extension
Two more ways from Simon Worth to find table in every database of SQL Server, both built on sp_msforeachdb, one saving results to a temp table.
ACOS: Check the Cosine Domain Before Calculating Angles
ACOS calculates an angle from a supported cosine ratio. Keep invalid and missing inputs visible while displaying valid radians at a chosen scale.
PERCENT_RANK Versus CUME_DIST: What Ties Change
PERCENT_RANK versus CUME_DIST answers different ranking questions. Keep peers intact and compare missing scores and singleton groups.
NOT and NULL: Unknown Does Not Become True
NOT and NULL do not create a complete two-way classification. State whether missing values belong in a filter or a separate reporting category.
Writing a Good Technical Blog Post
A technical blog post works when it solves one problem with tested code, clear assumptions, a readable result, and honest limits.
SQL SERVER – Find Table in Every Database of SQL Server – Part 2
Part 2 of how to find a table in every database of SQL Server: this stored procedure loops through sys.databases and reads the Information_Schema view.
SQL SERVER – Find Table in Every Database of SQL Server
sys.tables only searches one database. My quick stored procedure finds a table in every database on the server and returns database, schema and table name.
What Is an Index in SQL Server?
An index in SQL Server took one query from 33,517 reads to 66 on the same table. What clustered and nonclustered really mean, why every index is paid for on the way in, and how to find the ones nobody uses.
CHARINDEX Start Position: Find the Second Delimiter
CHARINDEX start position finds the next delimiter. Guard a missing first match, preserve NULL, and extract empty fields without negative lengths.