Product and Book Reviews

SQLServerCentral Article

Review: Loading Sample Data with DataTect 1.6

  • Article

So, you've created a database and application and want to see how it operates with a substantial load of data In this product review of Datatect 1.6, you can learn how this third-party product could help you benchmark you database with a lot of sample data.

4 (1)

You rated this post out of 5. Change rating


3,883 reads

SQLServerCentral Article

Product Review: Log Explorer 2.0

  • Article

Anyone that has ever forgotten a WHERE clause in an UPDATE or DELETE syntax still has the bruises. Log Explorer 2.0 has a way of reversing your mistakes by peering into the transaction log and rolling back transactions. This, week Brian Knight reviews this product.

You rated this post out of 5. Change rating


7,740 reads


Async stats update causing blocking


I recently encountered an issue where an index rebuild set to wait_at_low_priority ended up...

Level Up Your SQL Skills: The Best Intermediate to Advanced Courses


In the data-driven landscape of 2024, advanced SQL isn't just a nice-to-have, it's a...

Query deadlock info in Azure SQL DB


A couple of weeks ago, a developer came to me and wanted to know...

Read the latest Blogs


how to find the cpu memory disk and network of the OS where RDS is residing.

By rajemessage 14195

hi, i have one RDS, but i do not have any other permissions, and...

“user_scans” of table “sys.dm_db_index_usage_stats”

By Meera

I am trying to find answer to the below. What exactly the scan means...

how to assign studentid from one table to other one? please

By Zond Sita

Good Morning,   how to assign query one results to query 2 student id,...

Visit the forum

Question of the Day

A Lack of Memory Grant Feedback Persistence

SQL Server has added an Intelligent Query Processing feature called Memory Grant Feedback. In SQL Server 2022, this can be persisted across queries to improve the performance of future executions. In SQL Server 2022, when is memory grant feedback not persisted if the plan is evicted from cache? (choose 2)

See possible answers