Personal Tech Journal

Sleepless Night Again the work continued the whole night. This is some info on Extended SP's Insight to Extended Stored Procedures For a long time i was thinking about this Extended Stored Procedures that we have SQL SERVER. Here i am going to explain the usage of few of the Extended Stored Procedures.Before i begin with the explaination of few the Extended Sps, Let me define what is a Extended Stored Procedures. An Extended Stored Procedure is one which has its functionality logic in a Dynamic Link Library and these functions can be called for the TSQL as normal procedures. Lets begin with the usage of few of the Extended Stored Procedures. 1.xp_fixeddrives This will give us the drives in your machine. exec master..xp_fixeddrives 2.xp_dirtree This one will return the directory structure of the path provided. EXEC xp_dirtree 'C:\Program Files\Microsoft SQL SERVER\' 3.xp_fileexist This will give whether the file exists or not. EXEC xp_fi

Long Night It was a long night at office. Working towards a release.............. Had some Database problem.. It was giving an error "user or role exists in the current database" Finally it was sorted out. A Hard day out and i am really tired..

A simple piece of code This is a code to select the #row from a table. For example if you give 2 it will select the second row from the table. The procedure is create procedure SP_FETCH_ROWS(@num int) AS BEGIN select * from employee a where @num=(select count(*) from employee b where a.id >= b.id) END The table i am using employee. The structure is id int name varchar(50) age int sex char(1) The rows in my table are id name age sex ----------- -------------------------------------------------- ----------- ---- 1 shaju 25 M 2 thomas 25 M 3 anil 25 M 4 ashley 25 M Now when execute the procedure to select the third row exec SP_FETC

I am back again.. I found a nice site on data modelling , normalization . have a look at it . Increase ur skills in DB Concepts http://www.utexas.edu/its/windows/database/datamodeling/dm/design.html Cheers!!!!!!!!

A good article on The Data Tier: An Approach to Database Optimization I liked it . It gives various ways for Database optimization. Read it from the below link http://www.microsoft.com/technet/treeview/default.asp?url=/TechNet/prodtechnol/sql/reskit/sql2000/part10/c3361.asp Take Care Bye

Hey Guys and Gals have a look at this Yukon article at this following link http://www.extremeexperts.com/sql/articles/Yukon.aspx

Something Abt Sql Server Yukon. Have a look :) What You Need to Know About SQL Server Yukon The next version of Microsoft SQL Server, code-named Yukon, is set for a mid-2003 beta 1 test and an early 2004 release. Microsoft considers this release to be as crucial to the company's plans as Windows Server 2003, saying that Yukon will be a database server upgrade and also a platform on which Microsoft will base future versions of Active Directory (AD), Microsoft Exchange Server, the Windows file system, and other products. Microsoft says that Yukon is all about programmability, enterprise database enhancements, and business intelligence. Here's what you need to know about Yukon. Programmability Because of its deep integration with the Windows .NET Framework and Common Language Runtime (CLR), Yukon will be a significant release for developers, who, for the first time, will be able to use languages other than T-SQL to program the database. In the past, developers w

Hi, Welcome to my Blog