Clients sometimes forget to give me admin rights. IS_SRVROLEMEMBER(‘sysadmin’) checks if the current login is a Server Role Member: 1 means yes, 0 means no.
SQL SERVER – Introduction to JOINs – Basic of JOINs
A simple introduction to JOINs: INNER JOIN and the three OUTER JOIN types, written for members of the Gandhinagar SQL Server User Group who asked for it.
SQL SERVER – Interesting Observation of DMV of Active Transactions and DMV of Current Transactions
sys.dm_tran_active_transactions and sys.dm_tran_current_transaction look alike, but one lists active transactions for the instance, the other only your session.
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.
SQL SERVER – Mirrored Backup and Restore and Split File Backup
From a real project: conventional backup and restore, split file backup when a disk runs short of space, mirror file backup, and the FORMAT clause.
EXCEPT: Compare Distinct Sets Including NULL
EXCEPT returns distinct left-side rows absent on the right. Compare direction, duplicates and NULL equality using complete small result sets.