Click here to Skip to main content

Articles by pinaldave (Articles: 16, Technical Blogs: 16)

Articles: 16, Technical Blogs: 16

RSS Feed

Average article rating: 3.95

ASP.NET
General
Posted: 10 Jul 2007   Updated: 10 Jul 2007   Views: 42,483   Rating: 3.70/5    Votes: 12   Popularity: 3.99
Licence: Not specified      Bookmarked: 46   Downloaded: 0
SQL SERVER - 2005 Best Practices Analyzer Tutorial - Sample Example
Database
General
Posted: 21 Aug 2007   Updated: 21 Aug 2007   Views: 62,203   Rating: 2.09/5    Votes: 16   Popularity: 2.41
Licence: Not specified      Bookmarked: 23   Downloaded: 0
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
Posted: 6 Sep 2007   Updated: 6 Sep 2007   Views: 29,625   Rating: 3.75/5    Votes: 7   Popularity: 3.17
Licence: The Code Project Open License (CPOL)      Bookmarked: 23   Downloaded: 0
SQL SERVER - 2005 - Introduction and Explanation to sqlcmd
Posted: 17 Nov 2007   Updated: 17 Nov 2007   Views: 76,762   Rating: 4.84/5    Votes: 13   Popularity: 5.38
Licence: The Code Project Open License (CPOL)      Bookmarked: 40   Downloaded: 0
SQL SERVER - 2005 - Generate Script with Data from Database - Database Publishing Wizard
SQL Server
Posted: 29 Jul 2007   Updated: 29 Jul 2007   Views: 36,384   Rating: 3.40/5    Votes: 10   Popularity: 3.40
Licence: The Code Project Open License (CPOL)      Bookmarked: 28   Downloaded: 0
I have tried to accommodate all of them in last post in the series. I hope this series is helpful to all candidates who are seeking job as well interviewers. I have combined all the questions and answers in the one PDF which is available to download and refer at convenience.
Posted: 3 Sep 2008   Updated: 3 Sep 2008   Views: 137,505   Rating: 4.83/5    Votes: 25   Popularity: 6.73
Licence: The Code Project Open License (CPOL)      Bookmarked: 66   Downloaded: 0
SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database
Posted: 10 Sep 2008   Updated: 10 Sep 2008   Views: 68,664   Rating: 4.47/5    Votes: 13   Popularity: 5.05
Licence: The Code Project Open License (CPOL)      Bookmarked: 31   Downloaded: 0
First article on topic - SQL SERVER - 2008 - Creating Full Text Catalog and Full Text Search
Posted: 19 Sep 2008   Updated: 19 Sep 2008   Views: 115,080   Rating: 3.81/5    Votes: 14   Popularity: 3.94
Licence: The Code Project Open License (CPOL)      Bookmarked: 47   Downloaded: 0
A Big Downloadable List of SQL Server 2008 Questions and Answers
Posted: 7 Apr 2009   Updated: 8 Apr 2009   Views: 14,824   Rating: 4.44/5    Votes: 5   Popularity: 3.11
Licence: The Code Project Open License (CPOL)      Bookmarked: 20   Downloaded: 0
Reseed Identity of Table - Table Missing Identity Values - Gap in Identity Column
Posted: 13 Oct 2009   Updated: 13 Oct 2009   Views: 13,663   Rating: 4.00/5    Votes: 3   Popularity: 1.91
Licence: The Code Project Open License (CPOL)      Bookmarked: 10   Downloaded: 0
Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup
Posted: 9 Mar 2010   Updated: 9 Mar 2010   Views: 10,239   Rating: 2.91/5    Votes: 8   Popularity: 2.63
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
SQL SERVER – Order of Columns in Update Statement does not matter
Posted: 24 Aug 2010   Updated: 24 Aug 2010   Views: 18,048   Rating: 5.00/5    Votes: 12   Popularity: 5.40
Licence: The Code Project Open License (CPOL)      Bookmarked: 19   Downloaded: 0
A Finale of Series discussing Computed Columns, Storage and Performance
Posted: 13 Oct 2010   Updated: 13 Oct 2010   Views: 7,528   Rating: 4.50/5    Votes: 2   Popularity: 1.35
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 0
Limitations of the View Many and Many
Posted: 20 Apr 2011   Updated: 20 Apr 2011   Views: 7,266   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 1
A Quick Guide to Find Potential Peformance Issue
Posted: 14 Jul 2011   Updated: 14 Jul 2011   Views: 11,543   Rating: 4.61/5    Votes: 15   Popularity: 5.45
Licence: The Code Project Open License (CPOL)      Bookmarked: 20   Downloaded: 0
5 Database Worst Practices which can be fatal to any business
Design and Architecture
General
Posted: 17 Jun 2007   Updated: 17 Jun 2007   Views: 25,778   Rating: 1.80/5    Votes: 6   Popularity: 1.40
Licence: Not specified      Bookmarked: 27   Downloaded: 0
SQL SERVER - 2005 T-SQL Paging Query Technique Comparison (OVER and ROW_NUMBER()) - CTE vs. Derived Table

