Further on the discussion, here is a small test sample

😎

USE msdb;

GO

SET NOCOUNT ON;

DECLARE @TXML XML = (

SELECT --TOP 200

*

FROM sys.tables ST

INNER JOIN...

SQLRNNR (7/13/2015)

---

Mikael Eriksson SE (7/13/2015)

---

I guess this is the preferred form.

SELECT

col.value('(Title/text())[1]', 'varchar(50)') AS 'Book'

FROM @x.nodes('/root/Books/Book') a(col)

Using text() in the values clause removes one call to...

Jeff Moden (7/13/2015)

---

The correct answer isn't actually available. The correct answer should be to "hunt down the moroff that used XML to transmit purely flat data and introduce him...

Will work but it's far more expensive to traverse the structure than to do a direct reference.

😎

rahmanagg (7/13/2015)

---

Hi All,

I'm working on a project comparing the performance of SQL and NoSQL database (MongoDb). I'm focusing on "insert, select, delete and update operations. I am trying to...

Suggest you...

GilaMonster (7/13/2015)

---

M.Sc...

Too increase the OS memory, change the max memory settings.

😎

giri10488 (7/13/2015)

---

I have an issue with a server memory. SQL server is allocated 32 Gb out of 40 GB memory and sql server is using all the memory which is...

jackfh (7/12/2015)

---

Unfortunately, that didn't show me anything I could work with. I can't see the password. I have a domain account running services. I reset the PW...

jackfh (7/12/2015)

---

We had a password changed on the sa account and, upon reboot, the MSSQLSERVER service stopped working and gives a login error when attempting to start it. ...

Quick suggestion, use union all and order on the two id columns, here is an example

😎

USE Test;

GO

SET NOCOUNT ON;

;WITH BASE_DATA AS

(

SELECT

BT.BookID

,0 AS TitleID

...

Jeff Moden (7/11/2015)

---

Can't speak to that for sure but I believe I have the worst example of them all. My sweetie talks to me and I still can't figure...

Williams

Luis Cazares (7/10/2015)

---

It's more an optic illusion,...