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

Articles: 16, Technical Blogs: 15

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating: 3.95

Database Development
	Database Worst Practices – New Town and New Job and New Disasters 14 Jul 2011 Updated: 14 Jul 2011 Rating: 4.64/5 Votes: 15 Popularity: 5.17 Licence: CPOL Views: 21,295 Bookmarked: 21 Downloaded: 0 Please Sign up or sign in to vote. 5 Database Worst Practices which can be fatal to any business
SQL Server	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 21 Aug 2007 Updated: 21 Aug 2007 Rating: 1.69/5 Votes: 16 Popularity: 1.82 Licence: Not specified Views: 77,241 Bookmarked: 23 Downloaded: 0 Please Sign up or sign in to vote. 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 - 2005 - Introduction and Explanation to sqlcmd 6 Sep 2007 Updated: 6 Sep 2007 Rating: 3.75/5 Votes: 7 Popularity: 3.17 Licence: CPOL Views: 38,611 Bookmarked: 23 Downloaded: 0 Please Sign up or sign in to vote. SQL SERVER - 2005 - Introduction and Explanation to sqlcmd
	SQL SERVER - 2005 - Generate Script with Data from Database - Database Publishing Wizard 16 Nov 2007 Updated: 16 Nov 2007 Rating: 4.89/5 Votes: 14 Popularity: 5.45 Licence: CPOL Views: 101,731 Bookmarked: 40 Downloaded: 0 Please Sign up or sign in to vote. SQL SERVER - 2005 - Generate Script with Data from Database - Database Publishing Wizard
	SQL SERVER - Data Warehousing Interview Questions and Answers Complete List Download 29 Jul 2007 Updated: 29 Jul 2007 Rating: 3.48/5 Votes: 11 Popularity: 3.62 Licence: CPOL Views: 48,712 Bookmarked: 30 Downloaded: 0 Please Sign up or sign in to vote. I tried to accommodate all of them in the 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 to at your convenience.
	SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database 3 Sep 2008 Updated: 3 Sep 2008 Rating: 4.88/5 Votes: 32 Popularity: 7.20 Licence: CPOL Views: 221,815 Bookmarked: 73 Downloaded: 0 Please Sign up or sign in to vote. SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database
	SQL SERVER - 2008 - Creating Full Text Catalog and Full Text Search 10 Sep 2008 Updated: 10 Sep 2008 Rating: 4.43/5 Votes: 15 Popularity: 4.93 Licence: CPOL Views: 96,951 Bookmarked: 35 Downloaded: 0 Please Sign up or sign in to vote. First article on topic - SQL SERVER - 2008 - Creating Full Text Catalog and Full Text Search
	SQL Server 2008 Interview Questions and Answers 19 Sep 2008 Updated: 19 Sep 2008 Rating: 3.55/5 Votes: 19 Popularity: 4.53 Licence: CPOL Views: 246,042 Bookmarked: 52 Downloaded: 0 Please Sign up or sign in to vote. A Big Downloadable List of SQL Server 2008 Questions and Answers
	Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup 13 Oct 2009 Updated: 13 Oct 2009 Rating: 4.00/5 Votes: 3 Popularity: 1.91 Licence: CPOL Views: 22,954 Bookmarked: 10 Downloaded: 0 Please Sign up or sign in to vote. Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup
	SQL SERVER – Order of Columns in Update Statement Does not Matter 9 Mar 2010 Updated: 9 Mar 2010 Rating: 2.91/5 Votes: 8 Popularity: 2.63 Licence: CPOL Views: 18,721 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. SQL SERVER – Order of Columns in Update Statement does not matter
	Limitations of the View Many and Many 13 Oct 2010 Updated: 12 Oct 2010 Rating: 4.50/5 Votes: 2 Popularity: 1.35 Licence: CPOL Views: 12,822 Bookmarked: 7 Downloaded: 0 Please Sign up or sign in to vote. Limitations of the View Many and Many
	SQL Server PERFORMANCE with Wait Types and Queues 20 Apr 2011 Updated: 20 Apr 2011 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 12,780 Bookmarked: 5 Downloaded: 1 Please Sign up or sign in to vote. A Quick Guide to Find Potential Peformance Issue
	SQL SERVER - 2005 T-SQL Paging Query Technique Comparison (OVER and ROW_NUMBER()) - CTE vs. Derived Table 17 Jun 2007 Updated: 17 Jun 2007 Rating: 1.80/5 Votes: 6 Popularity: 1.40 Licence: Not specified Views: 32,600 Bookmarked: 27 Downloaded: 0 Please Sign up or sign in to vote. SQL SERVER - 2005 T-SQL Paging Query Technique Comparison (OVER and ROW_NUMBER()) - CTE vs. Derived Table
