Initial reaction to any CXPacket problem on a global scale is that it's not the CXPacket's fault. Something is delaying one of the parallelism threads and that's the real...

LOL, fair enough. There's possibly a couple of people around here who could give...

Can you expand on what you're looking for a little bit?

File storage is usually done in VARBINARY(MAX). Under most scenarios the front end should be delivering/retrieving these files, not...

Yeah, it's not horribly uncommon. An example of when I usually use it:

SUM( CASE WHEN x=y THEN 1 ELSE 0 END) AS FilteredCount

What kind of performance difference are you...

Quit? No. I use those downtimes to self-train, explore for new...

Got family all over NY/NJ. Still trying to reach one of them, though I know the power was going down so my guess is her cell simply perma-died. ...

Don't feel bad. I've been working with it off and on for the last 2-3 years and...

No.

For starters, you want to go here:

http://msdn.microsoft.com/en-us/library/ms188783(v=sql.105).aspx

In particular:

Up to 16 columns can be combined into a single composite index key. All the columns in a composite index key must be...

ChrisM@home (10/28/2012)

---

This has already been answered but it's interesting that the logical requirement exactly matches an existing function which isn't used in any of the solutions offered. What you're looking...

Partitioning, in general, is an administrative tool and not a development or optimization tool. While you do need to make sure your partitioning is included in optimization of existing...

I did a bit of testing on this a while ago, and could probably recreate the scenarios, but here's where I ended up.

SELECT INTO #tmp

and

CREATE TABLE #Tmp INSERT...

I was recently assaulted in a dark alley by some Ransomware, Tom, so I feel your pain. It took me a few bouts of safe mode and random timing...

Email sent. Thanks for looking at this for me Andy.

bkatoch (10/30/2012)

---

The end result of this task is to track inventory movements by quarter. I realize my approach to this task is not very efficient but it's the only way...

Checked the XML on the source file. First I removed the data source entirely (though two of my other configurations are relying on it) and checked the XML.

I can...