Ok, here is an example of a good question.  No business pretense, so the focus is purely technical.  Sure, most of us got it wrong, including me, but that is...

I like the idea of changing the concatenation operator as well. DB400 (DB2 on as/400) uses the || as well.

For triggers, lets keep them set based.  If you do need...

I've been out of town a few days, so just getting to this, but Steve, I have to disagree with you.  A good DBA, or IT staff person looks at...

I think the most important aspect of this question is that if you write a trigger, you really need to think thru the logic.  And test, test, test.

Make sure you...

Yea, this was an interesting question.  And I could see how some of the unknown assumptions might change the approach.  If this really was the accounting transactional database, then accuracy,...

Interesting, but I'd have to say the answer while technically correct, is way to complicated, and forces the DBA to stop and restart the database engine. 

All you really need to...

I'd put this in the trick question category.  My approach is from a best practices perspective. and in that case, following BOL you would do the following ( as noted...

I found this URL with some undocumented DBCC commands.

I does have DBCC LOCK listed.

http://databasejournal.com/features/mssql/print.php/1459071

Why do you need a freeware anyway. All the MS tools such as EM, QA, etc. can be used by anyone who has a connection license. If you...

I think you need to decide if you are a super technical type, or one who first wants to understand the business problem.

Look back at all the classes you took,...

We should thank pagakia for posting the position.

But overall, I think its good that a company thinks getting the database correct is a good thing. Too many...

6.5 used page of 2K. And I think the extent was 8K. 6.5 and earlier used the old Sybase data structures. (Disk Device, etc) With v7, the entire data...

The SQL Server resource kit has a log-shipping lite version for use with the non-enterpirse edition. But, it only covers the trans files. I used it to build an...

Thanks for the tip. We've used PCDuo, PCAnywhere, SMS, etc in past, but free TS/admin is great.

We were looking for the Terminal Services command line 'logoff session' a few weeks...

Jonathan is right on the mark.

Further, if you get into a situation where your objects may need to have a group of states, create a states_group table, creating state groups....