SQL Server Examples

SQL Server 2008 DATATIME2 data type
Greg	By greg on 3/19/2008 10:01 PM

I was spending some time over the last few weeks researching new features in SQL Server 2008 for a presentation I gave today at the Olympia Area SQL Server User Group in Tumwater, Washington, USA. So of course I had to take a closer look at the new date/time data types as part of this review. Most everyone knows that there are a number of different date/time related data types coming out with SQL Server 2008. But for this BLOG post I want to focus in on just one new data type, DATETIME2. The new DATETIME2 data type is much like the existing DATETIME data type, except that it allows more percision for the time portion of the date/time. This new data type can now support time values that are accurate to 100 nanoseconds. This new DATETIME2 data type allows you to specify how much percision you want to store in the time portion. The more percision you want the more disk space it take. A DATETIME2 data type takes from 6 to 8 bytes depending on the percision.

	More...

Think Green
Greg	By greg on 3/16/2008 8:03 AM

As Saint Patrick’s Day approaches I’m sure a number of you will be thinking about lifting a few green beers at your local watering hole. Why you are thinking about all the green items that come along with Saint Patty’s day, how about thinking green for your SQL Server environment. So about now you are probably wondering what the heck I am talking about. Well I’m talking about how you might reduce that carbon foot print for your SQL Server installations. How are you planning on reducing your consumption of rack/floor space, power, and cooling expenses? My green effort is to consider consolidation as our organization starts contemplating moving toward SQL Server 2008. I am researching how I can leverage virtualization along with consolidation to reduce the total cost of ownership for SQL Server 2008. I’m researching Microsoft Virtual Server (
	More...

SQL Server 2008 Test Databases
Greg	By greg on 3/13/2008 8:01 AM

I suppose by now all of you know about the lastest SQL Server 2005 beta (CTP6), which was released in February. If you have downloaded and installed this beta or any one of the prior CTP’s you will noticed there are no sample databases installed, which of course is normal. If you are going to play with SQL Server 2008 you can create your own database. Then use those databases to experiment and play around with the new features of SQL Server 2008. But I personally like to use the sample databases provided from Microsoft. The advantages of using sample databases is they are already populated and normally have lots of objects and code that take use the new features of SQL Server. Using these sample DBs allow you to explore the new features of SQL Server without building your own DB. Also when you are building examples to share like I do on my site (http://sqlserverexamples.com ...

	More...