Forum Replies Created

Viewing 15 posts - 7,216 through 7,230 (of 19,560 total)

  • RE: forign key violation

    sqlfriends (1/9/2012)

    The problem is from the source flat files, sometimes they have data integrity issue, we cannot always to rely on them to prevent constraints violations.

    Have you taken these concerns...

    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

    January 9, 2012 at 2:15 pm

    #1430805

  • RE: Are the posted questions getting worse?

    GSquared (1/9/2012)

    Watch out, ASCIIbetical sorting can get tricky! Even without ASCII null-character codes in the string.

    Then let's go EBC

    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

    January 9, 2012 at 2:04 pm

    #1430801

  • RE: Would like to start my own blog but don't know how

    You are welcome.

    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

    January 9, 2012 at 2:02 pm

    #1430799

  • RE: Are the posted questions getting worse?

    Jack Corbett (1/9/2012)

    !Aaron Aardvark! (1/9/2012)

    There is a points target I'm keeping an eye on:

    Guess I'm going to have up my game to stay ahead of you. Enough others have...

    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

    January 9, 2012 at 2:01 pm

    #1430797

  • RE: Are the posted questions getting worse?

    !Aaron Aardvark! (1/9/2012)

    Very funny, Jason.

    😀

    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

    January 9, 2012 at 1:59 pm

    #1430796

  • RE: Microsoft Gold Certified Partner Companies - Horror Stories

    tfifield (1/9/2012)

    Take a gander as ASPDotNet Store Front if you want a horror story for table layouts. All pretty much NVARCHAR(MAX) or NTEXT.

    Todd Fifield

    MS Dynamics/CRM 4 is pretty much...

    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

    January 9, 2012 at 1:48 pm

    #1430785

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (1/9/2012)

    I'm starting to give away bunches to the library now.

    We have several boxes (think 4u server boxes) full of books that won't fit on the...

    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

    January 9, 2012 at 1:25 pm

    #1430766

  • RE: Are the posted questions getting worse?

    GilaMonster (1/9/2012)

    Jack Corbett (1/9/2012)

    I was going to comment that it would probably be cheaper and more productive to buy an e-reader than to keep going with bookshelves and "real" books.

    Got...

    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

    January 9, 2012 at 1:21 pm

    #1430763

  • RE: Query Syntax

    This should fix it

    DECLARE AllDatabases CURSOR FOR

    SELECT [name] FROM master.dbo.sysdatabases WHERE dbid > 4

    OPEN AllDatabases

    DECLARE @DBNameVar NVARCHAR(128),@Statement NVARCHAR(max)

    FETCH NEXT FROM AllDatabases INTO @DBNameVar

    WHILE (@@FETCH_STATUS = 0)

    BEGIN

    PRINT N'CHECKING DATABASE ' +...

    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

    January 9, 2012 at 12:10 pm

    #1430734

  • RE: Manual grow mystery

    I'm thinking they may have resized the database without the autogrow.

    How large is the database currently? Is it 4.95Gb or was that the starting size of the DB?

    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

    January 9, 2012 at 12:00 pm

    #1430726

  • RE: Are the posted questions getting worse?

    GilaMonster (1/9/2012)

    Steve Jones - SSC Editor (1/9/2012)

    jcrawf02 (1/9/2012)

    GilaMonster (1/9/2012)

    Ninja's_RGR'us (1/9/2012)

    There was a time I loved fiction, got any books to recommend?

    Yes

    http://sqlinthewild.co.za/index.php/2012/01/01/2011-book-review/

    http://sqlskills.com/BLOGS/PAUL/post/2011-the-year-in-books.aspx

    We both have 2010 posts as well if you feel...

    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

    January 9, 2012 at 11:52 am

    #1430719

  • RE: "Access to the path is denied" error in SSIS package

    Permissions don't always cascade to child folders. Check the subfolders and confirm permissions exist there.

    Even though it works in your stage environment, it is not a guarantee that it...

    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

    January 9, 2012 at 11:50 am

    #1430717

  • RE: Would like to start my own blog but don't know how

    In addition to blogspot, there is wordpress.com.

    If you are looking to use it as a part of your brand, you might consider getting a domain and hosting the blog there.

    Another...

    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

    January 9, 2012 at 11:08 am

    #1430699

  • RE: Are the posted questions getting worse?

    Aaron Aardvark (1/9/2012)

    SQLRNNR (1/9/2012)

    SQL Kiwi (1/9/2012)

    GSquared (1/9/2012)

    Yes, but not at the posts count thing. Just at the "change your name to something even sillier than GSquared" thing.

    You don't think...

    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

    January 9, 2012 at 10:58 am

    #1430692

  • RE: Are the posted questions getting worse?

    SQL Kiwi (1/9/2012)

    GSquared (1/9/2012)

    Yes, but not at the posts count thing. Just at the "change your name to something even sillier than GSquared" thing.

    You don't think 'Aaron Aardvark' has...

    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

    January 9, 2012 at 10:48 am

    #1430684

Viewing 15 posts - 7,216 through 7,230 (of 19,560 total)