SQL Feeds - All your SQL feeds in one place.

Friday, March 27, 2009

Useful links for upgrading to SQL Server 2008

by kevincox via Microsoft SQL Server Development Customer Advisory Team on 3/27/2009 2:37:00 PM

There is plenty of material available to help you upgrade to SQL Server 2008.  This blog is intended as a short list for the most useful guidance that I have found.   And you may have different experiences upgrading from SQL Server 2000 and SQL Server 2005 so please take the time to do proper preparation work and advanced studying.  And test your upgrades before you do it for real in production.  There is one bug that you need to know about that potentially affects your ...

[ read more ]

Spring cleaning your indexes - Part II

by kimberly.nospam@nospam.sqlskills.com (kltripp) via Kimberly L. Tripp on 3/27/2009 9:33:00 AM

I started the series here: http://www.sqlskills.com/BLOGS/KIMBERLY/post/Spring-cleaning-your-indexes-Part-I.aspx and I want to continue with Part II today by clarifying some great questions/comments that have come up on the series. In Part III, I'll give you a few more ways to get rid of (or consolidate) indexes. And, I think there's still a bit more that Paul and I will investigate further (wrt to operational stats) but, I want to address a few comments and a few interesting thing ...

[ read more ]

Good strategies - excellent improvements... thanks Jim!

by kimberly.nospam@nospam.sqlskills.com (kltripp) via Kimberly L. Tripp on 3/27/2009 8:47:00 AM

This morning, I woke to a wonderful email and I thought I would share it: Good morning Kimberly, I just wanted to send you an email to let you know how awesome you are! I have applied some of your indexing strategies to our website’s homegrown CMS and we are experiencing a significant performance increase. WOW....amazing tips delivered in an exciting way!  Thanks again, Jim OK, I seriously can't complain about the awesome part ;-)... but, what I think is s ...

[ read more ]

Avoid using JDK Date APIs to handle timezone sensitive date and time

by mssqlisv via SQL Programmability & API Development Team Blog on 3/27/2009 12:30:00 AM

JDK APIs for Class “java.util.Date” and “java.sql.Timestamp” (subclass of Date) including getHours(), getMinutes(), getSeconds(), getTimestamp() allow you to retrieve date/time related information. However, the JVM (Java Virtual Machine) won’t handle timezone sensitive data properly using these APIs. As matter of fact, these APIs were deprecated starting JDK 1.1 (http://java.sun.com/j2se/1.5.0/docs/api/java/util/Date.html). But I am still seeing ISV developers use these APIs in their JAVA applic ...

[ read more ]

Legal Note

The content of the postings is owned by the respective author. SQL Feeds is not responsible for the contents of the postings. This site is automatically generated and cannot be reviewed for abusive content. If you find abusive content on SQL Feeds, please contact us. Designated trademarks and brands are the property of their respective owners. All rights reserved.

Advertise with us