Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – UDF – Validate Positive Integer Function – Validate Natural Integer Function

September 18, 2007

Few days ago I wrote SQL SERVER – UDF – Validate Integer Function. It was very interesting to write this and developers at my company started to use it. One Jr. DBA modified this function to validate only positive integers. I will share this with everybody who are interested in…

SQLAuthority News – NASDAQ Uses SQL Server 2005 – Reducing Costs through Better Data Management

September 17, 2007

Pinal Dave

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

Data Warehousing, Database, DBA, SQL Server

I just came across PDF published by Microsoft to promote SQL Server 2005. I find few things very interesting. I will list them here.

NASDAQ

SQL SERVER – Difference Between UPDATE and UPDATE()

September 17, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

What is the difference between UPDATE and UPDATE()? UPDATE is syntax used to update the database tables or database views. USE AdventureWorks ; GO UPDATE Production.Product SET ListPrice = ListPrice * 2; GO UPDATE() is used in triggers to check update/insert to the database tables or database views. Returns a…

SQLAuthority News – Active Directory Integration Sample Script

September 16, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download, SQL Utility

A sample script that enables you to extract a list of computer names from your custom SQL Server database and add them to an Active Directory security group. The security group can then be referenced in the Agent Assignment and Failover Wizard to automate agent assignments to Management Servers. 1.…

SQL SERVER – 2005 – List All The Constraint of Database – Find Primary Key and Foreign Key Constraint in Database

September 16, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Scripts, SQL System Table

Following script are very useful to know all the constraint in the database. I use this many times to check the foreign key and primary key constraint in database. This is simple but useful script from my personal archive. USE AdventureWorks; GO SELECT OBJECT_NAME(OBJECT_ID) AS NameofConstraint, SCHEMA_NAME(schema_id) AS SchemaName, OBJECT_NAME(parent_object_id)…

SQLAuthority News – Book Review – Pro T-SQL 2005 Programmer’s Guide (Paperback)

September 15, 2007

Pinal Dave

SQLAuthority News

SQL Server, SQLAuthority Book Review

Pro T-SQL 2005 Programmer’s Guide (Paperback) Book Review

SQLAuthority News – Random Article from SQLAuthority Blog

September 14, 2007

Pinal Dave

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

SQL Random

It has been wonderful writing on this blog. Many times I visit my older articles and read them. One of my favorite feature on WordPress.com (where I host my blog) is Random Article Feature. I use it quite often to land on random page on my blog. It is really…