(Craig Shallahamer) This blog series was motivated for two reasons. First, I want to demonstrate how one can calculate a database server’s CPU utilization straight from Oracle v$ views. Second, over the past few years I’ve seen a couple examples where database servers have exhibited more power then
Other News
It’s All About Architecture: the Data Warehouse building blocks powered by OLAP and Data Mining
(Luis Moreno Campos) First of all if you’re working for years in the bi/dw arena or if you just got here you must read this paper: http://bit.ly/pervasive-bi. This paper will give you an idea of the “Reference Architecture” and how all the different concepts fit together, without even touching produ
Spring Cleaning with SQL Server Stored Procedures
(Kalen Delaney) While browsing through SQL Server’s documentation looking for supplied stored procedures related to one of my current writing projects, I noticed a couple of procedures I had never noticed before: sp_clean_db_free_space and sp_clean_db_file_free_space.
Findability More than Searchability
(Alice) As semantic search professionals, we understand the importance of “findability.” “Meanwhile, Back at the Farm SharePoint Expert Blog” has a post that focuses on findability. Users do not really want to “search” they want to “find.” The post has an interesting metaphor based on the shoppin
Get Information on All Jobs running on a SQL server Instance
(Manjunath C Bhat) The SQL server Jobs which are running on a Instance are very Important. As a DBA you need to take care of these Jobs and have all information about the Job. Your will get information on Jobs is SysJobs but again not in the way you want. So just thought of pulling the Job informati
How do I drop an existing histogram on a column and stop the Auto Stats gathering job from creating it in the future?
(Maria Colgan) Before answering this question, I want to provide a bit more background to this scenario. The person who submitted this question has a table with a VARCHAR2 column called ID whose data distribution is skewed. When the Auto Stats job kicks in for this table a histogram is automatically
Obtaining Identity Column Values in SQL Server
(Gregory A. Larsen) In my last article I discussed identity columns. In that article I discussed one programming issue associated with explicitly setting an identity column while inserting data into a table. In this article I will be expanding the programming discussion to explore other programming
Best practices: Deploying Optim Performance Manager in large scale environments
(Ute Baumbach and Simon Harris) Large scale environments often have special considerations when it comes to managing performance. In such environments, it’s even more important to have a comprehensive, proactive performance management approach. Optim Performance Manager offers such an approach. In t
Introduction to Flex 4 and .NET Integration
(mapableuser) The proposed solution uses Flash Builder version 4, RemoteObject API and WebORB to provide integration between Flex and .NET.
A TimeStamp in Time
A TimeStamp in Time I was reading a tip in a daily Email from MSSQLTips and was reminded of the uniqueness of the TimeStamp data type in MS SQL Server. Many SQL engines support the concept of a TimeStamp data type. A TimeStamp data type is not one that may be modified by the user. It is a data type […]