Viewing 15 posts - 1 through 15 (of 62 total)
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...
September 4, 2004 at 1:13 pm
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...
September 2, 2004 at 10:16 am
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...
August 30, 2004 at 11:33 am
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...
July 5, 2004 at 10:38 am
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,...
April 13, 2004 at 12:32 pm
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...
February 24, 2004 at 11:27 am
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...
February 11, 2004 at 12:25 pm
I found this URL with some undocumented DBCC commands.
I does have DBCC LOCK listed.
January 20, 2004 at 7:54 am
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...
December 4, 2003 at 10:42 am
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,...
November 6, 2003 at 7:19 am
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...
November 6, 2003 at 7:03 am
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...
November 6, 2003 at 6:50 am
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...
October 23, 2003 at 5:50 am
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...
October 14, 2003 at 6:18 am
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....
September 25, 2003 at 6:38 am