Error 2501, cannot find a table or object with the name, is a common beginner error. Check the database with USE, the spelling and case, and the owner name.
SQLAuthority News – Author Visit – MIS2007 Part II – Database Raid Discussion
At MIS2007 we had a database RAID discussion: RAID 5 or RAID 10 for databases from 5 GB to 5 TB. Almost everyone picked RAID 10, even though it costs more.
Index Optimization Checklist: A Printable One-Page Guide
The twelve things I ask a junior DBA to check before I touch a slow query, with three quick proofs you can run yourself.
SQLAuthority News – Author Visit – The 2007 Marketing Innovation Summit, Las Vegas
Notes from the 2007 Marketing Innovation Summit in Las Vegas, arranged by Unica: the agenda, the industry leaders I met and a few SQLAuthority.com readers.
REGEXP_LIKE in SQL Server 2025: Validating Codes, Emails and Phone Numbers
Validate codes, email shapes and phone numbers with REGEXP_LIKE in SQL Server 2025, using clear patterns and CHECK constraints.
SQL SERVER – 2005/2000 Examples and Explanation for GOTO
How the GOTO statement jumps to a label in the same T-SQL batch. My explanation for GOTO covers the syntax, the rules and when I still use it.
SQL SERVER – Creating Comma Separate Values List from Table – UDF – SP
Three ways to build a Comma Separate Values List from a table: COALESCE, a smart SELECT, or a cursor. Written for SQL Server 2005 with VARCHAR(MAX).