Pinal Dave - SQL Server Performance Tuning Expert

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

November 26, 2007

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

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.

SQL SERVER – Generate Incremented Linear Number Sequence

November 21, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server

Just a day ago, I received interesting question on this blog. Read original question here. This is very good question and after reading this question I quickly wrote small script as answer. Let us see the question and answer together.

Q. How can we generate incremented linear number in sql server as in oracle we generate in via sequence?

SQL SERVER – Sharpen Your Skills: Joins, Groupings, and Data Types

November 20, 2007

Pinal Dave

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

Database, DBA

Read my article in SQL Server Magazine November 2007 Edition [Articles are relocated so links are disabled] Reference : Pinal Dave (https://blog.sqlauthority.com)