drew.allen (8/17/2015)

---

Eirikur Eiriksson (8/14/2015)

---

drew.allen (8/14/2015)

---

Eirikur Eiriksson (8/14/2015)

---

Further, I was only stating that with a properly written XQuery, using the text() function is much quicker, I was not commenting or comparing...

Eirikur Eiriksson (8/14/2015)

---

Alan.B (8/13/2015)

---

drew.allen (8/13/2015)

---

Alan.B (8/13/2015)

---

Just to add to Drew's excellent solution, not only would you want to use the value() method over the query method here, you should include...

Jeff Moden (8/14/2015)

---

Alan.B (8/14/2015)

---

BobAtDBS (8/14/2015)

---

I have read Jeff's article, both in the past and an hour ago. His examples aren't things we do at the TSQL level very often....

BobAtDBS (8/14/2015)

---

I have read Jeff's article, both in the past and an hour ago. His examples aren't things we do at the TSQL level very often. I'm wondering...

g.britton (8/14/2015)

---

I just wish it wasn't called a "Tally" table. I don't tally things, I count them. fwiw I usually call my "tally" table "N" to reflect it's relation...

drew.allen (8/13/2015)

---

Alan.B (8/13/2015)

---

Just to add to Drew's excellent solution, not only would you want to use the value() method over the query method here, you should include the text() node...

Take a look at:

http://basitaalishan.com/2014/01/22/get-sql-server-physical-cores-physical-and-virtual-cpus-and-processor-type-information-using-t-sql-script/%5B/url%5D

Charmer (8/13/2015)

---

Hi Friends,

I am trying to collect the metadata of a package in SSIS. What are the securities are needed to collect a metadata of a package?

since I am testing...

Just to add to Drew's excellent solution, not only would you want to use the value() method over the query method here, you should include the text() node in your...

Great article Luis! 5 Stars sir! I just finished reading it again and it's an excellent article; I can't wait to see more (you are going to write more articles...

Also called a numbers table. In addition to the links you posted, Itzek Ben-Gan has writes about numbers tables in his books and articles.

Jeff Moden once said in...

PJ_SQL (7/29/2015)

---

Hi,

I have this script, it is taking long time to execute, what can I do to make it execute faster?

DECLARE @c varchar(10)

SET @c = '%A1%'

select *

from...

Duplicate post - please direct all answers here.

If the reports are being developed using visual studio I would keep a copy of the solution/project and, yes, it would be a good idea to backup the reportserverdb. I...

I expect...