Press Release


Technical Article

SQL Monitor 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 in the plan cache that have only run one time. This value is only accurate for the instant the query is run, and the value can change radically from one capture time to the next.

You rated this post out of 5. Change rating

2014-07-14

9,595 reads

Technical Article

Agile 2014, Florida

Agile Alliance is holding a conference July 28 - August 1 in Orlando, Florida. If you're interested in Agile development, whether your initiative is mature or brand new, enterprise-wide or team-centric, you will find the finest knowledge, resources and people at Agile2014. This conference is for Teams, Developers, Managers and Executives. Register while space is available.

You rated this post out of 5. Change rating

2014-07-10

2,549 reads

Technical Article

SQL Bits - Telford, UK

SQL Bits is only two weeks away! Join us for the free community day on July 19th, there is also a paid-for pre-conference day on July 17, as well as a paid-for special training day on July 18. There are a whole host of great speakers, including Grant Fritchey, Steve Jones, and David Atkinson (and Brent Ozar, and Benjamin Nevarez, and Karen Lopez...you get the idea). Register while space is available.

You rated this post out of 5. Change rating

2014-07-03

5,147 reads

Technical Article

SQLSaturday # 286 - Louisville, KY

Join SQL Server MVP Grant Fritchey and other SQL Server professionals for a free day of training and networking at SQL Saturday Louisville, June 21. This is a free event, however there are also two paid-for precons available, run by Grant Fritchey and David Fackler. Register for SQL Sat while space is available.

2014-06-04

1,577 reads

Technical Article

SQL Saturday #294 - Philadelphia

SQL Saturday is coming to Philadelphia on June 7, 2014. This event is a free day of training and networking for SQL Server Professionals, organized by the Philadelphia SQL Server User Group. The event also features two paid-for Precons, one presented by Allan Hirt and the other presented jointly by Joseph D'Antoni and Stacia Misner. Register while space is available.

2014-05-23

1,877 reads

Blogs

Performance tuning KubeVirt for SQL Server

By

Following on from my last post about Getting Started With KubeVirt & SQL Server,...

T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future

By

I haven’t posted in a while (well, not here at least since I’ve been...

Keeping MS Docs Up to Date

By

One of the things that I like about the SQL Server docs (MS Learn...

Read the latest Blogs

Forums

Change Tracking – Troubleshooting

By Phil Parkin

I have change tracking configured in several databases, in QA and production environments, and...

is there a no code way to limit an ssis extract from excel to the 1st 21 rows?

By stan

is there a no code way to limit an ssis extract from excel to...

Pivot but preserve all rows on Aggregate column

By getsaby

Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...

Visit the forum

Question of the Day

What is the PRODUCT

In SQL Server 2025, what does this return?

CREATE TABLE Numbers
( n INT)
GO
INSERT dbo.Numbers
(
n
)
VALUES
(1), (2), (3)
GO
SELECT PRODUCT(n)
FROM dbo.Numbers

See possible answers