Make no mistake, I will performance test it when I get access to a SQL 2022 instance. To me, it's not worth installing Dev Edition on my own...

Jeff, from a performance perspective, would you prefer to...

colin.counsell (5/23/2012)

---

Hi

I added code to the sp last night set ARITHABORT and QUOTED_IDENTIFIER.

It has just finished after 3 hours 10 mins!

It ran in 50 mins on the old server and...

Tac11 (4/28/2015)

---

when I run your query on my laptop getting this error:

Msg 9436, Level 16, State 1, Line 7

XML parsing: line 5, character 15, end tag does not match start...

They're coming from a DMV (Dynamic Management View) so you cannot delete them, per se. All DMVs retain their data until either the...

m60freeman (6/11/2014)

---

When I execute the SQL posted by Grasshopper that starts with:

in a Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) instance, I...

@shahgols: The Deadlock Graph visualizer in SSMS expects XDL (XML Deadlock List) files as output from SQL Profiler using the following technique: How to save deadlock graph events...

hello mahesh (9/17/2012)

---

We had couple of deadlock issues,

but nothing is captured with this query..

select XEventData.XEvent.value('(data/value)[1]', 'varchar(max)') as DeadlockGraph

FROM

(select CAST(target_data as xml) as TargetData

from sys.dm_xe_session_targets st

join sys.dm_xe_sessions s on s.address =...

Something else I wanted to add although this an ongoing issue, not new to SSRS 2008 R2...

I've always found it disappointing/annoying/frustrating that for report images, and charts in particular, you...

Lisa Slater Nicholls (9/6/2011)

---

One problem is that the "scheduled delivery" interface is the simple "one size fits all" version, and almost everybody who needs more than this needs something...

peterw 85974 (9/6/2011)

---

Admittedly the SQL Server team is a rather closed and uncommunicative shop. I can't get so much as a "thankyou for your bug report, it has been queued...

Hey Andy,

Great article, but finished up with:

Are you...

This is still an issue in SSRS 2008 and 2008 R2. We hit this today and, in the interests of not breaking Reporting Services whilst still preserving the sanity of...

Hi Jeff,

Using NEWID() as you have is a better way to get random data out of SQL if you don't want repeatability, but getting repeatable random-ish data out of this...

I just thought I'd share a head-smacking moment with you. It's been touched-on previously in this thread, but I don't think anyone's come right out and demonstrated it.

What happened?

This one...