SET DATEFIRST 5

Doing the actual restore operation is the only sure shot way of confirming whether the backup will work or not?

You could compress the backup and save time if u need...

I meant returning a set of records using a select and a update operation using the same query.

Seems i did'nt clearly understand the OP's question.

Heartily Agree.

BTW do we get points for "deleted" post ? :hehe:

[font="Verdana"][/font]You cant do the Select & Update in a single query.

Maybe you can write a small proc where you can do the update and then select the data.

[font="Arial"][font="Arial Narrow"][/font][/font]

You can use group by in views. Check out the example in BOL. It contains group by.

Your backup size will be much less than your db size.

A "little" backup is not possible in SQL. You could take file backups and restore them but i think thats...

Use the Group BY clause

-- sum of each ID for all yrs

Select ID,SUM(X) as Total from table Group BY ID

-- sum of each ID yr wise

Select ID,SUM(X) as Total from...

I have a project in SQL 2008 to take advantage of spatial data. All the rest of the projects are in SQL 2005.

Projects running on older version of SQL take...

On the other hand you want to keep your table design as simple as possible so as to avoid writing complex queries to do even the simple things.

Stored procs can...

Clicked on the wrong radio button :crying:

Char data type will use 7 bytes of space even if the length of the string u r storing is 3 - 3 + 4 space. In the...

To avoid redundancy in the tables. In the ex:- you have mentioned course & course_module tables.

If your length is fixed and that man characters ( 7 in this case) will always be soted in the column then its better to use char data type. You...

Thanks.