Forum Replies Created

Viewing 15 posts - 376 through 390 (of 530 total)

  • RE: Terminal Services - Is this good/bad???

    As my understanding is that the Absolutely Not ONLY referrs to Terminal Server as an Application Server and not as an Administrative tool (of course one could argue that it is...

    March 22, 2004 at 4:07 am

    #499720

  • RE: Confused on user connections and SP_Who

    tyang:sp_who/sp_who2 in BOL=>

    The sp_who result set will be sorted in ascending order according to the spid values. In case of parallel processing, sub-threads are created for the specific spid. The...

    March 18, 2004 at 9:55 am

    #499358

  • RE: 2 Questions please

    First off I want to say that the TableVariable does not guarantee better performance, you have to find out yourself depending on your query. One big difference to #tables is that...

    March 18, 2004 at 8:17 am

    #499339

  • RE: transaction not rolling back

    Hi!

    You really should take a look at

    SET XACT_ABORT:

    Specifies whether Microsoft® SQL Server™ automatically rolls back the current transaction if a Transact-SQL statement raises a run-time error.

    When SET...

    March 10, 2004 at 3:41 am

    #498098

  • RE: Help! Delete operation is VERY SLOW

    What is the query plan? Maybe you are getting Nested Loops without a good index? Have you tried ANSI style joins with Index hints as alzdba suggested? What is your...

    February 25, 2004 at 10:29 am

    #495623

  • RE: Naming Conventions

    Hi Frank!

    Nice text. At this end it is properly read, printed and started to be considered

    Regards, Hans!

    February 23, 2004 at 7:04 am

    #495125

  • RE: text -> ntext causes massive size increase...

    Hi ojl96!

    I think your problem concerns the dropping of your TEXT column.

    Use DBCC CLEANTABLE.

    Look in BOL under the keyword: DBCC statements, DBCC...

    February 23, 2004 at 6:23 am

    #495119

  • RE: Naming Conventions

    Hmm, just a thought:

    What is the logical difference between data in a table and in a view? Why do you need to know that they are physically stored differently? What...

    February 23, 2004 at 6:05 am

    #495116

  • RE: Database size issue...

    Hello Ollie!

    I guess you should look into DBCC CLEANTABLE

    BOL:

    DBCC CLEANTABLE
    DBCC CLEANTABLE reclaims space after a variable length column or a text column is dropped using the ALTER TABLE DROP...

    February 17, 2004 at 9:17 am

    #494388

  • RE: unknown number of parameters for sp

    I would go for the temporary table, sounds like the code is going to be more straightforward with your NOT IN or whatever.

    Regards,...

    February 17, 2004 at 7:59 am

    #494360

  • RE: Help with getting or setting row number in table

    Jonathan:

    Thanx, I never have thought of using PARSENAME on my IPs 😉 I like to still have things to learn 😛 It makes waking up in the morning almost worth...

    November 25, 2003 at 12:55 am

    #483490

  • RE: QOD 11/21

    dlu: Do consider that this discussion forum for the QoD is NOT an official statement from the people that formulated the QoD for 21-NOV. Please separate our conversations about the...

    November 24, 2003 at 11:06 am

    #483420

  • RE: QOD 11/21

    ejdelaune:

    Yes, you are right about that two customers could order at exactly the same time, I wanted just to point out that you wrote

    November 21, 2003 at 8:57 am

    #483137

  • RE: QOD 11/21

    ejdelaune:

    quote:

    So, that also means that only one customer could place an order from you per day without violating the constraints on...

    November 21, 2003 at 7:58 am

    #483100

  • RE: QOD 11/21

    lansley:

    What I wanted to say is that you cannot assume that the LAST_ORDER_DT column actually is going to contain the last date a customer made an order. If you ever...

    November 21, 2003 at 6:16 am

    #483063

Viewing 15 posts - 376 through 390 (of 530 total)