Phil Parkin (3/14/2016)

---

yb751 (3/14/2016)

---

I started working with the hierarchyID data type. So far it's been pretty great working with the built-in functions rather than having to use recursive CTE's....

Provided you have permission to the remote folder (check your logs); what file extension did you specify? It needs to match the files you intend to delete. Also...

Just to illustrate...

USE [AdventureWorks2012]

--Using IN

SELECT

*

FROM

[Production].[ProductInventory]

WHERE

LocationID IN (1, 6, 50)

--Using a Join

DECLARE @test-2 TABLE (LocationID INT)

INSERT INTO @test-2

VALUES (1), (6), (50)

SELECT

p.*

FROM

[Production].[ProductInventory] p

JOIN @test-2...

You're welcome!

Just need to tweak your logic...

DECLARE @myTable TABLE (ID INT, Cost1 NUMERIC(4,2), Cost2 NUMERIC(4,2), Cost3 NUMERIC(4,2), Cost4 NUMERIC(4,2))

INSERT INTO @myTable

VALUES (1122, 14.00, 0.00, 50.00, 25.00), (1133, 75.00, 32.00, 1.00, 0.00),...

Why have I waited so long to start using snippets? :pinch:

It was probably the part that said 'Create an XML...' and I stopped there and said screw that. In...

Ok, that made me laugh. :hehe:

That being said I would not recommend it in that case.

You got yourself into trouble because your table isn't normalized. This is just a bad way of storing data. Now assuming you had a unique ID per person...

Is it a wide table? If not you could try including all columns on your non-clustered index. This would avoid key lookups and act similar to a clustered...

This is not an answer to your question but that doesn't mean I'm not trying to help. Consider the code below. This is an example on how to...

Almost got this one wrong, until I remembered COUNT(*) includes NULLs.

Good reminder!

It's also worth noting that using SET vs SELECT when assigning a variable will work similarly but have important differences.

Here is some code to illustrate:

--Declare a simple table and add...

souLTower (3/3/2016)

---

Yes, the index supports the query. Unfortunately the example is too far in the weeds to send an execution plan. It's just a curiosity.

On a related note,...

If you truly want to understand indexes this is an excellent read. http://www.sqlservercentral.com/stairway/72399/

A CXPACKET wait is basically waiting on a parallel thread(s) to finish. In of itself it isn't that concerning.

Try this...

SELECT * FROM sys.dm_exec_requests WHERE session_id = your spid here

One of...