Error:
Fix : Error : Msg 6263, Level 16, State 1, Line 2 Enabling SQL Server 2005 for CLR Support
1) Enable Server for CLR Support.
SQL SERVER – Explanation SQL Command GO
GO is not a T-SQL command. It tells SQL Server tools to send the current batch. Why a GO statement must sit on its own line, and how it ends a batch.
How the Main System Views Connect
Learn how the main system views connect through object_id, schema_id, index_id, and column_id so catalog joins stay accurate.
Estimating How Much Memory SQL Server Needs
How much memory SQL Server needs depends on the active working set, grants, and host headroom; learn to measure pressure and avoid fixed ratios.
SQL SERVER – Fix: Error: HResult 0x2, Named Pipes Provider: Could not open a connection
Fix for HResult 0x2, Named Pipes Provider: could not open a connection to SQL Server. Enable TCP/IP and Named Pipes in SQL Server Configuration Manager.
Data Types That Waste Space
Data types that waste space include oversized integers, blanket nvarchar(max), and unnecessary datetime2 precision; measure before changing.
SQL SERVER – Fix : Error 2501 : Cannot find a table or object with the name . Check the system catalog.
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.