A while back I wrote a post on SQL 2008′s Backup Compression where I took a sample database and performed a backup with and without compression being used and did some basic comparisons. So let’s say now you’ve been using SQL 2008 with the backup compression for a while now and would like to see [...]
Posts from ‘February, 2009’
SQL 2008 – STP…. I’m adding to the TLAs of the world
(If you don’t know…TLA = Three Letter Acronym) Rounding out the first 5 (not the top 5) lesser known new features in SQL Server 2008 is what I call STP. STP you say? Stone Temple Pilots? Standard Temperature and Pressure? Straight Through Processing? Wow those are 3 things I never thought I’d be giving a “shout [...]
SQL 2008 – Row Constructors
So #4 (in no particular order) of the lesser known / popular new features in SQL Server 2008 is called “Row Constructors”. Row Constructors are yet another way for me to minimize the amount of typing I do… sweet So the idea behind row constructors (for my example anyways) is taking a table that requires [...]
SQL 2008 – Compound Operators and Some FizzBuzz
Another lesser known new feature in SQL Server 2008 is the ability to use Compound Operators. Much like my post on Inline Variable Assignment this is yet another way for me to not type as much… perfect So Compound Operators take the place of the code that would look something like this: SET @x = @x [...]
SQL 2008 – Persisted SKU Features DMV
In my continuing effort to bring forth the lesser known new features in SQL Server 2008 I give to you: sys.dm_db_persisted_sku_features This is great. This new DMV gives you a nice quick view of the features that your database uses that are restricted to only Enterprise or Developer editions of SQL Server. Some examples of [...]
