Quick question, do you have any sample data to...

farooq_inlondon (7/18/2016)

---

Hi All,

I had database with ndf files in 5 filegroups, the big tables is partitioned and data is there in these files.

I dropped the database but mdf, ndf and...

Quick question, any MSDTC transactions?

😎

Further on John's reply, we need the table structures, the query and the actual execution plan, without the information it's only wild guesses.

😎

dhb (7/17/2016)

---

I have a very simple SSIS package I created in VS2015 whose first step is a FileSystem task to rename a file. It executes fine in debug mode. I...

wendy elizabeth (7/17/2016)

---

What other sql options are you thinking that would work?

I did not include all my question since I was trying to determine what was wrong with my original...

Quick thought,...

Yes indeed and often overlooked.

The difference is quite large, without the text() function, each value method results in three XML function calls, sort, joins etc., 15 operators in...

Slight difference in the query but huge in performance by using the text() function

😎

;WITH XML_CONVERT AS

(

SELECT

XN.XN_ID

...

Quick thoughts, change the old style ANSI joins to normal joins, move any join conditions from the where clause to the joins and then check for any remaining LEFT table...

Quick thoughts, looks like corruption in sys.sysobjvalues (object_id 60) and then some

Table error: Object ID 563604212, index ID 2, partition ID 72057664724140032, alloc unit ID 72057664734167040 (type In-row data). Page...

You are very welcome.

😎

Quick suggestion

😎

SELECT ids.DataSet.value('(./text())[1]','INT') AS ID

FROM @IDs.nodes('/IDs/ID') AS ids(DataSet)

Phil Parkin (7/14/2016)

---

Ray K (7/14/2016)

---

I once had a...

ThomasRushton (7/14/2016)

---

Brandie Tarvin (7/14/2016)

---

ThomasRushton (7/14/2016)

---

Isn't that the time...