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...

Ekkert mal

😎

You are welcome

Yees

😎

Quick suggestion

😎

USE TEEST;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.Test') IS NOT NULL DROP TABLE dbo.Test;

CREATE TABLE [dbo].[Test](

[PK] [int] IDENTITY(1,1) NOT NULL,

[COLUMN1] [nvarchar](50) NOT NULL,

[COLUMN2] [nchar](10) NULL,

[COLUMN3] [nchar](10) NULL,

[COLUMN4] [nchar](10) NULL,

CONSTRAINT [PK_Test] PRIMARY...

torfi (7/13/2016)

---

Thanks for the advise put it didn't change anything. Now I created the index like this:

CREATE FULLTEXT INDEX ON MalBokunSkyrsla

( Skjalid TYPE COLUMN Filextension Language 1039) KEY...