If you select from two copies of the table joined to each other on issue number and sequence, you can get the sequential open and close dates and the days...

I guess you're going to have to run the scripts yourself and see if you can get more details.

Sounds to me like the book is probably wrong.

I must be misunderstanding something in your post. You list two different queries, and you seem to be listing the reads for both queries. They aren't the same...

As with many things, "it depends". In the situation you outlined, manipulating the values in SQL makes sense.

What you might try, if you can, is duplicating the functionality in...

You could, but it's generally a bad idea to do that on a production server during the day.

You should have an error message on the job that failed. Check...

It doesn't matter so far as I know. Try a test like this:

create table dbo.NullTest1 (

ID int identity primary key,

Col1 int null,

Col2 int null,

Col3 int null,

Col4 int null,

Col5 int...

In Management Studio, right-click on the job, and select History. To the left of the job in the history, it will have a red symbol indicating job failure. ...

The order of rows in a table isn't supposed to matter in a relational database. You have to query it, using Order By, to force the rows to have...

Procs is a pretty standard way to do that kind of thing.

If you want to call a proc in one database from another database, you use a three-part-name. Four-part-name...

Basically, you need three copies of the database.

One is the production version. That's the one that the web page connects to.

Another is the dev version. That's...

I would expect that proc to run quite rapidly. It's not doing a lot of work. Just a simple insert.

How fragmented is the table's clustered index? How...

Is Page_ID an identity field?

Derek Dongray (2/24/2009)

---

Alvin Ramard (2/24/2009)

---

Yesterday was an interesting day on here. I don't think any of the posters were picked on, except for a quick reference to a White.house...

Yeah, I just love tech support calls when I have to make them. I had to define "POST" to someone last night, because my computer at home won't do...