Systems Engineering and RDBMS

Archive for March 14th, 2007

Microsoft acquires TellMe Networks

Posted by decipherinfosys on March 14, 2007

Microsofy announced today that they are acquiring TellMe Networks – the press release can be seen at Microsoft’s site here. TellMe Networks is used by people to look up informatio, people and businesses from anywhere using a phone, text messaging and can also see the results on your mobile devices. They have a cute little video on their beta site – here.

More information on this acquisition can be obtained at tellme’s site.   The deal is over $800 million.  So, what’s in it for Microsoft?  Microsoft mobile and non-PC devices benefit with this acquisition since Tellme’s voice interface and back-end server technologies do mean a solid value proposition for the end users.  With the way the wireless market is growing, this is a good step from a Microsoft perspective.  Tellme is a profitable company (has over $235 million in venture funding) and most of the large mobile and telecom companies are it’s customers.

Posted in News | Leave a Comment »

Finding tables without any indexes

Posted by decipherinfosys on March 14, 2007

Here is a simple SQL Server script that you can use to find out the tables that do not have any indexes defined on them and get the record count for those:

select s.name Table_Name, i.rows
from sysobjects as s
inner join sysindexes i
on s.id = i.id
where s.xtype = ‘u’
and objectproperty(s.id, ‘TableHasIndex’ ) = 0
and i.indid = 0

Needless to state, your actual production tables should all be properly designed, should have constraints on them and proper indexes. This script helps to point out any such anomalies that might exist in the schema.

Posted in SQL Server | Leave a Comment »

Generate Kill Session Script in Oracle

Posted by decipherinfosys on March 14, 2007

Small tid-bit:

A simple script to generate the KILL session commands in Oracle:

select ‘ALTER SYSTEM KILL SESSION ”’||sid||’,’||serial#||”’;’
From v$session where schemaname = ‘<schema_name>’
/

Posted in Oracle | Leave a Comment »