The reality is the DB Tuner is not always perfect, in fact in complex situations it may be wrong. Performance tuning cannot be done in a vaccum, while looking...

Even though the RS databases do failover with the SQL Server service, the Reporting Services service is not cluster aware. So, you would have to install Reporting Services on...

You should create the SPN for the service account. You can use adsiedit for viewing the properties of the account and viewing the SPN.

If it's using Kerberos vs NTLM then it's working correctly.

That is certainly odd, and when you close SSMS and reopen it, it still fails? If so, I would be reinstalling the client tools myself. Is this true...

The query at the end of this article should help you.

http://www.sqlservercentral.com/articles/Security/65169/

Are you connecting both ways using the same login or NT login credentials?

View Any Definition permissions?

You may also use bcp, OPENQUERY, OPENROWSET, along with SSIS. There are a ton of ways to dump data out of a table into a flat file / excel.

The addtion of a column by itself will be very quick. However, if you are creating it as NOT NULL and adding a DEFAULT constraint or something like this,...

I had this same problem, and rather than renaming a sheet in Excel, I had to implement a bit of a workaround using the Document Map and then the Misc...

Visual Studio 2008 Database Edition

Look up the PIVOT operator in Books Online, I think that should do the trick for you.

Sure, you can use Profiler to trace all / some of the database traffic. Looking initially at profiler events RPC:Completed, and SQL:BatchCompleted, read some docs about profiler (google...

Yep, mixing DDL with DML in stored procedures is a sure-fire way to get a re-compile. Best practices mentioned grouping all DDL (like your Create table statement for the...