They immediately paid for Comprehensive Database Performance Health Check and we got online to look at their strange error related to alias.
SQL SERVER – Unable to Start SQL Server Service or Connect After Incorrectly Setting Max Server Memory to a Low Value
After incorrectly setting max server memory to 14 MB instead of 145000, a client could not start SQL Server. Here is how we got it back online.
ROWCOUNT_BIG and @@ROWCOUNT: Checking What a Statement Changed
Capture ROWCOUNT_BIG immediately after a change, validate expected counts, and handle NOCOUNT, triggers, and MERGE without stale values.
Get Partition Info in SQL Server: Rows and Boundaries
To get partition info in SQL Server, join sys.partitions to the partition scheme, function and filegroup views. This post builds a small partitioned table, lists every partition with its boundaries, row count and filegroup, and shows how to find the partition for a value. It also lists the tables that have more than one partition.
SQL SERVER – Table Variables or Temp Tables – Performance Comparison – SELECT
Today we are going to discuss the performance comparison of table variables and temp tables when we are running SELECT queries.
Where is Table Variable Created? – Interview Question of the Week #243
Question: Where is Table Variable Created?
Answer: On Hard Disk and NOT in Memory.
I suggest you read the following blogs
SQL SERVER – Table Variable or Temp Table – Performance Comparison – INSERT
In this blog post, we will talk about Performance Comparison between Table Variable or Temp Table. Comprehensive Database Performance Health Check