Forum Replies Created

Viewing 15 posts - 11,386 through 11,400 (of 19,560 total)

  • RE: Back up restore problem

    Sounds like Operating system permissions. Does the SQL Service account on the destination have permissions to the source directory as well as the directory for the destination data and...

    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

    December 15, 2010 at 4:45 pm

    #1263225

  • RE: SQL for the NoSQL DB

    Sounds Cool

    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

    December 15, 2010 at 4:42 pm

    #1263224

  • RE: (urgent) Backup from SQL Server express 2008, restore to 2005?

    Jason Norsworthy (12/15/2010)

    Thanks for the response Gail,

    I'll be dealing with possibly having to roll back locally installed databases, with numerous variations in schema. (I didn't create them!) I've never had...

    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

    December 15, 2010 at 4:41 pm

    #1263223

  • RE: Hidden Formatting Troubles with STR() (SQL Spackle)

    Thanks Jeff. This is functionality that I have yet to use.

    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

    December 15, 2010 at 4:37 pm

    #1263222

  • RE: We Are Not a Meritocracy

    Personality, skills and networking. Sounds like the typical requirements to getting a better job.

    Great editorial Steve.

    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

    December 15, 2010 at 4:35 pm

    #1263221

  • RE: Today's Random Word!

    Tom.Thomson (12/15/2010)

    Granddaughter.

    Not quite random word. My first one was born very early this morning.

    Congrats

    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

    December 15, 2010 at 4:30 pm

    #1263219

  • RE: Are the posted questions getting worse?

    Dave Ballantyne (12/15/2010)

    Alvin Ramard (12/15/2010)

    Get rid of the CAST, and you still get the same results.

    This issue is that MONEY does not obey the same rules as DECIMAL(x, 4) or...

    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

    December 15, 2010 at 2:03 pm

    #1263144

  • RE: Are the posted questions getting worse?

    Dave Ballantyne (12/15/2010)

    LutzM (12/15/2010)

    Lynn Pettis (12/15/2010)

    I'm not in a position to test, but don't you get the same issue when using decimal(19,4) as you do when usinf money?

    Now I may...

    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

    December 15, 2010 at 1:49 pm

    #1263134

  • RE: Today's Random Word!

    John Rowan (12/15/2010)

    CirquedeSQLeil (12/15/2010)

    crookj (12/15/2010)

    John Rowan (12/15/2010)

    CirquedeSQLeil (12/15/2010)

    Announcement (to be made)

    Drum roll pease.....

    Can only hold my breath for so long......

    Joe

    I will be posting more in my blog

    Where's you blog site?

    ...nevermind...

    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

    December 15, 2010 at 1:13 pm

    #1263117

  • RE: SELECT All Columns from a table - without re-engineering if table stucture changes

    WayneS (12/15/2010)

    CirquedeSQLeil (12/15/2010)

    WayneS (12/15/2010)

    Toby Harman (12/14/2010)

    If all you are doing is writing that data out to another file and you *always* want *every* column, then SELECT * would be fine.

    If...

    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

    December 15, 2010 at 1:11 pm

    #1263115

  • RE: Moving SqlExpress Data from one location to another

    You should place those on local disks or san attached disks - not network shares.

    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

    December 15, 2010 at 1:06 pm

    #1263110

  • RE: How do I find the Max # of rows ?

    so you want a sum of columna and columnb?

    Could you provide sample data and expected results? From there we can create a query.

    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

    December 15, 2010 at 1:05 pm

    #1263109

  • RE: Are the posted questions getting worse?

    LutzM (12/15/2010)

    Regarding the money data type:

    Here's an interesting example I just found here

    DECLARE @m MONEY

    SET @m = 234.56

    SELECT CAST((@m/1000)*1000 AS MONEY)

    Another interesting article can be found here at SSC

    Awesome -...

    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

    December 15, 2010 at 12:44 pm

    #1263091

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (12/15/2010)

    I think I just found it. Money rounds funny when being used in division and multiplication.

    Interesting that I never ran into this before. I should make a SQL...

    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

    December 15, 2010 at 12:22 pm

    #1263075

  • RE: SELECT All Columns from a table - without re-engineering if table stucture changes

    WayneS (12/15/2010)

    Toby Harman (12/14/2010)

    If all you are doing is writing that data out to another file and you *always* want *every* column, then SELECT * would be fine.

    If you can't...

    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

    December 15, 2010 at 12:14 pm

    #1263070

Viewing 15 posts - 11,386 through 11,400 (of 19,560 total)