Tag Archive


accdb repair access recovery access repair Contacts Data Backup Database Data Loss Data Recovery Excel corruption excel recovery Excel tips Excel VBA Hard Drive mdb repair mdf recovery MDF repair Ms Access outlook outlook contacts Outlook Email outlook recovery Outlook repair outlook VBA PST corruption pst recovery pst repair Quick Access Toolbar recover access recover excel recover outlook recover PST recover sql Registry Editor repair access repair excel repair outlook repair pst ScanPST SQL recovery SQL Server sql server recovery VBA View Settings Word Macro word tips

Understanding Adaptive Query Processing Mechanism in SQL Server

Learn about the Adaptive Query Processing Mechanism, and what all it includes. The Query Optimization feature in SQL Server works pretty well for deciding which execution plan will work best for any given query. It not only selects the cheapest plan, but also takes into account rows in a table. However, using the query optimizer […]

Learn about Waterfall Charts and Power BI Funnels in SQL Server

The article will stuff your brain with the concepts of Waterfall Charts and Power BI Funnels in SQL Server Aren’t waterfalls awesome? But you know what beats them! Waterfall charts in SQL Server and Power BI Funnels! What are waterfall charts? Why do we use Power BI Funnels? What all we can do with these […]

How to Create Basic Index for your Stack Overflow Public Database

In this article we learn about the basic differences in clustered and nonclustered indexes, and how and why you should use nonclustered, basic indexes for stack overflow public databases Stack Overflow Public databases are those which have clustered indexes for all tables. It does not allow for nonclustered or full text databases, and does not […]