DBCC EXTENTINFO

ill see what this can do for me.

Great article, keep on learning and taking us for the ride. Im keen to see practical working examples of this under-utilised technology.

Cheers

Ck

Hi there

Well well well, blow me down if I didnt get the error yesterday! after thinking that will all the instals i have done I never hit it before.

Your article...

In our web based app operating (of course) in a statless env, we have three columns for each table:

update_count, int

last_updated_by, varchar(50)

last_updated_on, datetime

each table (where appropriate), has an equivalent *_Audit version,...

Hi

Some very interesting thinking. I can thinking of a variety of senarios where some of these would apply but as the only dba, i can trust myself 😉

Cheers

Chris K

http://www.chriskempster.com

...

Hi

Outstanding article that covers off some classic issues, thanks for spending the time writing it.

Cheers

Chris K

http://www.chriskempster.com

Hi Steve

As an apps dba, you wouldnt believe the excuses and comments from developers re getting so called adhoc changes through test then prod with a time span of 1...

Hi there

Interesting article, but lacks what the DBA's really need, that being change control templates , specific (point form) steps used in example environments and example security settings to control...

The product is very good and I highly recommend it, unfortunatly for me, the company I am contracting for at present has no money (but they can buy lots of...

because you cant to update stats and other assoc sp commands in the proc (or against a temp table), to get around the problem, we require hints:

DELETE #lodgement_enrolment

FROM...

Hey Hey

Worked it out, but is a so and so to fix.

Basically, if you wrap the call in a transaction, statman wont run and therefore the optimizer will think there...

Hi

Good article. This is perhaps off track but....

In the world of chaos in which IT companies are well and truely in, it is critical that developers and associated management...

Hi

I hate UDT's, they are hopessly deficient, why?

a) i cant easily change the "real" type for the udf once bound to N tables

b) they can be a nightmare to...

Great article Brian, very thorough.

Hi

I thought the DB name was a basic fundamental for developers! id be cracking some heads (some aussie slang ) if they didnt specify it and relied on the default...