Tips and Tricks Corner : SQL Server 2000


Home About Us Sign Guest Book Contact Us Subscribe RSS

SQL

Articles

.NET

Blogs

Newsletter

Click on the image to subscribe to our Monthly Newsletter.

Click here for Archives

Expert Chat

No Chats Available

10. DMVs - sp_who2 Script
I have had a chance to talk on the new DMV's from SQL Server at various forums. And from time to time I have been a strong advocate that the DMV's actually expose more information than what we used to get in SQL 2000 from DBCC or other commands. Moreover, DMV's are quite open in their values rather than the conventional bit manipulation we were used to. Here is a classic example of DMV's where we show the query used to mimic sp_who2 output for user connections.
Posted On : May 25, 2008	More...	Author : Vinod Kumar

9. Batching DML Operation in SQL Server
In this article we will see how we can perform DML operation in Batches in SQL Server.
Posted On : October 01, 2004	More...	Author : Vinod Kumar

8. How to Multiply Column Values in SQL Server
We had a recent discussion on the public newsgroups on how to get this requirement in a single statement without using T-SQL. I was indeed taken by surprise how this requirement was answered by fellow MVP's. Infact there is a solution even though no so elegant, but works great having said what the requirement looks.
Posted On : September 06, 2004	More...	Author : Vinod Kumar

7. Finding Object Definition in SQL Server 2005
This tip will show how you can find the definition of system stored procedures. I introduce the new command to be used hereafter in Yukon.
Posted On : August 21, 2004	More...	Author : Vinod Kumar

6. SQL Query Analyzer Shortcut Keys
Learn the shortcut keys available in SQL Server 2000 Query Analyzer tool. Most of the keys are of immediate relevance and use to all.
Posted On : November 17, 2003	More...	Author : Vinod Kumar

5. Getting Preferred Address Problem
This is a trick that I saw at the SQL Server public Newsgroup. The solution was given by Steve Kass. I feel this is one of the common requirement and the solution is indeed unique and creative. The problem is to find the most appropriate address applicable for a person from the DB desgign given.
Posted On : September 13, 2003	More...	Author : Vinod Kumar

4. Forming a comma Separated String in SQL Server 2000
There are hundreds of T-SQL requirements that lead to innovative and faster coding practices. But the requirement in the industries keep on increasing. Here is one such requirement that I ve been asked by many peers.
Posted On : May - 2003	More...	Author : Vinod Kumar

3. How to find CD Key and MDAC Version in SQL Server
How can I find the CD Key for the installed SQL Server from isqlw.
Posted On : July - 2003	More...	Author : Vinod Kumar

2. Get Directory Browsing from SQL
Is it possible to browse your SQL Server from the ISQLW window? Here are some ways you can do the same.
Posted On : June - 2003	More...	Author : Vinod Kumar

1. Get the number of days in a month
There are hundreds of ways by which in SQL we can get number of days in a given month. Here are some of the ways you can adopt.
Posted On : May - 2003	More...	Author : Vinod Kumar

Bangalore .NET User Group (BDotNet), India's Biggest and Active .Net User Group

The MVP Award is given in recognition of a recipient's technical expertise, spirit of community, and their willingness to help their peers by providing reliable and accurate answers to technical questions about Microsoft products & technologies

The Microsoft India Community Star is a recognition program that strives to identify dedicated individuals within technical communities who share a passion for technology and the spirit of community.


Free Hit Counters	Copyright © 2000-2003 ExtremeExperts.com, Terms of Use Best viewed on 1024x768 using Microsoft Internet Explorer 5.5 and later. Hosted on Windows Server 2003/.NET Framework 1.1.