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.93

ASP.NET
General
Posted: 10 Jul 2007   Updated: 10 Jul 2007   Views: 42,356   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,020   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,495   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,293   Rating: 4.84/5    Votes: 13   Popularity: 5.38
Licence: The Code Project Open License (CPOL)      Bookmarked: 39   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,054   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: 135,256   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,022   Rating: 4.53/5    Votes: 12   Popularity: 4.26
Licence: The Code Project Open License (CPOL)      Bookmarked: 30   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: 111,958   Rating: 3.43/5    Votes: 13   Popularity: 3.69
Licence: The Code Project Open License (CPOL)      Bookmarked: 45   Downloaded: 0
A Big Downloadable List of SQL Server 2008 Questions and Answers
Posted: 7 Apr 2009   Updated: 8 Apr 2009   Views: 14,673   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,462   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,128   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: 17,841   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,386   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,142   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,357   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,665   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,051   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,588   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,179   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,584   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,193   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,025   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,599   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,132   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: 5,957   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: 7,862   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: 9,972   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,384   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,429   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: 10,987   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,895   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,585   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
Web02 | 2.8.1411023.1 | Last Updated 24 Nov 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid