Microsoft has released the final Service Pack (SP4) for SQL Server 2008. Build # 10.00.6000 KB Article: KB #2979596 (Download) 6 public fixes, including important security fixes from MS14-044 Relevant for builds < 10.00.6000...
Monthly Archive: September 2014
Tip : What Effect Does Persisting a Computed Column Have in SQL Server?
I treat a common scenario: behavior differs between two SQL Server databases that may be the same version, but different compatibility levels.
Microsoft has released a final service pack for SQL Server 2008 R2: Service Pack 3. The build # is 10.50.6000.34 and you can download it here. This is essentially a rollup of all of...
Tip : What Happens When a Computed Column is Persisted in SQL Server?
I discuss the NOLOCK hint in SQL Server, and why you want to avoid slapping it onto every table mentioned in every query.
I discuss examples where people expect SQL Server to perform tasks that really should be performed outside the scope of the database.
Tip : Change All Computed Columns to Persisted in SQL Server
I discuss ten common cases of misplaced optimization.
The SQL Server team has released two cumulative updates for SQL Server 2012. SQL Server 2012 Service Pack 2 Cumulative Update #2 KB Article: KB #2983175 Build # is 11.0.5548 Currently there are 50...
Tip : SQL Server Video – Tricks to play on your DBA – 2
For T-SQL Tuesday #58, I discuss a few of the reasons people give out the sa password, and what you should do in those cases instead.
I explain why you should avoid helper functions, and join against the catalog views instead.