That almost sounds like a permissions issue on the script location. Just for an experiment, try placing it in the SQL Server \bin directory and see if you can execute...

You have to have the sqlps module if you're running this from standard PowerShell. Here's the topic on MSDN. I know you're calling it from SQL Server, but because you're...

jacksonandrew321 (11/25/2014)

GilaMonster (11/25/2014)

Considering that the article is completely wrong about index structure, I'd recommend not reading it.

Indexes are not binary...

In addition to just too much data, you can see this if you have extremely complex queries such as views that call views that join to views, etc.

Short answer, whatever...

The clustered index is the table. That's why it's a good idea to usually put the clustered index on the most often used path to the data. This is usually,...

And if you're on a 2008 server, consider using extended events to gather data instead of trace. It has better filtering and a reduced footprint.

And make sure you do some test restores to ensure you can get your database back and that you know how to use the log backups that you're taking.

Just make sure you set the maximum memory size within the SQL Server instance and then, as stated, let SQL Server do the memory management for you. For your memory...

What is it that you're trying to do?

You can, but it's not at all the same partitioning mechanisms available in the earthed product. Here's some sample code on how to set it up from Microsoft. Here's a...

You could probably pay Gartner or one of their equivalents. I've no doubt they have that sort of information available. But I'm not aware of it being published anywhere.

Effectively, the use of an index in the ON clause is the same as the use of an index in the WHERE clause. The criteria can act as a filter...

And compare execution times and reads.

But I would suspect they'll resolve out to the same plan during the simplification phase.

Glad to hear you worked it out, and thanks for posting the answer too. Now when someone who has the same problem does a search, they'll know what the solution...

Red Gate tools (and that was for 11 years before I started to work for them). Other than that, paid tools kind of depends on what you're doing. Monitoring, I'd...