SQL Archives - Page 471 of 519 - SQL Authority with Pinal Dave

SQL SERVER – Q and A with Database Administrators

December 2, 2007

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Database, DBA, Software Development, SQLAuthority Author Visit

I have been in India for more than a month now, as I am leading a very large outsourcing project. We have conducted few interviews since the project required more Database Administrators and Senior Developers. I am listing few of the questions discussed during all the interviews. The whole event…

SQL SERVER – Sharpen Your Skills: Brush up on FILLFACTOR, ISNULL, NULLIF, and % as wildcard and operator

December 1, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, DBA

Read my article in SQL Server Magazine December 2007 Edition I will be not able to post complete article here due to copyright issues. Please visit the link above to read the article. [Articles are relocated so links are disabled] Reference : Pinal Dave (https://blog.sqlauthority.com)

SQLAuthority News – Download SQL Server 2005 Books Online (September 2007)

November 30, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Download

Download an updated version of Books Online for Microsoft SQL Server 2005. Books Online is the primary documentation for SQL Server 2005. The September 2007 update to Books Online contains new material and fixes to documentation problems reported by customers after SQL Server 2005 was released. Refer to “New and…

SQL SERVER – Database Interview Questions and Answers Complete List

November 29, 2007

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Data Warehousing, Database, DBA, Software Development

Update: I have updated this article series and newly updated article series is over here. If you are subscribed to my blog you will know that I receive request to send Database or SQL Server very frequently. Following is list of articles of my questions and answers series. Download SQL…

SQL SERVER – Correct Syntax for Stored Procedure SP

November 28, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure

Just a day ago, I received interesting question about correct syntax for Stored Procedure. Many readers of this blog will think that it is very simple question. The reason this is interesting is the question behavior of BEGIN … END statements and GO command in Stored Procedure. Let us first…

SQL SERVER – 2005 – List All Stored Procedure in Database

November 27, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure

Run following simple script on SQL Server 2005 to retrieve all stored procedure in database. SELECT * FROM sys.procedures; This will ONLY work with SQL Server 2005. Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – Rules of Third Normal Form and Normalization Advantage – 3NF

November 26, 2007

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Data Warehousing, Database, DBA

I always ask question about Third Normal Form in interviews I take. Q. What is Third Normal Form and what is its advantage? A. Third Normal Form (3NF) is most preferable normal form in RDBMS. Normalization is the process of designing a data model to efficiently store data in a…