Let us talk about SQL SERVER – Database Worst Practices. Instead of writing best practices, I am going to write about few of the bad ones.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 12 of 31
Click here to get free chapters (PDF) in the mailbox Please read the Introductory Post before continue reading interview question and answers. List of all the Interview Questions and Answers Series blogs How does Using a Separate Hard Drive for Several Database Objects Improves Performance Right Away? A non-clustered index…
Read MoreSQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 11 of 31
Click here to get free chapters (PDF) in the mailbox Please read the Introductory Post before continue reading interview question and answers. List of all the Interview Questions and Answers Series blogs What is Difference between Table Aliases and Column Aliases? Do they Affect Performance? Usually, when the name of…
Read MoreSQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 10 of 31
Click here to get free chapters (PDF) in the mailbox Please read the Introductory Post before continue reading interview question and answers. List of all the Interview Questions and Answers Series blogs What Command do we Use to Rename a db, a Table and a Column? To Rename db sp_renamedb…
Read MoreSQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 9 of 31
Please read the Introductory Post before continue reading interview question and answers. List of all the Interview Questions and Answers Series blogs What is CHECK Constraint? A CHECK constraint is used to limit the values that can be placed in a column. The check constraints are used to enforce domain…
Read MoreSQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 8 of 31
Click here to get free chapters (PDF) in the mailbox Please read the Introductory Post before continue reading interview question and answers. List of all the Interview Questions and Answers Series blogs Which Command using Query Analyzer will give you the Version of SQL Server and Operating System? SELECT SERVERPROPERTY('Edition')…
Read MoreSQL SERVER – Introduction to expressor Datascript Modules
With the release of expressor 3.3, expressor software has added a significant new feature to the expressor Studio tool – the ability to easily extend functionality through the incorporation of reusable script files. A developer using expressor Studio may write these scripts and add them to any number of projects,…
Read More