August, 2014

Featured

| |

|

No blog posts have yet been created.

| |

|

Having performance issues with table variables? SQL Server 2012 SP2 can help!

Posted 4 months ago

by SQL Server Support Content
In a previous blog , I talked about how table variable can impact performance of your query. The reason is that the statements referencing the table variable are compiled when the table variable has no data in it. Therefore, cardinality estimate for the...
VSS backup of AlwaysOn Secondaries

Posted 4 months ago

by SQL Server Support Content
Hi Everyone, Today I’m going to highlight one of the changes brought by SQL Server 2012 SP2 , which is the way we handle VSS Backup requests on AlwaysOn Secondary Databases . Until now, any request for a FULL database backup (VSS_BT_FULL) thru VSS against...
Power View in Excel won’t render from SharePoint

Posted 4 months ago

by SQL Server Support Content
I originally encountered this issue back in May with a customer. We had another customer this month that had the same issue. When you try to load an Excel Document with a Power View Report in it from SharePoint, you may encounter the default...
SQL Server 2014 Setup Error: 'BIDS' is not a valid value for setting 'FEATURES'

Posted 4 months ago

by SQL Server Support Content
SQL Server Data Tools (a.k.a. SSDT) used to part of product installation media in SQL Server 2012. We can install it by selecting "SQL Server Data Tools" from shared features section. Alternately we can install it using SQL Server 2012 setup...