Forum Replies Created

Viewing 15 posts - 181 through 195 (of 195 total)

  • RE: First Poll for 2006

    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...

  • RE: Novice needing better performance from query

    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...

  • RE: Novice needing better performance from query

    And is that showing a clustered index seek or a clustered index scan?

  • RE: Novice needing better performance from query

    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...

  • RE: strange DTS behaviour?????????

    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...

  • RE: Views Effects Performance

    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...

  • RE: How do you spell S-Q-L?

    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...

  • RE: Anyway to rollback a stored procedure to the previous version

    SQL2005 integrates with SS and with many 3rd party source control applicaiotns.

  • RE: When to use Stored Procedures

    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...

  • RE: SQL Server Need to be dedicated server?

    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...

  • RE: Apologies to Ken Henderson

    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...

  • RE: Basic Index advice needed please?

    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...

  • RE: DBA vs Database Developer

    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...

  • RE: Outcourcing Operations

    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...

  • RE: Tables and more tables design...

    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...

Viewing 15 posts - 181 through 195 (of 195 total)