Oh, and also, the name in sys.types will never return varchar(max), nvarchar(max) or varbinary(max). They'll return varchar, nvarchar or varbinary. To see if it's max or a defined length, check...

Exists just checks whether or not the resultset returns a row. In your exists, there is no link between the subquery and the outer query. Hence the exists will return...

In that case, to figure this out you're going to need to figure out where it's getting called from. If that's the only query in the proc, then the processes...

Is that all that's in that proc? The deadlock graph refers to an update on Line 15.

Also, the deadlock details indicate that the processes both had exclusive locks and...

As far as I know, all backup logs (including the no_log) have to write into the tran log to indicate that a backup was done. I don't know if it...

sahoong (10/24/2008)

---

The Gurus,

This error message "2008-10-24 00:00:00.29 Backup BACKUP LOG WITH TRUNCATE_ONLY or WITH NO_LOG is deprecated. The simple recovery model should be used to...

They didn't have locks on the same key. If you look at the resource, you'll see that while the file and partition are the same, the hash of the key...

What is DISA Gold Disk and what is it supposed to do?

If you're intending that to be a generic script that can be used anywhere by anyone, you may want to add [ and ] around the index, schema and table...

When you generate the script, you can specify what version you want the script to target.

If cost is the concern, consider the 180 day trial of SQL 2005, or...

Why was the DB in emergency mode and what exactly did you do to it, from the beginning, step by step.

Can you please also look at the SQL error log...

The database size isn't related to performance directly. Increasing amounts of data in poorly indexed tables may be.

The first thing to realise is there there's no silver bullet to fix...

Please don't cross post. It just wastes people's time and fragments replies.

No replies to this thread please. Direct replies to:

http://www.sqlservercentral.com/Forums/Topic591095-8-1.aspx

Why were you doing a repair with data loss?

Access violations are usually the result of a bug in the product. To get a resolution for that, you'll have to contact...

It would probably be easier if you installed 2005 express at home and used that. To get a 2008 DB to 2005 you'll need to script the schema out and...