Press Release


Technical Article

SQL Monitor Custom Metric: Memory Used By Ad Hoc Queries Running Once

This metric measures the amount of memory used by the total number of ad-hoc queries that are currently in the plan cache. If the value is high, it indicates memory is being wasted by storing the execution plans of queries that will never be run more than one time.

You rated this post out of 5. Change rating

2015-06-25

2,334 reads

Technical Article

Take our SQLServerCentral Users Survey

Each year SQLServerCentral runs a survey to get some insight into what who our readers are, what they like about the site, and what can be improved. Please take a few minutes to complete this survey by June 12 and get the opportunity to win one of three $50 Amazon vouchers.

You rated this post out of 5. Change rating

2015-06-02 (first published: )

13,214 reads

External Article

Database Continuous Integration Workshop - London, UK

Join this workshop on July 8, 2015 to learn how to: link your source control repository to a build system, trigger database builds automatically when you make a change, use DLM tools to test your database changes, and lay the foundations for package-based deployment of your database. Register while space is available.

2015-05-22

6,320 reads

Blogs

When the Internet Stumbles: Lessons from Cloudflare & Azure Front Door Outages

By

Recently, the world was reminded of just how fragile the internet can be.  Two...

Prepping for Certification, Part 4 of 4

By

In Parts 1-3, I covered how I prepare for a certification exam. In this...

Flyway Tips: Automation Assistance in Flyway Desktop

By

I was chatting with the product managers at Flyway and one asked me whether...

Read the latest Blogs

Forums

CAST datetimeoffset(7) as a datetime in UK format

By tylerschuler75

I have a view where I am casting a datetimeoffset(7) field to smalldatetime or...

what are the downsides of TDE not running vs running?

By stan

hi for the 2 years i've been here I believe we've had "encryption" turned...

Help! MEMORY_ALLOCATION_EXT wait stalls

By krypto69

Hi I have an overnight process that moves allot of claims records Been working...

Visit the forum

Question of the Day

Putting the Player with the Number

In SQL Server 2025, what does this return?

DECLARE @player varchar(20) = 'Bo Nix',
@num VARCHAR = '10'

SELECT @player || @num

See possible answers