Click here to Skip to main content
15,897,273 members

Technical Blogs


1. SQL Server – Primary Key and NonClustered Index in Simple Words
Primary Key and non-clustered index in simple words
Database Development » SQL Server »
pinaldave Updated: 12 Feb 2013
Rating: ( (No votes))
2. SQL Server – Find Column Used in Stored Procedure – Search Stored Procedure for Column Name
How to find column used in a stored procedure
Database Development » SQL Server »
pinaldave Updated: 13 Aug 2012
Rating: 4.10/5 ( (8 votes))
3. SQL SERVER – A Puzzle – Swap Value of Column Without Case Statement
Swap Value of Column Without Case Statement in SQL Server
Database Development » SQL Server »
pinaldave Updated: 11 Jun 2012
Rating: 3.00/5 ( (2 votes))
4. SQL SERVER – SmallDateTime and Precision – A Continuous Confusion
SQL Server - SmallDateTime and Precision - a continuous confusion
Database Development » SQL Server »
pinaldave Updated: 5 Jun 2012
Rating: 5.00/5 ( (1 vote))
5. SQL SERVER – Database Properties – Number of Users
SQL SERVER – Database Properties – Number of Users
Database Development » SQL Server »
pinaldave Updated: 26 Dec 2011
Rating: 5.00/5 ( (1 vote))
6. SQL SERVER – Bad Practice of Using Keywords as an Object Name – Avoid Using Keywords as an Object
Avoid Using Keywords as an Object
Database Development » SQL Server »
pinaldave Updated: 10 Dec 2011
Rating: 5.00/5 ( (3 votes))
7. SQL SERVER – 2012 – Summary of All the Analytic Functions – MSDN and SQLAuthority
SQL SERVER – 2012 – Summary of All the Analytic Functions – MSDN and SQLAuthority
Database Development » SQL Server »
pinaldave Updated: 26 Nov 2011
Rating: 4.20/5 ( (2 votes))
8. SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Easy Introduction to CHECK Options – Day 24 of 35
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series
Programming Languages » Java » Java SE
pinaldave Updated: 24 Aug 2011
Rating: 5.00/5 ( (1 vote))
9. SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – System and Time Data Types – Day 16 of 35
Tips from the SQL Joes 2 Pros Development Series – System and Time Data Types
Database Development » SQL Server »
pinaldave Updated: 17 Aug 2011
Rating: 5.00/5 ( (1 vote))
10. SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Overridding Identity Fields – Tricks and Tips of Identity Fields – Day 9 of 35
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series
pinaldave Updated: 9 Aug 2011
Rating: 5.00/5 ( (1 vote))
11. SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Efficient Query Writing Strategy – Day 4 of 35
Tips from the SQL Joes 2 Pros Development Series – Efficient Query Writing Strategy
Database Development » SQL Server »
pinaldave Updated: 8 Aug 2011
Rating: 4.83/5 ( (3 votes))
12. SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Many to Many Relationships – Day 8 of 35
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series
Database Development » SQL Server »
pinaldave Updated: 8 Aug 2011
Rating: 4.89/5 ( (3 votes))
13. SQL SERVER – Database Worst Practices – New Town and New Job and New Disasters
Database worst practices in SQL Server
Database Development » SQL Server »
pinaldave Updated: 22 Jul 2011
Rating: 4.50/5 ( (2 votes))
14. SQL SERVER – Solution – Puzzle – SELECT * vs SELECT COUNT(*)
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.
All Topics » »
pinaldave Updated: 17 Jun 2011
Rating: 5.00/5 ( (2 votes))
15. SQL Server – Puzzle – Statistics are not Updated but are Created Once
SQL Server – Puzzle – Statistics are not Updated but are Created Once
Database Development » SQL Server »
pinaldave Updated: 4 Jun 2011
Rating: 5.00/5 ( (1 vote))