Programming Languages
C++	SQL SERVER – Identifying guest User using Policy Based Management 27 Feb 2012 Updated: 27 Feb 2012 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 21,812 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. Identifying guest User using Policy Based Management
SQL	Computed Columns - Index and Performance 24 Aug 2010 Updated: 24 Aug 2010 Rating: 5.00/5 Votes: 13 Popularity: 5.57 Licence: CPOL Views: 35,457 Bookmarked: 20 Downloaded: 0 Please Sign up or sign in to vote. A Finale of Series discussing Computed Columns, Storage and Performance
Web Development
ASP.NET	SQL SERVER - 2005 Best Practices Analyzer Tutorial - Sample Example 10 Jul 2007 Updated: 10 Jul 2007 Rating: 3.74/5 Votes: 12 Popularity: 4.04 Licence: Not specified Views: 51,310 Bookmarked: 46 Downloaded: 0 Please Sign up or sign in to vote. SQL SERVER - 2005 Best Practices Analyzer Tutorial - Sample Example

Average blogs rating: 4.68

All Topics
	SQL SERVER – Solution – Puzzle – SELECT * vs SELECT COUNT() [Technical Blog] 17 Jun 2011 Updated: 17 Jun 2011* Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: CPOL Views: 16,561 Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. 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.
Database Development
SQL Server	SQL SERVER – Database Properties – Number of Users [Technical Blog] 26 Dec 2011 Updated: 26 Dec 2011 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 29,768 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. SQL SERVER – Database Properties – Number of Users
	SQL SERVER – A Puzzle – Swap Value of Column Without Case Statement [Technical Blog] 11 Jun 2012 Updated: 11 Jun 2012 Rating: 3.00/5 Votes: 2 Popularity: 0.90 Licence: CPOL Views: 16,290 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Swap Value of Column Without Case Statement in SQL Server
	SQL Server – Find Column Used in Stored Procedure – Search Stored Procedure for Column Name [Technical Blog] 17 Jul 2012 Updated: 13 Aug 2012 Rating: 4.10/5 Votes: 8 Popularity: 3.70 Licence: CPOL Views: 50,985 Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. How to find column used in a stored procedure
	SQL SERVER – 2012 – Summary of All the Analytic Functions – MSDN and SQLAuthority [Technical Blog] 26 Nov 2011 Updated: 26 Nov 2011 Rating: 4.20/5 Votes: 2 Popularity: 1.26 Licence: CPOL Views: 28,420 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. SQL SERVER – 2012 – Summary of All the Analytic Functions – MSDN and SQLAuthority
	SQL Server – Puzzle – Statistics are not Updated but are Created Once [Technical Blog] 4 Jun 2011 Updated: 4 Jun 2011 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 8,930 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. SQL Server – Puzzle – Statistics are not Updated but are Created Once
	SQL SERVER – Database Worst Practices – New Town and New Job and New Disasters [Technical Blog] 22 Jul 2011 Updated: 22 Jul 2011 Rating: 4.50/5 Votes: 2 Popularity: 1.35 Licence: CPOL Views: 8,380 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. Database worst practices in SQL Server
	SQL SERVER – Bad Practice of Using Keywords as an Object Name – Avoid Using Keywords as an Object [Technical Blog] 10 Dec 2011 Updated: 10 Dec 2011 Rating: 5.00/5 Votes: 3 Popularity: 2.39 Licence: CPOL Views: 23,661 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. Avoid Using Keywords as an Object
	SQL SERVER – SmallDateTime and Precision – A Continuous Confusion [Technical Blog] 5 Jun 2012 Updated: 5 Jun 2012 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 14,041 Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. SQL Server - SmallDateTime and Precision - a continuous confusion
	SQL Server – Primary Key and NonClustered Index in Simple Words [Technical Blog] 12 Feb 2013 Updated: 12 Feb 2013 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 25,870 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Primary Key and non-clustered index in simple words
	SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – System and Time Data Types – Day 16 of 35 [Technical Blog] 17 Aug 2011 Updated: 17 Aug 2011 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 15,200 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. Tips from the SQL Joes 2 Pros Development Series – System and Time Data Types
	SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Many to Many Relationships – Day 8 of 35 [Technical Blog] 8 Aug 2011 Updated: 8 Aug 2011 Rating: 4.89/5 Votes: 3 Popularity: 2.33 Licence: CPOL Views: 18,481 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. SQL SERVER – Tips from the SQL Joes 2 Pros Development Series
	SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Efficient Query Writing Strategy – Day 4 of 35 [Technical Blog] 5 Aug 2011 Updated: 8 Aug 2011 Rating: 4.83/5 Votes: 3 Popularity: 2.31 Licence: CPOL Views: 15,051 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Tips from the SQL Joes 2 Pros Development Series – Efficient Query Writing Strategy
Programming Languages
Java	SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Easy Introduction to CHECK Options – Day 24 of 35 [Technical Blog] 24 Aug 2011 Updated: 24 Aug 2011 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 14,980 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. SQL SERVER – Tips from the SQL Joes 2 Pros Development Series
SQL	SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Overridding Identity Fields – Tricks and Tips of Identity Fields – Day 9 of 35 [Technical Blog] 9 Aug 2011 Updated: 9 Aug 2011 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 15,250 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. SQL SERVER – Tips from the SQL Joes 2 Pros Development Series

Average tips rating:

No tips have been posted.

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.

pinaldave

Founder http://blog.SQLAuthority.com

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.

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

Articles: 16, Technical Blogs: 15

Average article rating: 3.95

Database Development

Programming Languages