Thanks, everyone.

From what I understand the derived table is more effiecient.  It took me a while to understand them, though.  The instructor I had when working on my degree taught us...

Even though there are tons of plot holes, I thought "Minority Report" had some really cool technology.  It made me think a lot about how fast everything changes and how we...

Books Online says that the 'default language' setting is for new accounts. To change an existing session, you can use the command SET LANGUAGE before running the insert. 

#3 sounds very interesting. I love creating tools like scripts to make my job easier and it would be cool to create some tools that could be sold to other...

There are two places in Access that usually cause a form to open automatically: the AutoExec macro and the "Display Form/Page" property found under Tools -> StartUp.  Usually the Shift...

Sounds like you are doing it correctly. I was able to transfer just stored procs and functions to a different database with the settings you mentioned.

While in the DTS designer, save...

From 15seconds.com http://www.15seconds.com/faq/Data%20Access/767.htm

1: Store as a Float.

2: Store as a canonical string, i.e. YYYYMMDDHHNNSSmmm (separators optional). Perform explicit conversion to an from the database.

3: Store Year, Month, Day,...

I will definately add that to our maintenance.

Rebooting the two servers fixed the SQL Agent problems. I also had different issues with SQL Mail on another server and then a...

Update: make that sp_help_job not sp_helpjob.

I restarted SQL Server Agent on second server and now it is taking a long time to refresh and run sp_help_job but now can get...

Because the count function returns integers, the answer to math using integers is also an integer.  Run this script to see the difference:

declare @int1 integer

declare @int2 integer

select @int1 = 10,...

In Enterprise Manager, Expand "Support Services". There you will find a way to turn on the Full-Text service.

It doesn't hurt to delimit, but I think it would be a best practice to name the objects correctly to begin with. You can use underscores instead of spaces.

OK, use my explanation of convert to store the date with the time zeroed out in your insert or update statement.

insert into table2 (newDate)

select convert(varchar,oldDate,121)

from table1

I don't think you need nested queries at all. Please provide a script that creates all of the tables involved and inserts some sample data. I can't tell how to join...

The order of the items in the select list doesn't matter at all. DISTINCT applies to the row, not to the column when you do this (the statments will return...