If i'm not wrong, i'd bet your transaction log is set to auto-grow by multiply of 1024 bytes. Kimberly Tripp has pointed out a bug in ms sql if you...

Its one of the tricky question trying to confuse the reader.

I almost hit NO looking at the example (because it doesnt make sense), but come to think again, the...

I've been using pretty much the same concept for data deletion since quite some time ago already. It does the same job as Lynn's code, except done a bit differently....

Am using the latest Embarcadero DBArtisan 8.5.5 currently and have had this tool for couple of years. Works very well to manage our Sybase but i would stick to using...

I've just executed it on my SQL 2005 and it returns a result of 2008-10-09 00:00:00.

How strange is it (or not)?

With all the replies, it does indicate that varchar(1) is actually not suitable because its carries an overhead for no reason (since the question specifically mention that the one character...

Hi gk,

My hunch is that its not I/O related, but probably due to your source database contains a very large amount of data to be transferred to cube and causes...

I've had issue getting similar alert from MOM where there was more than 500 connections made to a database. Thinking there no way this many connection can be made to...

yep, i was confused by the question too. I thought it was just asking for database file extension, not include database log extension, meaning only mdf and ndf by default.

What...

Worst job ever for me is to put up 12 - 15 hours/day and working over most weekends for 3.5 years and got a warning letter from HR for my...

It worked brilliantly Muchesa, thanks!

I reckon the worth of a really good Senior DBA in Sydney, Australia is very good, plus bonus you may get around $140K/annum. I know lot of mates who are...

Whilst it does make sense to only have 1 transaction log per User DB, any idea about tempdb? The recommendation from M$ was to have 1 data file per CPU...

Bryansky,

Target Server Memory (KB) - Total amount of dynamic memory the server can consume.

Total Server Memory (KB) - The committed memory from the buffer pool (in kilobytes)

When both value is...

Tharindu, just a note. 'allow updates' is a hack only for sql 2000, and apprently they discontinue this hack for sql 2005. so far, there's no info from the question...