If you work with SQL, you understand the importance of being able to monitor your queries, not to mention how critical it is to have an accurate analysis of how long queries take. Today, we’ll take a look at SQL Server Profiler, a tool for doing just that, how it works, some shortcomings (most notably, depreciation of its features), and …
How to Partition SQL Server Tables and Truncate Partitions
There are many reasons why Partitioned Tables in SQL Server can be useful. In this post we’re going to focus on just one: deleting large quantities of rows from a tall and narrow SQL table without burninating your Log IO. Burninating your Log IO you say? Pssshh, Azure SQL can handle this if you work your TSQL like the late …
SQL Azure Elastic Pool – Product Review
At Stackify, we have about 1,000 SQL Azure databases. Monitoring, managing, and right sizing these databases creates a unique set of challenges. For security and scalability, each of our clients has their own database. As you can imagine, each client is in a different sizes and we have wildly different performance characteristics from one databases to another. We are excited …