Welcome to the first article of the weekly #thresqlips series comprising of three sql tips, definitions or “must-know”‘s that should be part of your database development vocabulary: Continue reading #Thresqlips series Metadata, XML & Text files – Episode 1
Tag Archives: #sqlserver
DATA sizing or SQL Server Rowcount without doing a table scan
Scenario Proposal
While working on different database projects I usually find it very necessary to perform a data sizing exercise on all tables focusing mostly on the number of rows in order to determine a growth factor of each table. This kind of information is useful in performing long term planning of growth and scalability of the data that we are managing.
Out of an exercise like this one we can also determine future needs for data archiving.
Continue reading DATA sizing or SQL Server Rowcount without doing a table scan
Sql Server 2014 a game changer – Part 1
There are 3 factors that can transform Microsoft Sql Server 2014 into a real game changer and I'll go through each of them in brief details below :
1. Mission-Critical Performance