Here is a quick solution that should get you passed this hurdle

😎

Note that it is around 4 times more efficient than the code you posted

USE TEEST;

GO

SET NOCOUNT ON;

DECLARE @TXML TABLE...

rodjkidd (11/29/2016)

---

Eirikur Eiriksson (11/24/2016)

---

Gazareth (11/24/2016)

---

Eirikur Eiriksson (11/24/2016)

---

Gazareth (11/24/2016)

---

BWFC (11/24/2016)

---

ThomasRushton (11/24/2016)

---

BLOB EATER (11/24/2016)

---

GilaMonster (11/24/2016)

---

The office kitchen also caters to stranger tastes, with 3...

HappyGeek (11/29/2016)

---

Many thanks for the prompt responses, but just to clarify:

I am looking at tempdb, it has 8 data files plus the log. the mdf file has initial size of...

trhorner (11/29/2016)

---

I am putting together a "recovery" plan if hardware fails, and since the business allows 120 minute recovery window,

I plan to do full and log backup restores of...

Quick questions, what is the IO subsystem setup? Are those tempdb files set up on different IO paths? What are the top tempdb waits (sys.dm_exec_request / sys.dm_os_waiting_task)? Are there more...

Sqlsavy (11/29/2016)

---

Is it possible to estimate database capacity based on following details?

Volume of records held in the database- 18000000

Volume of updates per day thru overnight batch- 50k

Database growth expected to...

GilaMonster (11/28/2016)

---

I have...

What are the business / reporting requirements?...

Chad Crawford (11/28/2016)

---

Eirikur Eiriksson (11/24/2016)

Unfortunately, I've found the English coffee culture being almost no better than the American, totally inadequate, must say that it's not my cup of tea....

S_Kumar_S (11/28/2016)

---

Hi

We have a scenario, where busniess users are presented with a screen with 20+ fields. They can choose any number of fileds to build a dynamic SQL query in...

Can you please check your IO subsystems log files, Windows Event Logs and any other applicable log files for error entries!

😎

Further, run...

What do you see in the SQL Server Error Log?

😎

EXEC sp_readerrorlog;

Two examples, one using Pivot and the other using CrossTab

😎

Pivot

USE TEEST;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA(Site_ID,Name,Address,City,Postal,Type) AS

( SELECT X.Site_ID,X.Name,X.Address,X.City,Postal,X.Type

FROM (VALUES

(12345,'John','123...

rajemessage 14195 (11/27/2016)

---

hi,

i use loops sparigly , but when ever i use them , i see following pionts like

1) i am reading same table mulitpule times...

Quick question, what is last_wait_type in sys.dm_exec_requests showing for the spid?

😎