Several ways to list all the database names on a server, from sp_databases and sp_helpdb to sys.databases and sp_msForEachDB. I use sp_databases myself.
SQL SERVER – Fix : Error : Msg 6263, Level 16, State 1, Line 2 Enabling SQL Server 2005 for CLR Support
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.