I have used the filetable to store the tsql scripts. what can be the best way to run them against the server. the only road block i have using the...

joe.wolfe (10/11/2013)

---

Thank you for responding to my question and I apologize for taking so long to reply back. I had to have some emergency foot surgery.

I am in fact...

Keeping your indexes un-fragmented will help performance. That said, I...

Misread OP. Comment removed.:blush:

I know I am a little late here but this:

;with xmlnamespaces (default 'urn:vim25')

select t.c.value('(shares)[1]', 'varchar(200)')

from (table)

cross apply @xml.nodes('(/obj/cpuAllocation/shares, /obj/memoryAllocation/shares)') t(c)

is getting all...

Koen's query produces a better query plan than what I came up with. That said, this is a good example of how to use NTILE for this type of thing...

DECLARE...

You are describing the thing that SSIS was designed to do. I don't see anything wrong with that provided you are using SSIS according to a set of best security...

danka_6786978 (7/24/2013)

---

Hi, I am upgrading reports from 2005 to 2008R2 and I noticed that two reports are failing on the new server. So, after looking up its issue, I realized...

+1 Absolutely! I second your suggestion.

I'm going to take a quick stab at this since nobody has responded yet. What I am showing you here is not a complete solution but should get you moving...

This is a super-simple, but great overview of XML Namespaces

http://www.w3schools.com/xml/xml_namespaces.asp

This article is great for understanding why they exist.

http://msdn.microsoft.com/en-us/magazine/cc302166.aspx

The W3C formal definition (if you ever have problems falling asleep)

http://www.w3.org/TR/REC-xml-names/%5B/url%5D

Edit:...

You can also use PatternSplitCM (note the link in my signature)....

declare @val varchar(8000)= '[{mark,peters,mr}{jane,fonda,mrs}{john,doo,mr}{james,bond,mr}]';

WITH x AS

(

SELECT ItemNumber, Item

FROM dbo.PatternSplitCM(REPLACE(REPLACE(@val,'[{',''),'}]',''),'%[}{]%')

WHERE Matched=0

)

SELECTROW_NUMBER() OVER (ORDER BY x.ItemNumber) AS Id,

MAX(CASE WHEN ps.ItemNumber=1 THEN...

LutzM (10/7/2013)

---

Here's a slightly different approach without the OPENXML approach (I, personally, find OPENXML more complicted and it seems to be less efficient in most cases):

SELECT

TempXML1.Node1.value('(server/text())[1]', 'varchar(50)') AS [server],...

This is what you are looking for

EXEC sp_xml_preparedocument @dochandle OUTPUT, @xmldocument;

SELECT

server,

name,

start_time,

type,

log_name,

media_mount_date,

drive_name,

media_label,

media_guid,

media_overwrite_date,

media_append_date,

media_set_target

FROM OPENXML(@dochandle, 'joblog', 1)

WITH

(

server [varchar](20) 'header/server/text()',

name [varchar](300) 'header/name/text()',

start_time [varchar](100) 'header/start_time/text()',

type varchar(20) 'header/type/text()',

log_name...

You can include table names or derived tables in your from clause but not a non-static value. Dynamic SQL (using sp_executesql not EXEC) is the way to go for this.There...