Read my article in SQL Server Magazine January 2007 Edition
I will be not able to post complete article here due to copyright issues. Please visit the link above to read the article.
Reference : Pinal Dave (http://blog.SQLAuthority.com)
-
-
About Pinal Dave
Pinalkumar Dave is Microsoft SQL Server MVP and a prominent author of over 1000 SQL Server articles. He is a dynamic and proficient Principal Database Architect, Corporate Trainer and Project Manager specializing in SQL Server Programming with over 7 years of hands-on experience. He holds a degree in Masters of Science and has accomplished a number of certifications including MCDBA and MCAD (.NET). He has also been awarded Regional Mentor for PASS Asia.
-
Blog Stats
- 8,315,323 Readers
-
SQLAuthority Links
My Homepage
My Resume
My Other Blog
--------------------
Top Downloads
PDF Downloads
Script Downloads
Script Bank
Favorite Scripts
All Scripts - 1
All Scripts - 1
Top Articles
Best Articles
Favorite Articles - 1
Favorite Articles - 2
--------------------
SQL Interview Q & A
SQL Coding Standards
SQL FAQ Download
--------------------
Jobs @ SQLAuthority
Categories
- About Me (49)
- Best Practices (82)
- Business Intelligence (5)
- Data Warehousing (27)
- Database (257)
- DBA (121)
- DigiCorp (7)
- MVP (79)
- Poll (5)
- Readers Contribution (22)
- Readers Question (28)
- Software Development (62)
- SQL Add-On (88)
- SQL Backup and Restore (48)
- SQL BOL (8)
- SQL Coding Standards (21)
- SQL Constraint and Keys (49)
- SQL Cursor (30)
- SQL Data Storage (36)
- SQL DateTime (36)
- SQL Documentation (193)
- SQL Download (198)
- SQL Error Messages (115)
- SQL Function (104)
- SQL Humor (22)
- SQL Index (82)
- SQL Interview Questions and Answers (54)
- SQL Joins (61)
- SQL Optimization (51)
- SQL Performance (204)
- SQL Puzzle (18)
- SQL Security (115)
- SQL Server DBCC (42)
- SQL Server Management Studio (17)
- SQL Stored Procedure (97)
- SQL String (17)
- SQL System Table (27)
- SQL Trigger (27)
- SQL User Group (39)
- SQL Utility (116)
- SQL White Papers (8)
- SQLAuthority (303)
- SQLAuthority Author Visit (60)
- SQLAuthority Book Review (18)
- SQLAuthority News (273)
- SQLAuthority Website Review (23)
- SQLServer (40)
- Tech (767)
- Pinal Dave (756)
- SQL Scripts (490)
- Technology (1018)
- SQL (1018)
- SQL Authority (1018)
- SQL Query (1018)
- SQL Server (1018)
- SQL Tips and Tricks (1018)
- T SQL (1018)
-
Top Posts
- SQL Server Interview Questions and Answers Complete List Download
- SQL SERVER - Insert Data From One Table to Another Table - INSERT INTO SELECT - SELECT INTO TABLE
- SQL SERVER - Insert Multiple Records Using One Insert Statement - Use of UNION ALL
- SQL SERVER - 2008 - Interview Questions and Answers Complete List Download
- SQL SERVER - 2005 - Create Script to Copy Database Schema and All The Objects - Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects
- SQL SERVER - Import CSV File Into SQL Server Using Bulk Insert - Load Comma Delimited File Into SQL Server
- SQL SERVER - Convert Text to Numbers (Integer) - CAST and CONVERT
- SQL SERVER - Retrieve Current Date Time in SQL Server CURRENT_TIMESTAMP, GETDATE(), {fn NOW()}
- SQL SERVER - 2005 NorthWind Database or AdventureWorks Database - Samples Databases
- SQL SERVER - Shrinking Truncate Log File - Log Full
- SQL Server Interview Questions and Answers - Introduction
- SQL SERVER - Restore Database Backup using SQL Script (T-SQL)
-
Authors
-
pinaldave
- SQL SERVER – Disk Partition Alignment Best Practices
- SQLAuthority News – Book Review – The Rational Guide to Building Technical User Communities (Rational Guides)
- SQLAuthority News – MVP Award Renewed
- SQL SERVER – Difference between Line Feed (\n) and Carriage Return (\r) – T-SQL New Line Char
- SQL SERVER – 2008 – Policy-Based Management – Create, Evaluate and Fix Policies
- SQL SERVER – Maximum Number of Index per Table
- SQL SERVER – 2008 – Management Studio New Features
- SQL SERVER – Fix : Error : 17892 Logon failed for login due to trigger execution. Changed database context to ‘master’.
- SQL SERVER – Interesting Observation of Logon Trigger On All Servers – Solution
- SQLAuthority News – Authors Visit – K-MUG TechEd Trivandrum on June 27, 2009
-
Archives
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
Pages
Category Cloud
-
hi sir .thanks so much for most of articles very usefull..
your articles is very good.
sir i want to know about which tech.used for write the procedurs for any query. and some tech.automatic write procedur..plz help me .and tell me about ….