Forum Replies Created

Viewing 15 posts - 4,666 through 4,680 (of 15,381 total)

  • RE: Get Data Centralized

    sultan.shaikh (5/30/2014)

    Hi, I am not sure how to tackle the following. Environment has SQL Server 2005 and above which hosts one database (table1 & table2) per server. I have created...

    May 30, 2014 at 1:52 pm

    #1717939

  • RE: CTE - why use, and NOLOCK

    Michael_Garrison (5/30/2014)

    2. Yes, I know by now NOLOCK is bad. (I have seen all you guys say that, the top people in these forums, you know who you...

    May 30, 2014 at 12:32 pm

    #1717920

  • RE: uses of string splitters

    KoldCoffee (5/30/2014)

    Yes, I know about what you're talking about. I was lucky to once have a great manager tell me what an awesome job I did after I banged...

    May 30, 2014 at 12:24 pm

    #1717914

  • RE: Today's Random Word!

    Revenant (5/30/2014)

    Ed Wagner (5/30/2014)

    crookj (5/30/2014)

    Sean Lange (5/30/2014)

    Ed Wagner (5/30/2014)

    Sean Lange (5/30/2014)

    Ed Wagner (5/30/2014)

    Sean Lange (5/30/2014)

    SQLRNNR (5/30/2014)

    Potato

    fingerling

    Olive Oil

    Rosemary

    Thyme

    Parsley

    Scarborough (Faire )

    Simon

    Silence [Sounds of]

    Bridge

    May 30, 2014 at 12:19 pm

    #1717913

  • RE: uses of string splitters

    KoldCoffee (5/30/2014)

    Luis Cazares (5/30/2014)

    I added that thread to my briefcase because I'm sure it might get handy some time. I use a digital camera for my photographic memory but from...

    May 30, 2014 at 10:22 am

    #1717875

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (5/30/2014)

    Everyone enjoy summer. Last chance to ping me for things before I'm gone for 6 weeks.

    7 hours and counting....

    Have an awesome and rewarding time!!!

    /jealous

    May 30, 2014 at 9:52 am

    #1717858

  • RE: Today's Random Word!

    Ed Wagner (5/30/2014)

    Sean Lange (5/30/2014)

    Ed Wagner (5/30/2014)

    Sean Lange (5/30/2014)

    SQLRNNR (5/30/2014)

    Potato

    fingerling

    Olive Oil

    Rosemary

    Thyme

    Parsley

    May 30, 2014 at 9:51 am

    #1717856

  • RE: Today's Random Word!

    Ed Wagner (5/30/2014)

    Sean Lange (5/30/2014)

    SQLRNNR (5/30/2014)

    Potato

    fingerling

    Olive Oil

    Rosemary

    May 30, 2014 at 9:34 am

    #1717842

  • RE: Lock before Truncate and Insert

    Fin3125 (5/30/2014)

    wow.. I never thought of that. There are a lot of queries reading these tables using the Nolock hint. I guess I have no choice to make sure they...

    May 30, 2014 at 9:33 am

    #1717841

  • RE: Today's Random Word!

    SQLRNNR (5/30/2014)

    Potato

    fingerling

    May 30, 2014 at 9:19 am

    #1717832

  • RE: Getting first and last value for every group.

    David Burrows (5/30/2014)

    Sean Lange (5/30/2014)

    David Burrows (5/30/2014)[hrthe table is a heap and therefore has no order.

    Tables have no order if it is a heap or not. A clustered index does...

    May 30, 2014 at 9:02 am

    #1717820

  • RE: Lock before Truncate and Insert

    Fin3125 (5/30/2014)

    What is the "Best way" to lock or block access to a table that is being refreshed?

    I do this all the time in stored procedure and SSIS packages. I...

    May 30, 2014 at 9:00 am

    #1717816

  • RE: Getting first and last value for every group.

    David Burrows (5/30/2014)[hrthe table is a heap and therefore has no order.

    Tables have no order if it is a heap or not. A clustered index does not provide order to...

    May 30, 2014 at 8:57 am

    #1717812

  • RE: Getting first and last value for every group.

    Excellent job posting ddl and sample data. The challenge here is that you have to define what "first" and "last" means. A table by definition is an unordered set of...

    May 30, 2014 at 8:56 am

    #1717811

  • RE: Trigger syntax

    SQLSteve (5/30/2014)

    ALTER TRIGGER [dbo].[Trigger1]

    ON [dbo].[Table1] with execute as SELF

    AFTER INSERT

    AS

    BEGIN

    SET NOCOUNT ON;

    IF (SELECT Colum1 FROM Inserted)...

    May 30, 2014 at 8:52 am

    #1717805

Viewing 15 posts - 4,666 through 4,680 (of 15,381 total)