Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – Correct Syntax for Stored Procedure SP

November 28, 2007

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…

SQLAuthority News – SQL Server Compact 3.5 Downloads and ReportViewer Visual Studio Download

November 25, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Download

SQL Server Compact 3.5 Books Online and Samples SQL Server Compact 3.5 is a small footprint in-process database engine that allows developers to build robust applications for Windows Desktops and Mobile Devices. This download contains the Books Online and Samples for SQL Server Compact 3.5 SQL Server Compact 3.5 for…

SQL SERVER – Upgrade Advise – From 2000 to 2005 or 2008

November 24, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, DBA

There has some good amount of discussion going on in SQL Server community about should we upgrade from SQL Server 2000 to SQL Server 2005 or wait for SQL Server 2008. I have received quite a few email and invitations to participate in forums on this topic. Instead of talking…

SQL SERVER – 2008 – November CPT5 New Improvement

November 23, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

CTP, SQL Download

The progress map of SQL Server 2008 is diagrammatically listed here. I am listing the new improvements here as list. Data Collection and Performance Warehouse for Relational Engine Service Broker Enhancements Registered Servers Enhancements Synchronous net-changes change tracking for SQL Server T-SQL IntelliSense Declarative Management Framework (DMF) Enhancements Geo-spatial Support…

SQL SERVER – Shrinking Truncate Log File – Log Full – Part 2

November 22, 2007

Pinal Dave

SQL

Shrinking Database, SQL Backup, SQL Log, SQL Restore, SQL Server

About a year ago, I wrote SQL SERVER – Shrinking Truncate Log File – Log Full. I was just going through some of the earlier posts and comments.