Viewing 15 posts - 181 through 195 (of 195 total)
I know you believe you understand what you thought I said but I'm not quite sure that what you heard is what I meant.
Murphy was an optimist.
What can we do...
January 6, 2006 at 6:44 am
Likely that is part of the problem.
Is the clustered index on an identity field perhaps? If so, you could add in your where clause ...And carton.identity_field > 0. That will...
December 29, 2005 at 1:00 pm
And is that showing a clustered index seek or a clustered index scan?
December 29, 2005 at 12:52 pm
Having used both syntaxes I would agree without looking that the execution plan and query result would be the same. Given the amount of execution time I am guessing that...
December 29, 2005 at 6:39 am
My experience with DTS suggests that the task numbering has to do with the order of creation. If you have 10 tasks (created in order 1-10) with workflow that executes...
December 22, 2005 at 6:33 am
If each view contains an Order By clause, then you may eventually end up writing a view for every possible combination of Order By clauses. That is, potentially, a LOT...
October 11, 2005 at 7:08 am
I, too, have been on both sides of that interview table. Technical interviews can be as daunting for the interviewer as for the interviewee. But I always appreciate someone who...
August 18, 2005 at 8:53 am
SQL2005 integrates with SS and with many 3rd party source control applicaiotns.
August 17, 2005 at 7:20 am
True, SPs are not compiled but they can and frequently do use a previously created execution plan. Inline code does not.
And with regard to source control, granted it takes discipline...
August 12, 2005 at 7:26 am
Before you invest (although it is a GOOD idea) you might want to look more closely at paging just to keep things alive until Christmas.
Check to see if the Windows...
August 12, 2005 at 7:19 am
The nature of this site means that this had to happen eventually. Cheers to Steve for being a stand-up guy about it. No rationalizations or excuses here, just acceptance and...
July 27, 2005 at 7:51 am
A couple of other things to consider...
Columns frequently used in WHERE clauses are good index candidates.
Investigate your indexing solution versus your queries using Execution Plan. Be sure that you are...
June 22, 2005 at 6:50 am
I've been doing both DBA and development work in SQL since MS-SQL 4.2. When I started that I was also learning ASP (interdev 1.0). I still do web development (learning...
May 17, 2005 at 7:02 am
As a de-facto DBA who certainly prefers development to log checking, I couldn't agree more. We have been through a great deal of off-shoring. It was sold originally as handling...
May 5, 2005 at 6:50 am
Regarding sub tasks...a possibility is to keep a parent task key in each task record. Any task with a null parent task key is the parent task. All other tasks...
May 4, 2005 at 6:51 am