Click here to Skip to main content
12,945,927 members (53,444 online)

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

Articles: 15, Technical Blogs: 16

RSS Feed

Average article rating: 3.99

ASP.NET
General
Posted: 10 Jul 2007   Updated: 10 Jul 2007   Views: 45,574   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: 67,479   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: 33,265   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: 16 Nov 2007   Updated: 16 Nov 2007   Views: 85,896   Rating: 4.89/5    Votes: 14   Popularity: 5.55
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: 42,298   Rating: 3.48/5    Votes: 11   Popularity: 3.54
Licence: The Code Project Open License (CPOL)      Bookmarked: 29   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: 184,998   Rating: 4.88/5    Votes: 32   Popularity: 7.34
Licence: The Code Project Open License (CPOL)      Bookmarked: 73   Downloaded: 0
SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database
Posted: 10 Sep 2008   Updated: 10 Sep 2008   Views: 83,273   Rating: 4.43/5    Votes: 15   Popularity: 5.17
Licence: The Code Project Open License (CPOL)      Bookmarked: 35   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: 216,070   Rating: 4.85/5    Votes: 17   Popularity: 5.96
Licence: The Code Project Open License (CPOL)      Bookmarked: 50   Downloaded: 0
A Big Downloadable List of SQL Server 2008 Questions and Answers
Posted: 13 Oct 2009   Updated: 13 Oct 2009   Views: 16,863   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: 12,797   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: 23,754   Rating: 5.00/5    Votes: 13   Popularity: 5.57
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: 12 Oct 2010   Views: 10,482   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: 9,230   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: 14,561   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: 28,734   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.70

ATL Server
General
Posted: 22 Jul 2011   Updated: 22 Jul 2011   Views: 6,392   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.
Posted: 26 Dec 2011   Updated: 26 Dec 2011   Views: 16,958   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
SQL SERVER – Database Properties – Number of Users
Posted: 5 Jun 2012   Updated: 5 Jun 2012   Views: 9,715   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.
Posted: 11 Jun 2012   Updated: 11 Jun 2012   Views: 12,108   Rating: 3.00/5    Votes: 2   Popularity: 0.30
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
Swap Value of Column Without Case Statement in SQL Server
Posted: 17 Jul 2012   Updated: 13 Aug 2012   Views: 33,898   Rating: 4.10/5    Votes: 8   Popularity: 3.50
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: 14,780   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.
Microsoft BizTalk Server
General
Posted: 17 Jun 2011   Updated: 17 Jun 2011   Views: 12,512   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.
Posted: 26 Nov 2011   Updated: 26 Nov 2011   Views: 21,194   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: 7,001   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: 10 Dec 2011   Updated: 10 Dec 2011   Views: 18,711   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: 12 Feb 2013   Updated: 12 Feb 2013   Views: 16,866   Rating: 0.00/5    Votes:    Popularity: 0.00
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: 12,193   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
Tips from the SQL Joes 2 Pros Development Series – System and Time Data Types
Programming Tips
Design and Strategy
Posted: 8 Aug 2011   Updated: 8 Aug 2011   Views: 14,271   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: 12,582   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: 12,082   Rating: 4.83/5    Votes: 3   Popularity: 2.27
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
Tips from the SQL Joes 2 Pros Development Series – Efficient Query Writing Strategy
Posted: 9 Aug 2011   Updated: 9 Aug 2011   Views: 11,770   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.


Advertise | Privacy | Mobile
Web02 | 2.8.170518.1 | Last Updated 24 May 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid