The script on the link below produces a detailed analysis of the file size information for all databases on a SQL Server.

Get Server Database File Information

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89058

Totals for the following are...

Update tbl1

set

address = tbl2.address

from

tbl1

join

tbl2

on tbl1.cuid = tbl2.cuid

Your code is more than likely for MySQL, not for SQL Server.

You would probably get better help posting you question o a forum where that answer MySQL question, like http://www.dbforums.com/

You want to have 31 days even for the months that have fewer than 31 days?

Probably the simplest solution would be to build a dynamic SQL statement. You are much more likely to get an optimal query plan, than with what you are trying.

The only reasons for them to ask your salary history are reasons that are not in your interest. They might want to low-ball your salary offer. They might...

I believe that the AES encryption methods are the modern standard for symmetric key encryption, and AES-256 is approved by the US Government for Top Secret information.

270K/sec sounds pretty good.

That means it can lookup 2GB/sec of data pages, so it is capable of fast scans of fairly large tables.

This is the reason that when I join a new company, I go out of my way to learn the names of and be nice to the building maintenance guys,...

You need to understand how NULL works.

The StatusID columns with a value of null will fail this test:

StatusID <> '72HOURRESIGNATION'

Try this:

( StatusID <> '72HOURRESIGNATION' or StatusID is null )

It will obviously depend on the speed of your processors, memory, and front-side bus.

I have seen speeds in excess of 100K pages/sec on servers with fairly average specs. I...

You can trap the error with a TRY/CATCH block, and return the error that you want.

The trouble with checksum is that a difference in the checksum means that the rows are different, but identical checksums do not mean that they are the same.

It is not...

A user defined function cannot use dynamic SQL.

Jeremy (4/7/2008)

---

how about

Create table #t1(col1 int primary key, col2 int, col3 int)

Insert INTO #t1

Select 1,1,1

union all Select 2,1,2

union all Select 3,1,3

Create table #t2(col1 int primary key, col2 int ,...