June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Guidelines and Coding Standards Part – 1

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Best Practices, Database, Software Development, SQL Coding Standards, SQL Constraint and Keys, SQL Index, SQL Joins, SQL Scripts, SQL Stored Procedure
Use “Pascal” notation for SQL server Objects Like Tables, Views, Stored Procedures. Also tables and views should have ending “s”. Example: UserDetails Emails If you have big subset of table group than it makes sense to give prefix for this table group. Prefix should be separated by _. Example: Page_…
Read More

SQLAuthority Author Visit – Ahmedabad SQL Server User Group Meeting – September 2008

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, DBA, MVP, SQL Download, SQL Humor, SQL User Group, SQLAuthority Author Visit
On September 20, 2008 was one of the best day so far for Ahmedabad SQL Server User Group Meeting. We had two very interesting sessions by two SQL Server MVPs. SQL Server MVP Jacob Sebastian had began the meeting with very interesting introduction note. Along with many news Usergroup President…
Read More

SQL SERVER – 2008 – Fix Connection Error with Visual Studio 2008 – Server Version is not supported

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Database, Software Development, SQL Download, SQL Error Messages, SQL Server Management Studio, SQL Service Pack
While attending conference SQLAuthority Author Visit – Microsoft Student Partner Conference, some developers informed me that SQL SERVER 2008 cannot be connected to Visual Studio 2008 and error displays as MS does not support SQL Server version. I was surprised initially as I could not believe that two MS products are…
Read More

SQLAuthority Author Visit – Ahmedabad User Group Meeting September 2008

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, DBA, MVP, SQL User Group, SQLAuthority Author Visit
Today is third Saturday of the Month and every third Saturday we have Ahmedabad User Group Meeting. Our user group is growing and getting interesting. Everybody who attended last months User Group (UG) Meeting realized that how important it is to attend UG meetings. UG President Jacob Sebastian (SQL Server…
Read More

SQL SERVER – 2008 – Interview Questions and Answers – Part 8

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks
Data Warehousing, Database, SQL Data Storage, SQL Function, SQL Index, SQL Scripts, SQL Server DBCC, SQL Utility
Click here to get free chapters (PDF) in the mailbox SQL SERVER – 2008 – Interview Questions and Answers Complete List Download What is Data Compression? In SQL SERVE 2008 Data Compression comes in two flavors: Row Compression Page Compression Row Compression Row compression changes the format of physical storage…
Read More

SQL SERVER – 2008 – Interview Questions and Answers – Part 7

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks
Database, SQL Error Messages, SQL Scripts, SQL Server Security, SQL Utility
Click here to get free chapters (PDF) in the mailbox SQL SERVER – 2008 – Interview Questions and Answers Complete List Download How can we rewrite sub-queries into simple select statements or with joins? Yes we can write using Common Table Expression (CTE). A Common Table Expression (CTE) is an…
Read More

SQL SERVER – 2008 – Interview Questions and Answers – Part 5

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks
Database, SQL Scripts, SQL Stored Procedure, SQL Utility
Click here to get free chapters (PDF) in the mailbox SQL SERVER – 2008 – Interview Questions and Answers Complete List Download What command do we use to rename a db, a table and a column? To rename db sp_renamedb 'oldname' , 'newname' If someone is using db it will…
Read More