Forum Replies Created

Viewing 15 posts - 271 through 285 (of 1,170 total)

  • RE: Trigger to update old ad new values

    Minnu (11/25/2015)

    without "old_val, new_val" trigger is working fine,want to add the old and new values to know which value is udpated to what.

    please help in query.

    Maybe this code could solve...

    November 25, 2015 at 3:40 am

    #1842266

  • RE: Trigger to update old ad new values

    Based on the operation you can choose what to do. Inserted keeps always the new values, whereas old values are kept in deleted.

    Declare @operation char(1) SET @operation= 'N'

    IF EXISTS(SELECT *...

    November 25, 2015 at 3:30 am

    #1842263

  • RE: Getting t-1

    Try this code

    select convert(datetime,convert(date,getdate()-1)),DATEADD(millisecond,-3,convert(datetime,DATEADD(day,1,convert(date,getdate()-1))))

    November 25, 2015 at 3:13 am

    #1842261

  • RE: Performance on server and pc

    It seems like not updated stats are in question.

    Do you have any maintenance of the database on your PC and server?

    Is the maintenance the same on both, the indexes...

    November 20, 2015 at 7:39 am

    #1841362

  • RE: String Compare

    What about this

    DECLARE @C NVARCHAR(10),@R NVARCHAR(10)

    SELECT @C=replace(replace(N'1 2',char(9),' '),char(13),' ')

    SELECT @R=replace(replace(N'12',char(9),' '),char(13),' ')

    SELECT ASCII(@C),ASCII(@R)

    IF @r=@C

    BEGIN

    SELECT 1

    END

    There are invisible characters in the @C variable: tab or endof line char.

    November 19, 2015 at 2:13 am

    #1840897

  • RE: Today's Random Word!

    Ed Wagner (11/6/2015)

    anthony.green (11/6/2015)

    djj (11/6/2015)

    crookj (11/6/2015)

    Ed Wagner (11/6/2015)

    anthony.green (11/6/2015)

    Igor Micev (11/6/2015)

    CATCH

    Error

    Log

    Audit

    Account

    Bank

    Fees

    Interest

    November 6, 2015 at 8:29 am

    #1838253

  • RE: How can I pick the IDs of all AS databases?

    This code works at my server:

    if object_id('tempdb..[#tmpASDbs]') is not null

    drop table #tmpASDbs

    create table #tmpASDbs(ASDBName nvarchar(100))

    declare @dynSql nvarchar(4000)

    set @dynSql =N'INSERT INTO #tmpASDbs(ASDBName)

    SELECT * FROM OPENQUERY(LINKED_OLAP,''SELECT [catalog_name] as [DatabaseName] FROM $SYSTEM.DBSCHEMA_CATALOGS'')'

    exec...

    November 6, 2015 at 2:57 am

    #1838170

  • RE: Today's Random Word!

    Eirikur Eiriksson (11/6/2015)

    Igor Micev (11/6/2015)

    Igor Micev (11/6/2015)

    DonlSimpson (11/5/2015)

    Ed Wagner (11/5/2015)

    djj (11/5/2015)

    crookj (11/5/2015)

    Igor Micev (11/5/2015)

    Luis Cazares (11/5/2015)

    anthony.green (11/5/2015)

    Igor Micev (11/5/2015)

    crookj (11/5/2015)

    Ed Wagner (11/5/2015)

    anthony.green (11/5/2015)

    TomThomson (11/4/2015)

    DonlSimpson (11/4/2015)

    Weak

    frail

    Old

    Experience

    Familiarity

    Information

    Announcement

    Billboard

    City

    of Heroes

    Advengers

    Hiro Nakumura

    Hiroshima

    Bomb

    End

    TRY

    CATCH

    November 6, 2015 at 1:38 am

    #1838159

  • RE: How can I pick the IDs of all AS databases?

    Hi,

    The following query will return the list of databases on your AS instance.

    SELECT catalog_name as [DatabaseName] FROM $SYSTEM.DBSCHEMA_CATALOGS

    You'll have to create a linked server to the AS server and call...

    November 6, 2015 at 1:37 am

    #1838158

  • RE: Today's Random Word!

    Igor Micev (11/6/2015)

    DonlSimpson (11/5/2015)

    Ed Wagner (11/5/2015)

    djj (11/5/2015)

    crookj (11/5/2015)

    Igor Micev (11/5/2015)

    Luis Cazares (11/5/2015)

    anthony.green (11/5/2015)

    Igor Micev (11/5/2015)

    crookj (11/5/2015)

    Ed Wagner (11/5/2015)

    anthony.green (11/5/2015)

    TomThomson (11/4/2015)

    DonlSimpson (11/4/2015)

    Weak

    frail

    Old

    Experience

    Familiarity

    Information

    Announcement

    Billboard

    City

    of Heroes

    Advengers

    Hiro Nakumura

    Hiroshima

    Bomb

    End

    November 6, 2015 at 1:27 am

    #1838153

  • RE: Today's Random Word!

    DonlSimpson (11/5/2015)

    Ed Wagner (11/5/2015)

    djj (11/5/2015)

    crookj (11/5/2015)

    Igor Micev (11/5/2015)

    Luis Cazares (11/5/2015)

    anthony.green (11/5/2015)

    Igor Micev (11/5/2015)

    crookj (11/5/2015)

    Ed Wagner (11/5/2015)

    anthony.green (11/5/2015)

    TomThomson (11/4/2015)

    DonlSimpson (11/4/2015)

    Weak

    frail

    Old

    Experience

    Familiarity

    Information

    Announcement

    Billboard

    City

    of Heroes

    Advengers

    Hiro Nakumura

    Hiroshima

    Bomb

    November 6, 2015 at 1:26 am

    #1838152

  • RE: Today's Random Word!

    Luis Cazares (11/5/2015)

    anthony.green (11/5/2015)

    Igor Micev (11/5/2015)

    crookj (11/5/2015)

    Ed Wagner (11/5/2015)

    anthony.green (11/5/2015)

    TomThomson (11/4/2015)

    DonlSimpson (11/4/2015)

    Weak

    frail

    Old

    Experience

    Familiarity

    Information

    Announcement

    Billboard

    City

    November 5, 2015 at 11:27 am

    #1838062

  • RE: avg disk byte reads

    river1 (11/5/2015)

    no, from 5 to 5 seconds

    ? don't understand this well,

    but however if the response time(ms) is reasonable it's normal to have spikes from time to time.

    November 5, 2015 at 7:03 am

    #1837964

  • RE: Today's Random Word!

    crookj (11/5/2015)

    Ed Wagner (11/5/2015)

    anthony.green (11/5/2015)

    TomThomson (11/4/2015)

    DonlSimpson (11/4/2015)

    Weak

    frail

    Old

    Experience

    Familiarity

    Information

    November 5, 2015 at 6:50 am

    #1837955

  • RE: Rebuild Indexes

    river1 (11/5/2015)

    Hi,

    If I rebuild some indexes that are above 30% of average fragmentation, should I after that update spatistics?

    Also, How can I see if I Need to update statistics^on the...

    November 5, 2015 at 6:35 am

    #1837952

Viewing 15 posts - 271 through 285 (of 1,170 total)