Hi All,

My new learning. Have you ever comeacrossed any time for requirement to select data from one tabe and not in second table. I guess everyone would have atleast this scenerio. There are plenty of ways of doing, either union all and do not exists or full join and .....

Today I found easy ways.
1) in Oracle we have minus operator which would result difference of two tables
    Eg: Select * from Table1 minus Select * from table2 (I am not sure with syntax in Oracle)
2) In SQL Server 2005 on war...
Continue reading ...

Hi,

I thought to list few SQL Server 2005 system tables, stored procedures which could be used in daily DBA activities. The ones which mostly used
1) Information_Schema.Tables : Holds information of available tables in Database
2) Information_Schema.Columns: Lists all columns from all tables in specific Database
3) sp_MSforeachdb: usefull for free up disk space, e.g., Shrink Command. There is are some limitations of using shrink command thats in next post if I get time to post. E.g. Exec sp_msfor...
Continue reading ...