Average blogs rating: 4.68

ATL Server
General
Posted: 22 Jul 2011   Updated: 22 Jul 2011   Views: 5,120   Rating: 4.50/5    Votes: 2   Popularity: 1.20
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
This blog post is written in response to the T-SQL Tuesday hosted by Amit Banerjee. I know Amit personally and very big fan of his community activities. I read his blog, read his comments, follow his tweets, and the most importantly reach out to him when I feel like talking SQL. Amit has selected a
Posted: 10 Dec 2011   Updated: 10 Dec 2011   Views: 15,737   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
Avoid Using Keywords as an Object
Posted: 26 Dec 2011   Updated: 26 Dec 2011   Views: 13,542   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
First of all Merry Christmas and Happy Holidays to everybody. I wish you best holiday season. In today’s blog post – I am sharing very small question received by one of the reader. Though simple sometime a small question make people think. He sent me very similar to following image and a
Posted: 5 Jun 2012   Updated: 5 Jun 2012   Views: 6,765   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
Some kinds of confusion never go away. Here is one of the ancient confusing things in SQL. The precision of the SmallDateTime is one concept that confuses a lot of people, proven by the many messages I receive everyday relating to this subject. Let me start with the question: What is the precision o
Posted: 17 Jul 2012   Updated: 13 Aug 2012   Views: 21,657   Rating: 3.80/5    Votes: 5   Popularity: 2.62
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
How to find column used in a stored procedure.
Site & Server Management
General
Posted: 27 Feb 2012   Updated: 27 Feb 2012   Views: 12,131   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
If you are following my recent blog posts, you may have noticed that I’ve been writing a lot about Guest User in SQL Server. Here are all the blog posts which I have written on this subject: SQL SERVER – Disable Guest Account – Serious Security Issue SQL SERVER – Force Removing User from Database –
Microsoft BizTalk Server
General
Posted: 17 Jun 2011   Updated: 17 Jun 2011   Views: 10,690   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
Earlier I have published Puzzle Why SELECT * throws an error but SELECT COUNT(*) does not. This question have received many interesting comments. Let us go over few of the answers, which are valid. Before I start the same, let me acknowledge Rob Farley who has not only answered correctly very first
Posted: 26 Nov 2011   Updated: 26 Nov 2011   Views: 13,411   Rating: 4.20/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
SQL SERVER – 2012 – Summary of All the Analytic Functions – MSDN and SQLAuthority
Database
SQL Server
Posted: 4 Jun 2011   Updated: 4 Jun 2011   Views: 6,002   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
SQL Server – Puzzle – Statistics are not Updated but are Created Once
Posted: 11 Jun 2012   Updated: 11 Jun 2012   Views: 8,068   Rating: 3.00/5    Votes: 2   Popularity: 0.30
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
How to swap value of a column without a Case statement.
Posted: 12 Feb 2013   Updated: 12 Feb 2013   Views: 10,235   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
Primary Key and non-clustered index in simple words.
SQL Reporting Services
General
Posted: 17 Aug 2011   Updated: 17 Aug 2011   Views: 10,475   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
Answer simple quiz at the end of the blog post and - Every day one winner from India will get Joes 2 Pros Volume 3. Every day one winner from United States will get Joes 2 Pros Volume 3. System and Time Data Types Keeping track of date and time data points has always been [...]
Programming Tips
Design and Strategy
Posted: 8 Aug 2011   Updated: 8 Aug 2011   Views: 11,528   Rating: 4.89/5    Votes: 3   Popularity: 2.39
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series
Posted: 24 Aug 2011   Updated: 24 Aug 2011   Views: 11,073   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series
Uncategorised Tips and Tricks
General
Posted: 5 Aug 2011   Updated: 8 Aug 2011   Views: 9,960   Rating: 4.83/5    Votes: 3   Popularity: 2.27
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
Answer simple quiz at the end of the blog post and - Every day one winner from India will get Joes 2 Pros Volume 1. Every day one winner from United States will get Joes 2 Pros Volume 1.
Posted: 9 Aug 2011   Updated: 9 Aug 2011   Views: 9,668   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series
No tips have been posted.
No reference articles have been posted.

pinaldave
Founder http://blog.SQLAuthority.com
India India
Pinal Dave is a Microsoft Technology Evangelist (Database and BI). He has written over 2200 articles on the subject on his blog at http://blog.sqlauthority.com. Along with 8+ years of hands on experience he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). He is co-author of two SQL Server books - SQL Server Programming, SQL Wait Stats and SQL Server Interview Questions and Answers. Prior to joining Microsoft he was awarded Microsoft MVP award for three continuous years for his contribution in community.
Follow on   Twitter


Advertise | Privacy | Mobile
Web04 | 2.8.141220.1 | Last Updated 22 Dec 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid