Simple SQL Server

TempDB memory leak?

I found a bug where I’m seeing TempDB use more memory than it should on multiple versions of SQL Server, especially on servers set up with common best practices. There’s a...

2016-01-05

1 reads

Blogs

Extended Events Misperceptions: Profiler is Easier, Part 2

By

I wrote a short blog post about the misperception that Profiler was easier than...

CREATE TABLE MyTable (Col1 CHARACTER VARYING (50))

By

If you read the title to this post and your first thought was That’s...

sys.xp_delete_files and ‘allow filesystem enumeration’: two new undocumented items in SQL Server 2019

By

sys.xp_delete_files and 'allow filesystem enumeration': two new undocumented items in SQL Server 2019… Continue...

Read the latest Blogs

Forums

SSMS 18.4 (SQL 2014) Activity Monitor Always Blank

By Luv SQL

I have not been able to get any Processes to show in the Activity...

2-node cluster, multiple SQL instances

By lanky_doodle

Hi, What are the best practices/guidelines for this? Currently have a 2-node WSFC running...

Database Integrity Check jobs running for ever in Sql 2012

By pdsqsql

We have Database Integrity Check jobs running every early morning during off hours into...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Auto Rounding

See possible answers