How do you calculate max memory setting for SQL Server; in affect how much memory to leave to OS, threads, etc.
SQL 2008 R2 SP1 CU10 Released!
Build: 10.50.2868 KB: 2783135 A few fixes have been made, however for some reason I think I have seem most of this in previous CUs.
SQL Server 2008 R2 SP2 CU4 Released!
Build: 10.50.4270, KB: 2777358 Many fixes are rolled up in this KB, some of the interesting ones for me (Since I primary focus on the
SQL Server 2012 RTM CU5 Released
SQL Server 2012 RTM CU5 released. Build #11.0.2395.0 Most of the SQL 2012 fixes are for SSRS, SS MDX Queries, etc. But another interesting fix
Performance Impact of SQL Server Profiler
The general best practice is only capture the events and columns you need when using SQL Server Profiler. But how much impact does it have?
SQL Server Browser Service and Default Instances
Microsoft SQL Server Browser service is critical component of SQL Server, that lets allows users to connect to an instance if the default port has
SQL Canada (SQLCAN) 