I know, the XML stuff looks weird compared to what we're used to... 😉

OPENROWSET is a lot closer...

DECLARE @xml xml

SET @xml =(

SELECT * FROM OPENROWSET(

BULK 'C:\YourFolder\YourFileName',

...

Something like this?

SELECT

c.value('@NAME[1]','varchar(50)') AS a,

c.value('@OPTIONS[1]','varchar(10)') AS b,

c.value('DESCRIPTION[1]','varchar(50)') AS c,

c.query('SHEET'),

c.query('RECIPIENT')

FROM @xml.nodes('FORM') T(c)

From my point of view there is no issue regarding Service Broker security.

The security hole is your SELECT permission on the target table. The only difference between a scheduled job...

[Disclaimer ON] I'm not a guru. [Disclaimer OFF]

Based on my experience OpenXML is nothing special being the root cause of a deadlock compared to any other method of dealing with...

Steve Jones - Editor (9/27/2010)

---

I do it as Lowell does it, email to the SMS number for the person.

One thing to note, SMS is guaranteed. And might not be delivered,...

I focused on the execution plan of the view:

Since there is no index for the trip table starting with create_date you end up with an index scan that fits best...

I don't think killing processes is the right approach here or in most other scenarios.

What processes do you usually kill and what status those are at?

You should run profiler to...

If you're talking about sending an email using SQL Server you might want to look up sp_send_dbmail in BOL.

If your system is not configured yet to send mails, you should...

Ouch!! You'd better stop that query....

I was hoping to prea-aggregate AdvStats and reduce the size of that part of your query.

But, unfortunately, it seems like it won't help at all...

As per ISO, week of August 9th 2010 is week 32.

Ther definitely is a difference:

The "old-fashioned" week function will calculate the weeks starting with week 1 for the...

I added the top level name as an addtl. column (Level1Name) and moved the calculation to the final select (therewith removing the cte1 subquery).

;WITH cte

AS

(

SELECT id,Name,parentid,levelid,...

Ugghhh!!! Those are quite heavy tables...

I think the major issue is the join between the 500 mill table to the 50mill table and performing an aggregation afterwards.

The CROSS JOIN is...

Lowell (9/25/2010)

---

inm ot a network guy, but maybe you can configure the server so only certain machines/ip ranges can access the ports for the sql server?

i think you can do...

Lowell (9/25/2010)

---

there is a built in function PARSENAME that can help do this, but it only will help if your data has three periods in it.

the function is usually used...