Is your SQL Server slowing you down? Are bad queries giving your application a case of the blues? Before you go looking for help with SQL Server, make sure that you've done everything you can to solve the problems on your own. Many of SQL Server's ills can be solved with some easy preventative maintenance,…
What are the costs when you ask SQL Server to recompile a statement or a stored procedure each time it runs? In this 30 minute talk Kendra Little explains the impact on query execution-- and on your SQL Server instance-- of forcing recompilation. This talk is appropriate for DBAs and Developers who have a working knowledge of execution plans in SQL Server.
If you're using SQL Server 2012's hot new AlwaysOn Availability Groups feature, your databases will go offline when your network connection does - even if you're using asynchronous replication.
This is not a bug. This is working as designed - and it's important to understand the underlying concepts.
What’s slowing down production? It’s easy to find out in 60 seconds by running a simple plan cache query. See, in order to turn your beautifully written query into a set of results, SQL Server needs a plan – an execution plan. It caches these plans in memory along with statistics like the number of…
Remember that weirdo in high school who had no social skills? Couldn't get a date, worked at the fast food joint as a fry cook, face covered with zits - you know the one. Okay, actually, it was us. Anyway, the point is, we got our act together, didn't we? So did Windows Failover Clustering. …
Do you have a SQL Server that’s not getting enough action?
Maybe you have a new piece of production or lab hardware that you’d like to benchmark, to see how it compares with other gear in your environment.
