Standard DBA reports can use T-SQL to show backup age, database sizes, job failures, login changes, and errors in one weekly review.
SQL SERVER – Fix Error 9803. Invalid data for type “numeric” – Data Type Mapping
My present article talks about an error that you will encounter when connecting to Oracle database using OPENQUERY. Let us learn about how to fix error 9803.
SQL SERVER – Maximum Columns per Primary Key – Fix : Error : Msg 1904, Level 16, The index on table has column names in index key list. The maximum limit for index or statistics key column list is 16
What are the maximum columns per primary key? It is 16, and going past it raises Msg 1904. The same limit applies to foreign keys and index keys.
Reading the SQL Server Support Lifecycle
Read the SQL Server support lifecycle for your exact release, distinguish mainstream and extended support, and plan before coverage ends.
SQL SERVER – Server Type and File Extention
Double click a .sql file and SSMS opens. Here is the file extension used by each SQL Server type, from .sql and .sqlce to .mdx for Analysis Services.
SQL SERVER – Logical Query Processing Phases – Order of Statement Execution
Logical Query Processing is the order in which SQL Server handles each clause of a statement, with FROM and ON first and SELECT near the end. Here are the phases.
SQL SERVER – 2008 – Management Studio New Features
The top 5 Management Studio new features in SQL Server 2008 that DBAs asked for, and how SSMS grew out of Enterprise Manager and Query Analyzer.