Take a look at Joe Celko's SQL Programming Style. There is a "look inside" that allows a preview.

http://www.amazon.com/Celkos-Programming-Kaufmann-Management-Systems/dp/0120887975/ref=pd_bbs_3/104-1067053-7238322?ie=UTF8&s=books&qid=1175111114&sr=1-3

Regarding " For example I believe that all fields should be aliased...

Date and Time of the install of a patch is available in the Windows System Event Log. MS provides a command-line tool, which is part of the Windows 2000 Resource...

Perhaps this will work:

select Employee.EmpName

, COALESCE ( EmployeeBudgets.BudgetAmount, 0 ) as BudgetAmount

, COALESCE ( EmployeeExpenses.ExpenseAmt, 0 ) as ExpenseAmt

, COALESCE ( EmployeeBudgets.BudgetAmount, 0 )

- COALESCE ( EmployeeExpenses.ExpenseAmt, 0...

Space information is not maintained in real-time but only when indicies are rebuild or "dbcc updateusage" is run.

"dbcc updateusage" can be also be invoked by running:

exec sp_spaceused @updateusage = 'true'

Start with a joke (sort of)

Q: What is the best kind of rock to pound in screws ?

A: Granite

The correct answer is of course, not to use a rock...

You are correct - Using DTS, you cannot update table rows based on rows in an excel spreadsheet.

Instead, use DTS to import the Excel spreadsheet into a table, and then...

The message appears quite clear that the columns named 'Level1' and 'Lvl2' are not valid.

This can mean that the tables/views do not contain these columns or that your login does...

SQL Server Books Online had an update in January 2005, which can be downloaded from:

http://www.microsoft.com/downloads/details.aspx?familyid=a6f79cb1-a420-445f-8a4b-bd77a7da194b&displaylang=en

The MSDN SQL Server documentation for RESTRICTED_USER agrees with Jo Mong's post.

http://msdn2.microsoft.com/en-us/library/aa933082(SQL.80).aspx

"I've found some traces running on our server. I'd like to find out where they are saving the file or table to. how can I do this? "

select...

From Books on Line:

SQL Server requires that the WITH NORECOVERY option be used on all but the final RESTORE statement when restoring a database backup and multiple transaction logs, or...

Joe Celko's SQL for Smarties: Advanced SQL Programming is a must read !!!

http://www.amazon.com/exec/obidos/tg/detail/-/1558605762/sr=1-2/ref=sr_1_2/103-5600526-3364605?v=glance&s=books

In response to post by Zoran Kovacevic on 3/2/2007 2:56:00 PM CST:

<Have a table with Type and Quantity field like (about 10,000 rec.)and try to make table like

         TYPE      INPUT       ...

I took a look at a cluster that has 3 SQL Server 2000 instances running and found 4 cluster resource groups:

"Cluster group" containing resources Cluster Name, Cluster IP, MSDTC and...

"I have recently heard that joining to the largest table last in a query involving several tables can have a performance gain.

Is this true? If so how does this increase...

Would not a foreign key contraint be easier ?

Assuming that ORDER_TYPE_ID and ORDER_SUB_TYPE_ID are the primary key of table ORDER_SUB_TYPE_LOOKUP:

Alter table ORDER_MASTER

add constraint ORDER_SUB_TYPE_LOOKUP_FK_ORDER_MASTER

foreign key (ORDER_TYPE_ID ,ORDER_SUB_TYPE_ID )

references ORDER_SUB_TYPE_LOOKUP

go