Isn’t there some global setting for model database which can configure the auto grow attribute of any new database created to allow for unrestricted access?

Even though the model database itself...

Nice article. Cleared a lot of grey areas regarding CTE for me.

I have a doubt though, given the uses of a CTE, isint it similar to table variables then? I...

Plan Plan Plan Plan Plan!

Don’t get defeated by temporary defeat.

Practice self disciplined and self control.

Take your time to decide but when you decide don’t keep changing your decisions

Attention to...

Thanks for posting the functions, I found them very useful. Even the help is done very well.

"Insert into #sometemptable

select * from sysobjects order by crdate

select * from #sometemptable

The order that the select returns is not defined. It might be by crdate, or it might not."

I'll...

Well I haven’t been fortunate enough with dealing with XML’s too much, but I believe generally when you use for Auto clause its fairly straight forward. The complexity creeps in...

Well I got that query in an email, so cant really pin down the real source.

I can imagine though the context in which it was...

Thanks for the link Greg.

Was aware of the DBCC log function but I am not too pleased with its out put. Rather I am unable to use to output...

Nice article.

Another way of writing the same, for those who prefer the old convention (I dont recommend it).

SELECT

s.*,

Pardon my ignorance, but why should only reports use isolation levels?

Is it because the queries for reports are long running queries and dont need to keep switching the isolation levels...

Ermmm, the infamous Oracle like sequence table seems to be an integral part of our architecture. It was already in place before I took over, and changing it now will...

@noggin - Yes, that could be an option for bulk inserts. But in our scnario, the inserts would be done on an OLTP...

Alrighty. I have tried the code with the different formats which we have on here, and not surprisingly it was worked like silk.

My concern now is, the size of @doc...

Thanks for responding guys, I am going to try out the solutions which you'll posted and get back here with the results.

This has been one of the most informative threads I have come across wrt locking.

How bout setting the right Tran Isolation levels / Transation? Should'nt that help in managing the...