Cross post from https://blogs.msdn.microsoft.com/sql_server_team/boosting-update-statistics-performance-with-sql-2014-sp1cu6/ With SQL 2005 end of life, many customers are planning their upgrades to SQL 2014. One of the recommended post upgrade tasks is updating the statistics of all the tables and databases in latest compatibility level. The updated statistics ensures the new optimizer in the latest release has most up to…
Recently we encountered and filed a benign reporting BUG which reports the maxsize of the data file incorrectly. If you create a database & then alter the initial size of the database to be greater than maxsize & then query sys.database_files, sys.master_files, sysaltfiles the maxsize appears to be incorrectly reporting the older value of maxsize….
Until the introduction of Columnstore indexes, most DBAs didn’t care much about the creation of statistics on the indexed columns as the statistics are auto created on the indexed columns when the index is created. With Auto Create Statistics turned ON for the database, the optimizer will automatically trigger the creation of statistics when it…
If you read the title of this post & were wondering, What the hell is that ? , Trust me I have no clue how I made this up but I felt it would be an appropriate title when someone wants to perform data analysis on their fb data to understand how much active they…
I feel extremely excited to share the latest release of my book on SQL on Azure Succintly with Syncfusion publications which talks about the deployments of SQL Server to Azure. You can download the latest version of the ebook from the following link http://www.syncfusion.com/resources/techportal/details/ebooks/sqlazure In recent years, we have witnessed how information technology has contributed…
Consider the following scenario, you have a large fact table with non-clustered columnstore index. In SQL 2012, Columnstore index is not updatable hence at night when you load or purge the table, the first step would be to disable non-clustered columnstore index followed by insert/update/delete to the table and the final step would be to…
Couple of weeks back I released Powershell cmdlets for DocumentDB in Github (Further info on this can be found in my blog here). Today I merged & added Automatic Indexing & IndexingMode parameters to the Add-DocumentCollection Cmdlet to the project in the module. https://github.com/savjani/Azure-DocumentDB-Powershell-Cmdlets Azure DocumentDB collections are auto-indexed by default allowing the developers to…
Azure DocumentDB is Microsoft’s new budding NoSQL Schema Free database offering which is relatively a recent addition to the mammoth Microsoft Data Platform Stack. Azure DocumentDB provides great flexibility to the Developer world who feels a lot restricted with RDBMS data model, adhering to the data types, schema, index designs & patterns. Azure DocumentDB gives…
To start this blog post, let me first explain the problem. Consider a scenario where you receive an excel sheet or data in the following format Category SubCategory Bikes Mountain Bikes Road Bikes Touring Bikes Components Handlebars Bottom Brackets Brakes Chains Cranksets Derailleurs Forks Headsets Mountain Frames Pedals Road Frames Saddles Touring Frames Wheels Clothing…
Last week in of the SQL Community Forum, one of my friend asked the following question If I have 2 Tlog files for one database, how will these files fillup? A) File 1 will be filled first and then File 2 B) Both the files will be filled together. If B is true then how…