Hosted on MSN

Busy Server Forgot About A Table For Hours, But The Customers Ended Up Turning Her Worst Mistake Into The Sweetest Memory

Weekend rushes at restaurants can get so hectic that even the best servers lose track of time. One server thought she was handling it well, until she noticed an older couple who she had accidentally ...
GitHub

Syntax highlighting in SQL Editor stops working after use of function (e.g. PIVOT)

I’ve encountered an issue in the SQL Editor where syntax highlighting stops working for all subsequent code when using certain functions, such as PIVOT. Below is an example illustrating the problem: ...
asaporg

Excel Pivot Tables Made Easy

When you analyze data in large Excel worksheets, does it feel like you are looking for a needle in a haystack? If you answered yes, you’ll probably benefit from PivotTables. PivotTables make data ...
GitHub

Calculating Pivot tables

ExcelPivotTable.Calculate(refresh) Calculates the pivot table. Parameter 0 - if true the cache will be refreshed before calculating. If false the existing cache will be used. If no cache exists the ...
IEEE

How tax audit and tax advisory can benefit from big data analytics tools data analysis and processing in relational databases using SQL Server and Power Pivot & Power View in Excel

Abstract: In the context of business analytics, the tax consultants and auditors face challenges when conducting data analysis for tax optimization based on big commercial databases extracted from the ...
Microsoft

Content type: Best Practices

With the In-Memory OLTP feature in SQL Server 2014 we introduce two new types of indexes for memory-optimized tables: the memory-optimized NONCLUSTERED indexes, and the memory-optimized HASH indexes.
Ars Technica

T-SQL: Pivot help

CheckListItems CheckListItemId ItemName 1 name1 2 name2 3 name3 4 name4 5 name5 ... I can't seem to get the PIVOT syntax correct- it has to be dynamic as I don't know all the ItemNames (and there ...