(Linchi Shea) Or should I place my database files on SAN or directly-attached storage? This is a frequently asked question. It comes up repeatedly in public newsgroups, email discussion lists, and private meetings with customers who are concerned with database performance.
Other News
Determining SET Options for Current Session
With each session that is made to SQL Server the user can configure the options that are SET for that session and therefore affect the outcome of how queries are executed and the underlying behavior of SQL Server. Some of these options can be made via the GUI, while others need to be made by using
Learn About SQL Server Happenings, 4 Years Early!
Featured Article(s) Initialize to the day beginning (Vadivel Mohanakrishnan) This article explains the various ways of initializing a variable to the beginning of a day. Target audience for this is ‘Beginners to Intermediate’ level of readers. Tomorrow: New SelectViews show Today: [Watch] the current SelectViews here. Open source gotcha, discussion list watch, events and a LOT more… SQL Server Fortune […]
Converting XML Schemas to Schematron (#10): Required pairs in a sequence
(Rick Jelliffe) What we want to do is to have a Schematron pattern that just checks a very specific thing: when the use in a document of one element requires that another element immediate follows it.
Cool New Features in DB2 for LUW V9 : Part 2 : Auto Updating Timestamps
(Philip Nelson) I promised you two “cool new features” in my last post. I ran out of time after the first of these, and it has taken me a few days to get round to adding the second : so here it comes.
No more MySQL Crash Safe Replication in 5.0 ?
(Peter Zaitsev) As you might know even if you’re only using Innodb tables your replication is not completely crash safe – if Slave MySQL Server crashes/power goes down it is likely for relay logs to run out of sync (they are not synced to the disk) plus position on the master which slave remembers b
.NET Tip: Converting Strings to Enum Values
(Jay Miller) Occasionally, I run across the need to see whether a string holds a valid enumeration value. I prefer to not add comparisons to specific string values when I already have an enumeration with all possible valid values. The solution is to try to convert the string into an enumeration valu
Oracle BI EE 10.1.3.3/2 – Help URL in Title View
(Venkatakrishnan J) I had an user today emailing me about the non-working of Help URLs in Title Views. I thought i would take a look and the results were pretty strange. First to give you a background, Help URLs are those URLs to specifc documents that an end user can refer to while looking at a rep
Description of the Replay Markup Language (RML) Utilities for SQL Server
The Microsoft SQL Server support team uses several internally written utilities to ease the work that is related to a typical customer support case. Database developers and system administrators can also use these utilities to work with Microsoft SQL Server 2000 or with Microsoft SQL Server 2005. Th
IBM Expands Data Warehousing Portfolio With Optim Technology
IBM introduced new software that allows businesses to better manage the growth of information by integrating data warehousing and archiving capabilities.