Author: Amit Bansal
SQL Server Drop Table – Serious SQL Fun
Share it if you like it.
SQL Server Drop Table – Serious SQL Fun Read MoreSQL Server Memory Nodes – How many do I have?
Hi Friends, SQL Server Memory Nodes serve the foundation for SQL Server Memory and they have one-to-one mapping with physical NUMA nodes. For example, if your system has four physical NUMA …
SQL Server Memory Nodes – How many do I have? Read MoreSQL Server Query Tuning – Serious SQL Fun
Share it if you like it!
SQL Server Query Tuning – Serious SQL Fun Read MoreSQL Server Restart
Share it if you like it!
SQL Server Restart Read MoreREAD UNCOMMITTED Isolation Level honors locks
Hi Friends, It’s a well-known fact that READ UNCOMMITTED Isolation Level in SQL Server allows dirty reads. In other words, if a transaction is running under READ UNCOMMITTED Isolation Level, it …
READ UNCOMMITTED Isolation Level honors locks Read MoreSET STATISTICS PROFILE ON
For example, in the above plan (zoomed out), it’s tedious to figure out where cardinality estimation has gone bad. You hover the mouse cursor over every arrow to see the numbers …
SET STATISTICS PROFILE ON Read MoreSQL Server Implicit Conversion
Hi Friends, Are SQL Server Implicit Conversions expensive? Yes, they are! Not only does a SQL Server Implicit Conversion takes extra CPU, it can also cause loss of precision or fail …
SQL Server Implicit Conversion Read MoreSQL Server Query Elapsed Time
Hi Friends, This is based on a forum question and I see many are still confused with SQL Server Query Elapsed Time that you see under Messages tab in SSMS when …
SQL Server Query Elapsed Time Read More