Also, why a cursor? Unless I've missed something, the entire thing, cursor and all can be replaces by this:

UPDATE t1 SET

t1.Sat = CASE WHEN t2.Day_To_Receive = 'Saturday' THEN 1 ELSE...

You need some brackets in the exec statement.

Change

EXEC @CMD

to

EXEC (@CMD)

No.

If you have no backup at all, even the transaction log won't have that information in it as it auto-truncates regularly. Hence no log reader tool will work. There's no...

Exactly the same as for any other query.

Plan gets created when...

For what it's worth, there is virtually nothing you can do in SQL to stop an administrator from doing what he wants with the database.

If, after you've got the checkDB results, you're not 100% sure what they mean or what you need to do, post the full output of checkDB and someone will help...

My guess is that someone altered the starting size of tempDB. If I recall, such changes only happen when SQL restarts.

You should be able to start SQL if you use...

Mohit (4/27/2009)

---

In my experiment I populated it with 1000 rows; using that sample code it was about 2300 reads, and using adjust code that is just selecting the rows it...

Please read through this - Managing Transaction Logs[/url]

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

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic705013-359-1.aspx

This query, when run in the context of the DB in question, will show you where all the files associated with that database are.

select name, filename from sysfiles

Major and minor version of SQL as well as the CPU architecture. The 8.00.2039 indicates SQL 2000...

Tables, views, functions and procedures are all stored within the database file, hence there's no path to them. Or are you looking for the location of the SQL database files...

Mohit (4/26/2009)

---

any recommendations I can do from SQL Side to improve it? I am getting TempDB relocated to a new SAN hdd next week to give tempdb it's own...

johny (4/26/2009)

---

To GilaMonster:

It should take a same time for all the records when using NVARCHAR.

But now the records ending with '9' take much more time than the non-9 records.

This is...