Forum Replies Created

Viewing 15 posts - 6,106 through 6,120 (of 26,490 total)

  • RE: Missing Century in Date

    What type of data is being stored in the database? What is the application it is supporting?

    August 8, 2014 at 10:47 am

    #1736497

  • RE: DELTING HUGE No. of ROWS

    funooni (8/8/2014)

    Lynn Pettis (8/8/2014)

    funooni (8/8/2014)

    Lynn Pettis (8/8/2014)

    There are other issues with your query, but lets not worry about that just yet. Another question, what edition of SQL Server are...

    August 8, 2014 at 10:07 am

    #1736482

  • RE: DELTING HUGE No. of ROWS

    funooni (8/8/2014)

    Lynn Pettis (8/8/2014)

    There are other issues with your query, but lets not worry about that just yet. Another question, what edition of SQL Server are you running?

    Also, is...

    August 8, 2014 at 9:38 am

    #1736469

  • RE: DELTING HUGE No. of ROWS

    There are other issues with your query, but lets not worry about that just yet. Another question, what edition of SQL Server are you running?

    Also, is the intent to...

    August 8, 2014 at 8:48 am

    #1736447

  • RE: DELTING HUGE No. of ROWS

    funooni (8/8/2014)

    Dears ,

    I have to delete data from HUGETABLE which has around 700 million rows prior to 1st May 2014. This table has no Index, however, it has an ID...

    August 8, 2014 at 7:56 am

    #1736420

  • RE: Split string to show only customer

    dwilliscp (8/7/2014)

    The data we are getting from our shipping company has the customer name and customer number attached.

    so we could have.. declare @String varchar(25) = 'asdf - 10'

    but we...

    August 7, 2014 at 4:36 pm

    #1736241

  • RE: Are the posted questions getting worse?

    TomThomson (8/7/2014)

    Lynn Pettis (8/7/2014)

    Now this just pissed me off:

    ********* (8/7/2014)

    thanks lynn, for being forthcoming (finally!)

    Leaving out the name of the perp.

    Maybe you are misreading him - that "finally" could...

    August 7, 2014 at 4:25 pm

    #1736238

  • RE: Are the posted questions getting worse?

    Sean Lange (8/7/2014)

    Well off for vacation for a few days to Colorado Springs. Will be nice to be in cooler air for a few days. See you all next week...

    August 7, 2014 at 3:37 pm

    #1736227

  • RE: How to Handle Calculations Related to fiscal year and quarter

    danielk1 (8/7/2014)

    g.britton (7/27/2014)

    Much better to use a date dimension table that contains all relevant date info for your company. You can include columns like 'IsHoliday' or 'IsWeekend' as well...

    August 7, 2014 at 11:31 am

    #1736117

  • RE: Are the posted questions getting worse?

    Jack Corbett (8/7/2014)

    Lynn Pettis (8/7/2014)

    SQLRNNR (8/7/2014)

    Lynn Pettis (8/7/2014)

    Now this just pissed me off:

    ********* (8/7/2014)

    thanks lynn, for being forthcoming (finally!)

    Leaving out the name of the perp.

    Haha - too...

    August 7, 2014 at 11:03 am

    #1736102

  • RE: Changing NAME and IP ADDRESS of machine where SQL Server is hosted.

    Joy Smith San (8/7/2014)

    Hi All,

    App team wants to change the NAME and IP ADDRESS of machine where SQL Server is hosted.

    Apart from executing the below script, is there anything else...

    August 7, 2014 at 10:56 am

    #1736098

  • RE: Are the posted questions getting worse?

    SQLRNNR (8/7/2014)

    Lynn Pettis (8/7/2014)

    Now this just pissed me off:

    ********* (8/7/2014)

    thanks lynn, for being forthcoming (finally!)

    Leaving out the name of the perp.

    Haha - too easy to find. :crazy:

    At least I'm...

    August 7, 2014 at 10:46 am

    #1736091

  • RE: complex query

    sharon-472085 (8/7/2014)

    hi ,

    sql 2005 sp4

    sharon

    LutzM's recommendation still stands. Read the article and the follow on discussion so that you fully understand how to implement this solution. The rules...

    August 7, 2014 at 10:42 am

    #1736087

  • RE: Are the posted questions getting worse?

    Now this just pissed me off:

    ********* (8/7/2014)

    thanks lynn, for being forthcoming (finally!)

    Leaving out the name of the perp.

    August 7, 2014 at 10:16 am

    #1736077

  • RE: Are the posted questions getting worse?

    After working with SQL Server for 4 years you'd expect someone to know why SELECT 18/94 returns zero.

    Just down right scary!

    August 7, 2014 at 10:04 am

    #1736062

Viewing 15 posts - 6,106 through 6,120 (of 26,490 total)