That's a difficult one to answer, Gail. I have been using Windows Authentication, with my first name as User (with Administrator rights) and a blank password.

Not what are you logging...

Well, the on-disk page structure and the in memory page structure are identical (afaik) so it should be enough to take 2 very large tables, with lots of columns in...

I've never heard that myself. Got a source? I'd like to check it out.

afaik, the position of columns within the data page has no impact on speed of searching. If it does,...

What account is SQL running under? (check services, from administrative tools.)

I believe it is best to have frequently searched fields of a static size early in the table

Why do you think that?

You can change the order of columns in...

And was there anything in the application event log from sql server at the time you tried to start it?

I saw your reply, but the answer to my question isn't there. When you tried to start SQL from the services manager and it wouldn't start, what error or message...

Both failed to start.

With what error? and what's in the event log (application event log) for that time?

Let me guess, no database backup?

Pleasure. I've had the problem a few times.

What happens is that both sides of the expression must be of the same type. If the column is varchar and the parameter...

You want to clear out inactive transactions from the log?

If the database is in simple recovery mode, the log will truncate itself automatically after a checkpoint. If you're using full...

the ldf is the transaction log. It's the record of what modifications have been made and isn't intended to be read.

What info are you trying to get? Why do you...

Which will work if you have an identity column called recordID

Inherently, SQL keeps no record of the 'last' row. If there's an identity column or a last inserted time...

Something I discovered yesterday is that IF resets @@rowcount.

The following code enters the if, but returns 0 as the rowcount.

select

* from

You also don't need to drop and recreate an index when you alter a column.

A bookmark lookup occurs when SQL uses a nonclustered index to locate the rows required for a query, but the index does not contain all the columns needed by the...