(Dinesh Asanka) No matter what your platform or the tools that you are using, performance is almost always the number one feature that customers require. In the case of SQL Server Analysis Service (SSAS), there are four areas where we can improve the performance. They are database design, processin
Other News
Replicated stored procedure options with SQL Server 2005
(Jeremy Kadlec) Replicating stored procedures between databases can be a straightforward task if the right processes and technologies are available in SQL Server. These would include the native replication features or log shipping. Without them, you can still use manual processes to achieve the same
Introduction To Reverse Key Indexes: Part IV (Cluster One)
(Richard Foote) There’s a myth that suggests if the Clustering Factor (CF) of an index is greater than a certain ratio when compared to the number of rows in the table, the CF is poor and an index rebuild would be beneficial.
(94) SQL Server 2008 Slippage, Newsletter Watch, Open Source Follow-Up, Industry News.
Pro-Center Video Programming for IT Professionals
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 […]
DB2 Running Total Sum
(Rob Williams) Unlike some of the popular open source databases, DB2 supports ANSI windowing functions. Few people actually make use of its support as most people don’t know about it.
Ecommerce Functions in XPath
(Jennifer Kyrnin) There are many advanced functions of XPath to allow you to manipulate your XSLT. These functions help you reduce the amount of programming you need to do after transforming the data. These functions will help you create ecommerce documents and manipulate the data.
Web Tutorial: How AJAX Effects The Network
(Lori MacVittie) AJAX, short for “Asynchronous JavaScript and XML,” is probably one of the most exciting technological improvements in Web-application development to hit the browser in the past few years. Before AJAX, we had to come up with innovative workarounds such as the use of inline frames and
Convert XML in SQL Server
(chrishayuk) This is seriously cool. In my C# I have read an xml file into a byte[] and stored it within the database in a varbinary(max) column.
Sometimes a variables table is better than hard coding into a package
(Rex Baldazo) When writing PL/SQL packages, there are times where it’s better to store a variable in a table instead of coding it into the package. It’s most useful for a variable that you might want to change fairly often. If you put such a variable directly in the package (either the spec or body)