Forum Replies Created

Viewing 15 posts - 3,541 through 3,555 (of 19,560 total)

  • RE: Problem inserting Japanese Text

    This works for me

    USE TestB; --replace with your appropriate database

    GO

    CREATE TABLE TBL1 (Property nvarchar(255))

    GO

    CREATE PROCEDURE DBO.InsertProperties(@Prop NVARCHAR(200))

    AS

    BEGIN

    INSERT INTO TBL1 VALUES ('N'+char(39)+@Prop+char(39))

    END

    GO

    EXECUTE DBO.InsertProperties N'????' --Run the SP

    GO

    SELECT *

    FROM TBL1;

    GO

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 20, 2014 at 10:19 pm

    #1690967

  • RE: Largest MS SQL Server Databases

    russ.thomas (2/20/2014)

    Here is some more recent info from the SQLCAT team... among some other petabyte monsters and companies they profile the databases running XBOX live which adds 12 TB monthly...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 20, 2014 at 9:59 pm

    #1690964

  • RE: Log Files Growing, even in Simple Mode

    Grant Fritchey (2/20/2014)

    No way in the world, at all, to avoid the log, so best practice is to find ways to deal with it. No other choice there. If you...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 20, 2014 at 9:52 pm

    #1690963

  • RE: Help query

    One option is to use SQL Data compare. I know it is not coding your own solution and does come with a price tag. But there is a...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 20, 2014 at 9:49 pm

    #1690962

  • RE: In Database We Trust

    happycat59 (2/20/2014)

    Carlo Romagnano (2/20/2014)

    Good question!

    Thanks!

    create database DEFAULT_DATABASE

    This runs!

    create database DELETE

    This DOESN'T run!

    You can use reserved words that stand for OPTIONS!

    Yes but

    create database [DELETE]

    does work

    I am just waiting for...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 20, 2014 at 9:46 pm

    #1690961

  • RE: Dumb interview answers

    jshahan (2/20/2014)

    We developed a test that required applicants to write queries against our proprietary database that would answer a list of specific questions we provided along with which tables to...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 20, 2014 at 9:44 pm

    #1690959

  • RE: Migrating to a NETAPP SAN

    Not sure on FalconStore. I have never used it. Maybe somebody else has and can chime in.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 20, 2014 at 9:40 pm

    #1690958

  • RE: Performance Tuning - Proof in the pudding

    Shawn Melton (2/20/2014)

    GilaMonster (2/20/2014)

    Shawn Melton (2/20/2014)

    Do you bother capturing a before and after to show what you accomplished?

    What type of information did you capture (perfmon counters, DMV output, wait...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 20, 2014 at 1:40 pm

    #1690880

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (2/20/2014)

    I have visitors in my ear.

    Or is that just Jason again? 😀

    Definitely me:-D:-D

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 20, 2014 at 1:16 pm

    #1690872

  • RE: Migrating to a NETAPP SAN

    jayoub (2/20/2014)

    Is disk alignment for everything or just for the clustered resources/disks?

    I am not sure if the disks have been aligned or not. NETApp is helping out, so they...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 20, 2014 at 1:03 pm

    #1690867

  • RE: Are the posted questions getting worse?

    Revenant (2/20/2014)

    The Dixie Flatline (2/20/2014)

    GilaMonster (2/20/2014)

    stormsentinelcammy (2/20/2014)

    will this forum thread ever get back on topic?

    After over 40 000 posts, I don't think it has a topic any longer.

    I think that's...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 20, 2014 at 1:01 pm

    #1690865

  • RE: Are the posted questions getting worse?

    Revenant (2/20/2014)

    GilaMonster (2/20/2014)

    SQLRNNR (2/19/2014)

    Yay - I'm finally insane!!! :hehe::w00t:

    Ooohhhhh...... 😀

    *starts typing faster*

    Because trusting MSDN and the BoL after all these years fits precisely the definition of "repeating the same [course...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 20, 2014 at 12:59 pm

    #1690864

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (2/20/2014)

    SQLRNNR (2/19/2014)

    Yay - I'm finally insane!!! :hehe::w00t:

    Finally?

    This comes as a surprise why exactly?

    Because I forgot...squirrel...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 20, 2014 at 12:57 pm

    #1690860

  • RE: Migrating to a NETAPP SAN

    Let me throw another concern out there for you.

    Have they aligned the disks on the netapp prior to doing the DTA move?

    I have done migrations using both (or at least...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 20, 2014 at 12:07 pm

    #1690828

  • RE: Today's Random Word!

    Ed Wagner (2/20/2014)

    Revenant (2/20/2014)

    sing4you (2/20/2014)

    Kurt W. Zimmerman (2/20/2014)

    crookj (2/20/2014)

    SQLRNNR (2/20/2014)

    JAZZ Master (2/19/2014)

    Daniel Bowlin (2/19/2014)

    Ed Wagner (2/19/2014)

    Kurt W. Zimmerman (2/19/2014)

    SQLRNNR (2/19/2014)

    Kurt W. Zimmerman (2/19/2014)

    crookj (2/19/2014)

    WotD - tedium

    boring

    drilling

    fraking

    Oil

    gas

    beans

    magical fruit

    Toot

    Flatulence

    gas mask

    riot

    Kiev

    Red

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 20, 2014 at 11:12 am

    #1690817

Viewing 15 posts - 3,541 through 3,555 (of 19,560 total)