All Articles - SQL Authority with Pinal Dave

SQL SERVER – 2005 – List All Stored Procedure in Database

November 27, 2007

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.

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)

SQLAuthority News – SQL Server 2008 Community Technology Preview (CTP) Download Now Available

November 19, 2007

Pinal Dave

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

CTP, SQL Download

Download the latest SQL Server 2008 Community Technology Preview (CTP) and try out the latest features of SQL Server 2008! The SQL Server development team uses your CTP feedback to help refine and enhance product features. Download it today and send your feedback. Microsoft SQL Server 2008, the next release…

SQLAuthority News – Job Opportunity in Ahmedabad, India to Work with Technology Leaders Worldwide – SQL Server, ColdFusion, ASP.NET

November 18, 2007

Pinal Dave

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

Data Warehousing, Database, DBA, SQL Jobs

If you have one or more years of experience in any web based programming language (.NET, ColdFusion, PHP) and interested in SQL Server as well willing to locate Ahmadabad, India. Please send me your resume, if selected you may get chance to work with one of the most progressing industry…