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...

This the one you're looking for? Used in a select statement, so you can check the dates of all stats in the system with a single query.

STATS_DATE

...

The SELECT returns at most a single row for every entry in the IN clause.

Yes, but how many enteries do you typically have in the IN clause? There comes a...

That's still going to give an error, from the parsing of the USE statement 

Could not locate entry in sysdatabases for database 'MyDB'. No entry found with that name....

The join order does not affect performance. The query optimiser will reorder the join to find the cheapest plan possible. I think it's been this way since SQL 7

I tried...

SELECT t0.col1,

t0.col2,

t0.col3,

t0.col4,

t0.col5,

t0.col6,

t0.col7,

t0.col8

FROM dbo.table1 t0

WHERE (t0.col8 IN (?))

That select will table scan if the number of records returned exceeds more than about 1% of the table. I can't tell whether the in...

Please don't ever run ShrinkDatabase on a production database without a very, very good reason. All you're going to achieve is to fragment all your indexes badly and force the...

Perhaps query hints are in order. I'll see what I can do.

Recomended practice is to never add query hints unless you know exactly what you're doing and why you're adding...