Sean - I am interested in why you say that COUNT(*) is the only way to get a row count. I'm not disagreeing with you - just curious looking for...

Could you perhaps include a little DDL, sample data and an example of expected output?

Have you tried http://<your actual server name>/Reports ? I think I have seen this in the past and, for some reason, localhost was not working.

Thank you Grant and Jeff!

I don't fully understand what you are trying to do but the splitter referenced in my signature line is the best way to split a string. This should get you...

This is a loaded topic. A few thoughts....

Get your disk configuration right. It's nice to split up your IO between different physical disks; such as:

C: OS Files

D: Program File/SQL Install

E:...

I have run into this before too. Note this thread on stackoverflow: RAISERROR issue since migration to SQL Server 2012

Below are a couple functions that I am working on that will get you the queries that are creating the most CPU pressure and IO pressure.

These are based on...

This does fall into the category of Log Backups which Grant mentioned..

I would expand it to Log File maintenance. This includes changing the recovery model to Simple for Databases...

Excellent article. 5 stars from me. I have not seen an article that discusses the new 2014 Cardinality Estimator in such detail. Well done sir!

Thanks!

I actually had a few moments to kill and optimized that query further; this will be much, much faster, uses less code and creates a simplified query plan...

DECLARE @xml...

Alan.B (4/8/2015)

---

pawan.clong10 (4/8/2015)

---

HI Alan Thanks for that quick help.

i really appreciated. well, i am actually able to retrieve the data

However, the data is coming with the same token Names for...

pawan.clong10 (4/8/2015)

---

HI Alan Thanks for that quick help.

i really appreciated. well, i am actually able to retrieve the data

However, the data is coming with the same token Names for all...

😎

Ok, never mind the DDL; From your XML that you posted I have a temp variable to mimic what you have.

We'll use this sample data:

DECLARE @xml xml =

'<?xml version="1.0"...