Any indexes on those tables?

Is the distinct necessary?

Do they have a reason for this decision?

The cost of...

Why does it have to be a single table?

Have you considered table partitioning (SQL 2005 feature)

How wide are the rows?

What indexes do you have and what are the common queries?

Don't shrink the databases. It causes massive fragmentation of indexes.

You can, as a once off operation, shrink the log down. If, however the log file needs to be that...

madhu.arda (11/9/2008)

I would like to test the following recovery scenario:

1.There is some activity has been done on database 'abc' from 3:00pm to 3:10pm

2.stop sql server delete ldf file of...

rosh (11/9/2008)

GilaMonster (11/8/2008)

Null won't cause a divide by zero. Anything divided by null (or added to null or multiplied by null, ...)...

Bouncing?

UPDATE t SET t.sno = s.sno

FROM t INNER JOIN s ON s.sid=t.sid

WHERE t.sno IS NULL

Access or SQL Server?

Can you post the table definitions, an example of the data that would be inserted and the end results that you want?

A calculated column can only refer to columns within the same table.

From Books online

A computed column is a virtual column that is not physically stored in the table but is...

For parameters it'll look more like this.

SELECT [Lesson_Schedule].[Lesson_Date], [Lesson_Time].[Lesson_Time], [Student].[Student_Id],

[Student].[First_Name], [Student].[Last_Name], [Lesson_Type].[Duration_Time]

FROM Student

INNER JOIN Booking ON [Student].[Student_Id]=[Booking].[Student_Id]

INNER JOIN Staff ON [Staff].[Staff_Id]=[Booking].[Staff_Id]

...

Can you post the code for the function that gets the employee codes please, along with the code for any functions it calls. Also please post the table definition.

I'd say stored proc. Have the form call the proc when it's saved and have the proc do the inserts into the two tables.

What's the intention with this line? SQL, unlike Access, doesn't prompt for data entry. This is...