LMAO.....

That's generally the way I've seen developers learn to pay attention to DBA's

I call it "letting that ole dog knaw a little", and you'd be surprised how many times they...

Yes, it would. However, it would also be removed if run successfully through a manual start. Are you sure it ran successfully when you kicked it off manually?

And Has it...

IndexID of 0 means no index, heap structure from table

IndexId of 1 is the clustered index

IndexId of 2-254 are nonclustered indexes

IndexId of 255 is entry for text or image values...

Refresh your view, and see if it goes away....

Rows and Rowcnt hold the same definition. Rows was added for backwards compatibility.

Also, in EM, when I right-click properties a table, it tells me the number of records in the table. Does anyone know how this number is generated?

That number comes from...

quote:

You would be better off with 6 smaller drives instead of 3 larger drives. your capacity would be higher (only 1/6th of space lost) and your response marginally better provided...

Antares686 is right about the cost being less for set.

Pre-validate you data before attempting the conversion.

IsNumeric() would work in your example.

Very good article. I also agree with John and Steve. IT DOES exist to support the business and all too often IT holds the business hostage due to the technical...

Having done this myself several times now, I would strongly suggest a bcp out of the data, scripting of the database, and building of a new database.

Should I have said...

Back in versions 4.2, 6.0, and 6.5 it made a VERY MAJOR difference. It was part of a DBA's job in optimizing queries. With the "Optimizer" in todays versions, it...

I saw it used once in a company I worked for. They used it for archive jobs which removed rows one at a time based on a datetime field. It...

Add another event_date column to your output that is not converted, sort by the unconverted event_date and group by both (with the same value, it wouldn't change your grouping).

Or you...

That IS a good explanation Greg.

Edited by - Scorpion_66 on 11/25/2002 4:38:56 PM