(Hemant K Chitale) In my opinion, DETERMINISTIC functions are not very well explained. Some DBAs and Developers know that a Function must be DETERMINISTIC if it is to be used to create a Function Based Index.
Other News
Latch contention troubleshooting case study and Flashback Database performance issues with LOBs
(Tanel Poder) Steve Bamber has written up a case study of library cache latch contention troubleshooting of an Apex application with LatchProf.
Generate an SQL replay file using TKPROF
(Gary Myers) Handy hint. You can use TKPROF’s “record” option to extract a ‘replay’ script from a trace.
What About Surrogate Keys?
(Craig Mullins) As is so often the case with my blog, today’s topic came about as the result of an e-mail question I received from a DBA I know. His question was this:
Tips for DBAs from Guest Blogger Norberto…. DB2’s Got Talent contestant
Thanks to Norberto for accepting my invitation to be a guest blogger on my site today. Norberto was one of our finalists in the DB2Night Show’s “DB2’s Got Talent” Competition”. As in his presentations, you’ll find this post very full of incredibly useful information. Norberto was concerned that h
How to store IP address value in integer datatype column.
(Krishna Chandra Prajapati) Most of the time, we use string datatype column like char or varchar to store ip address values. There is a way to store ip address value in numeric datatype column like unsigned interger.
Updating a view via Linked server query may fail
Consider the following scenario for two SQL Servers SQLA and SQLB:
Grouping and Counting in LINQ to SQL
(Ged Mead) In this earlier blog, I covered the basic steps leading up to creating grouped data and displaying it. Now I want to add totals to those groups.
Using TYPED for member properties in SSRS MDX queries
(Jason Thomas) Recently I got a very interesting query from one of my colleagues. He was trying to sort a table in a SSRS report based on an integer member property, but the sort results were coming wrong according to him. He said that the report was treating the property field as a character and cl
Establish a system to build custom virtual cloud images
(Dustin Amrhein and Vanessa Grose) Virtual images allow users to freeze-dry preferred software environments and deliver them to users in a rapid and consistent manner: As a result, companies are turning to virtual images as a means to improve software delivery within their data centers. As they make