It might be, depending on the queries.

It might as well not. Typically you want your clustered index to be unique (selective) and narrow.

What kind of performance issues do you have?

Nice question, thanks.

It's not spam 🙂

It popped up on the "Recent Posts" view and I was just curious 😀

Which version of SSIS are you using?

I think it works... 😉

You can also use the debugger functionality of SSMS to step through the stored procedure to see on which line it exactly fails.

Luis Cazares (11/3/2014)

---

Express will have limited functionality.

Evaluation and Developer will offer the same features as Enterprise edition. The problem with Evaluation would be the time constraint.

How much can you learn...

Security issues aside, it is not possible to have SQL Authentication only.

You can however only add SQL logins and remove or disable windows logins.

It's hard to say without taking a look at the actual code.

Server Memory Server Configuration Options

VS 2010 --> SQL Server 2012

VS 2012 --> SQL Server 2012

VS 2013 --> SQL Server 2014

Great question and nice alternative way to write an OR.

Nice trick question. 🙂

Can you post a screenshot?

I think you can also schedule a job on another server and use SSIS to send an XMLA Backup command.