Category: SQL Internals

VARCHAR or CHAR?

April 13, 2009 Mohit

Question: Which column type to use? Answer: It depends …. Explanation: SQL Server stores fixed width and variable length columns different. When storing a VARCHAR,

Rate this:

INSERTED and DELETED Logical Tables

February 23, 2009 Mohit

The INSERTED and DELETED logical tables that exist in SQL Server and allow for handling the data when information is inserted, updated and deleted in

Rate this:

Contact Me

mohitkgupta@msn.com

Contact me if you need assistance with PTO, HADR, Automation, etc. :)

Search for:

Tags

ApexSQL Tools Authentication Automation Capacity Planning Central Management Server CMS Computed Columns Configuration Health CTE CTP Database Corruption DBA Queries DBCC CHECKDB Distributed Transactions DMF - sys.dm_exec_query_plan DMF - sys.dm_exec_sql_text DMF - sys.dm_io_virtual_file_stats DMV - sys.dm_exec_query_stats DMV - sys.dm_exec_requests DMV - sys.dm_os_waiting_tasks fn_dblog Hekaton in-doubt xact resolution In-Memory OLTP Index Management Jan 2019 Update KB Articles Kerberos Lazy Writer Linked Servers Maintenance Plans Microsoft Forever Modeling mofcomp M Query Language Multi-Server Management Named Pipes Non-Technical NUMA Configuration OBJECT_NAME Operating System Error 5 PAL perfmon Performance Counters Permissions Power Query Language PowerShell Presentation Processor Imbalance References Security Service Principal Names (SETSPN) Slicer Pane Smart Guides SQL Error 5172 SQL Error 18456 SQLOpDB Reports SQLOpsDB Reports SQLPASS SQL Patches & Hotfixes SQL Server Disaster Recovery SSIS SSMS SSMS 2008 SSPI Error SSRS Suspect Database Syntax Highlight sys.database_mirroring_endpoints sys.dm_tran_active_transactions sys.indexes sys.tables sys.tcp_endpoints Undocumented Functions Wait Types

Register
Log in
Entries feed
Comments feed
WordPress.com

Blog Stats

149,803 hits

Website Powered by WordPress.com.

Subscribe Subscribed
- SQL Canada (SQLCAN)
- Already have a WordPress.com account? Log in now.