As you might know, Microsoft has released on March 7 the RTM version of SQL Server 2012. If you are an MSDN or TechNet Subscriber, you can already download it and play with it. As with every SQL Server release, SQL Server has also marked several features as deprecated, which means they are removed in …
Deprecated Features in the SQL Server 2012 Database Engine + read more
I’m very happy today to announce 4 new upcoming SQL Server workshops across Europe within the next months: SQL Server Configuration Day Date/Location April 26 in Zurich/Switzerland May 16 in Vienna/Austria Agenda Storage Configuration IO Subsystem Tests Disk Partition Alignment RAID Configuration Data-/Log-File Configuration TempDb Configuration CPU/Memory Configuration Resource Governor CPU Affinity Settings Parallelism …
Today I want to talk about Statistics Enhancements in SQL Server 2012. As you already know SQL Server uses Statistic Objects in a database to estimate the cardinality of queries. The cardinality estimation is the input for the generation of the physical Execution Plan of a given T-SQL query. Data changes over time, data distribution …
In the last weeks it was very silent on my weblog, but life is pretty fast in 2012. Currently I’m preparing tons of content about SQL Server 2012 for my upcoming event series across Europe. Besides that (which is very time consuming), I’m also happy to get the chance to speak at various SQL Server …
A few days ago, one of my customers asked if there is a possibility to get a notification from SQL Server when a query has to wait for a longer time, because an incompatible lock exists on the same object. The answer to this question was easy, because SQL Server provides you for this functionality …
Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.
