This document is created by Brian Cidern, he has written this excellent extension to SQL Expert who SQL SERVER – Change Collation of Database Column – T-SQL Script. His scripts are not only extremely helpful to achieve the task of consolidating collations in quick script. His script not only works perfectly but excellent piece [...]
Archive for the ‘Readers Contribution’ Category
SQL SERVER – Change Collation of Database Column – T-SQL Script – Consolidating Collations – Extention Script
Posted in Readers Contribution, Readers Question, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL Utility, T SQL, Technology, tagged SQL Collation on October 19, 2009 | Leave a Comment »
SQL SERVER – Interesting Observation – Execution Plan and Results of Aggregate Concatenation Queries
Posted in Pinal Dave, Readers Contribution, SQL, SQL Authority, SQL Index, SQL Puzzle, SQL Query, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology, tagged SQL View on September 29, 2009 | 2 Comments »
Working with SQL Server has never seems to be monotonous – no matter how long one has worked with it. Quite often, I come across some excellent comments that I feel like acknowledging them as blog posts. Recently, I wrote an article on SQL SERVER – Execution Plan and Results of Aggregate Concatenation Queries Depend [...]
SQL SERVER – Find Gaps in The Sequence
Posted in Pinal Dave, Readers Contribution, Readers Question, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology, tagged Identity on September 6, 2009 | 6 Comments »
I have previously written two articles on the subject of missing identity and both are very well received by community. I had great fun to write article as many SQL Server expert participated in both the articles. Expert Imran Mohammed had provided excellent script to find missing identity. Please read both the articles for additional [...]
SQL SERVER – Discussion – Effect of Missing Identity on System – Real World Scenario
Posted in DBA, Database, Pinal Dave, Readers Contribution, Readers Question, SQL, SQL Authority, SQL Constraint and Keys, SQL Index, SQL Puzzle, SQL Query, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on August 11, 2009 | 6 Comments »
About a week ago, SQL Server Expert, Imran Mohammed, provided a script, which will list all the missing identity values of a table in a database. In this post, I asked my readers if any could write a similar or better script. The results were interesting. While no one provided a new script, my question [...]
SQLAuthority News – Author’s Birthday – Top 7 Commenters – Volunteers
Posted in About Me, DBA, Database, Pinal Dave, Readers Contribution, Readers Question, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, Software Development, T SQL, Technology on July 30, 2009 | 33 Comments »
Today is July 30 and I am very happy; it’s my Birthday, celebration time!!! The most common question I receive on my every birthday is -what are my plans for birthday. Let me share my plans here today. Additionally, if you are interested to know when SQL Server was born read my post SQLAuthority News [...]
SQL SERVER – List All Missing Identity Values of Table in Database
Posted in Pinal Dave, Readers Contribution, SQL, SQL Authority, SQL Function, SQL Query, SQL Scripts, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, T SQL, Technology, tagged Identity on July 27, 2009 | 28 Comments »
The best part of any blog is when readers ask each other questions. Better still, is when a reader takes the time to provide a detailed response.
A few days ago, one of my readers, Yasmin, asked a very interesting question:
How we can find the list of tables whose identity was missed (not is sequential order) [...]
SQLAuthority News – SQL Server Value Calculator
Posted in Pinal Dave, Readers Contribution, SQL, SQL Authority, SQL Documentation, SQL Query, SQL Server, SQL Tips and Tricks, SQL Utility, SQLAuthority News, T SQL, Technology on July 22, 2009 | 2 Comments »
I have been using twitter for quite some time now (follow me at @pinaldave). In twitter world very often I find something interesting shared by my friends there. SQL Server Expert and Microsoft Evanglist Vinod Kumar has twitted very interesting detail linking to SQL Server Value Calculator. The web version of this tool is created [...]
SQL SERVER – Maximum Number of Index per Table
Posted in Pinal Dave, Readers Contribution, Readers Question, SQL, SQL Authority, SQL Index, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on June 29, 2009 | 13 Comments »
TechEd on Road Ahmedabad, June 20, 2009, was a huge success. This grand event saw over 200 attendees actively participating in the sessions. We had attendees traveling from far and wide, including Delhi, Mumbai, Jaipur, Kerala, Baroda, Himmatnagar, Rajkot, among other cities from India. This enthusiastic participation made the event truly grand. It was a [...]
SQL SERVER – Interesting Observation of Logon Trigger On All Servers – Solution
Posted in Pinal Dave, Readers Contribution, SQL, SQL Authority, SQL Puzzle, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL Trigger, SQLServer, T SQL, Technology on June 26, 2009 | 6 Comments »
Does the title of this post trigger your mind? If you all remember, a few days back I had written an article on my interesting observation regarding logon triggers. I would advise you to first read SQL SERVER – Interesting Observation of Logon Trigger On All Servers before continuing with this article further to have [...]
SQL SERVER – Performance Counters from System Views – By Kevin Mckenna
Posted in Pinal Dave, Readers Contribution, SQL, SQL Authority, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL System Table, SQL Tips and Tricks, T SQL, Technology on June 10, 2009 | 1 Comment »
I just love social media and all the new concepts of Web 2.0. There are bloggers who are overwhelmed by the new concepts of technology and are not able to keep pace with it. But I like taking such challenges. Twitter has acquired tremendous popularity nowadays and just like everybody else I am also fond [...]
About Pinal Dave
Pinalkumar Dave is a Microsoft SQL Server MVP and a Mentor for Solid Quality India. He has written over 1100 articles on the subject on his blog at http://blog.sqlauthority.com. He is a dynamic and proficient Principal Database Architect, Corporate Trainer and Project Manager, who specializes in SQL Server Programming and has 7 years of hands-on experience. He holds a Masters of Science degree and a number of certifications, including MCDBA and MCAD (.NET). He was awarded Regional Mentor for PASS Asia.
-
Blog Stats
- 10,703,018 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 - 2
Top Articles
Best Articles
Favorite Articles - 1
Favorite Articles - 2
--------------------
SQL Interview Q & A
SQL Coding Standards
SQL FAQ Download
--------------------
Jobs @ SQLAuthority
Top 7 Commenters
350 - Imran Mohammed
133- Brian Tkatch
53 - Jacob Sebastian
48 - Tejas Shah
47 - Jerry Hung
46 - Kuldip Bhatt
36 - Ashish GilhotraCategories
- About Me (61)
- Best Practices (90)
- Business Intelligence (14)
- Data Warehousing (30)
- Database (267)
- DBA (124)
- MVP (97)
- Poll (5)
- Readers Contribution (37)
- Readers Question (44)
- Software Development (66)
- SQL Add-On (91)
- SQL Backup and Restore (54)
- SQL BOL (10)
- SQL Coding Standards (20)
- SQL Constraint and Keys (50)
- SQL Cursor (28)
- SQL Data Storage (45)
- SQL DateTime (37)
- SQL Documentation (217)
- SQL Download (222)
- SQL Error Messages (125)
- SQL Function (124)
- SQL Humor (25)
- SQL Index (93)
- SQL Interview Questions and Answers (57)
- SQL Joins (63)
- SQL Optimization (63)
- SQL Performance (219)
- SQL Puzzle (25)
- SQL Security (119)
- SQL Server DBCC (42)
- SQL Server Management Studio (28)
- SQL Stored Procedure (100)
- SQL String (19)
- SQL System Table (50)
- SQL Trigger (24)
- SQL User Group (48)
- SQL Utility (126)
- SQL White Papers (34)
- SQLAuthority (368)
- SQLAuthority Author Visit (80)
- SQLAuthority Book Review (18)
- SQLAuthority News (338)
- SQLAuthority Website Review (28)
- SQLServer (74)
- Tech (905)
- Pinal Dave (895)
- SQL Scripts (527)
- Technology (1145)
- SQL (1145)
- SQL Authority (1145)
- SQL Query (1145)
- SQL Server (1145)
- SQL Tips and Tricks (1145)
- T SQL (1145)
-
Top Posts
- 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 Interview Questions and Answers Complete List Download
- SQL SERVER - Import CSV File Into SQL Server Using Bulk Insert - Load Comma Delimited File Into SQL Server
- SQL SERVER - Retrieve Current Date Time in SQL Server CURRENT_TIMESTAMP, GETDATE(), {fn NOW()}
- SQL SERVER - Convert Text to Numbers (Integer) - CAST and CONVERT
- 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 - 2008 - Interview Questions and Answers Complete List Download
- SQL SERVER - Restore Database Backup using SQL Script (T-SQL)
- SQL SERVER - 2005 List All Tables of Database
- SQL SERVER - Shrinking Truncate Log File - Log Full
- SQL Server Interview Questions and Answers - Part 1
-
Authors
-
pinaldave
- SQLAuthority News – Data Compression Strategy Capacity Planning and Best Practices
- SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 4
- SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 3
- SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 2
- SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 1
- SQLAuthority News – 3 Year Old Blog – PASS Summit 2009 – 10.5 Million Views
- SQL Authority News – Advanced T-SQL with Itzik Ben-Gan – Solid Quality Mentors
- SQLAuthority News – New PASS President Rushabh Mehta
- SQLAuthority News – India Market and Third Party SQL Server Tools
- SQLAuthority News – Birds-of-a-Feather (BOF) Lunch – SQL PASS Summit, Seattle, 2009
-
Archives
- November 2009
- October 2009
- September 2009
- August 2009
- 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
About Me Best Practices Database DBA MVP Pinal Dave Software Development SQL SQL Add-On SQL Authority SQLAuthority Author Visit SQLAuthority News SQL Documentation SQL Download SQL Error Messages SQL Function SQL Index SQL Joins SQL Optimization SQL Performance SQL Query SQL Scripts SQL Security SQLServer SQL Server SQL Stored Procedure SQL Tips and Tricks SQL Utility Technology T SQL


