Assuming your row estimates are vaguely accurate and you're selecting 821 million rows without any predicates (WHERE clause), sorting it twice (once for row_number and once for the order by...

EdVassie (4/9/2014)

---

Our discussions with Microsoft and its license resellers have shown that the following is accepted:

If you set processor affinity to match the number of cores you have licensed, then...

Gazareth (4/9/2014)

---

andrew gothard (4/9/2014)

---

Gazareth (4/9/2014)

---

Assuming it's 4 octocore processors, take out 2 of them.

Edit: Sorry, that's a bit abrupt but it's the quickest way I can think of 🙂

Alternatively create...

To do this properly, I'd be looking at paying for specialist address cleansing software (QAS or PostcodeAnywhere are the two I've used in the UK), which have built up quite...

I think this misses the point of in-memory optimisation. A read query, like a count, especially on a 1TB RAM server is going to be entirely fulfilled from buffer cache...

Normally the @[User::FileName] variable would be set by the for each loop as it iterates around files.

What I was asking is are there any expressions set in the properties...

Is the value set from an expression? E.g. it's re-evaluating the expression when you re-open it?

There's no FOR EACH ROW syntax in SQL Server triggers. What you have instead are two tables called inserted and deleted that contain ALL rows affected by the transaction. Something...

If you just want a decent searchable index, you could always just link Outlook to a Gmail account and drag the PST folders in:

http://www.theatlantic.com/technology/archive/2010/01/moving-pst-files-into-gmail-you-can-try-this-at-home/34209/

I don't believe there is a 64 bit JET driver for Excel.

You need to run the package in the 32 bit runtime. In Visual Studio, this is done through...

1024 is a very large value for BUFFERCOUNT, isn't it?

Any reason you've set this rather than not specify it (I think it's automatically tuned based on the number of...

Unless you've changed the default file type options for the search indexer, it would only index the properties of the file (assuming it's an indexed location), which is trivial in...

So, you're just looking at a way to automate the download of the csv from that link every 15 minutes?

StreamInsight sounds a little extreme. SSIS would be my weapon...

Are you sure the initial query is what you want? The distinct isn't necessary if the query is changed.

Not sure why you're cross joining sys.databases (all databases) to INFORMATION_SCHEMA.COLUMNS...

Just played around with it myself (don't usually use the GUI very often) and it's pretty misleading.

By default, when selecting a backup file that has the same DB name...