Forum Replies Created

Viewing 15 posts - 6,601 through 6,615 (of 7,619 total)

  • RE: how to delete my temp tables in batch?

    In SQL Server, temporary tables start with # or ##, such as #table or ##table.

    IIRC:

    SQL will automatically destroy # tables when the connection ends.

    For ## tables, under SQL 2005 and...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    April 5, 2013 at 1:57 pm

    #1604114

  • RE: How to preserve global temporary table data

    Lynn Pettis (4/4/2013)

    ScottPletcher (4/4/2013)

    Lynn Pettis (4/4/2013)

    Not saying I am right or wrong. I wanted a straight answer to a straight question: Is it a problem to lose the data...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    April 4, 2013 at 4:36 pm

    #1603765

  • RE: How to preserve global temporary table data

    Lynn Pettis (4/4/2013)

    Not saying I am right or wrong. I wanted a straight answer to a straight question: Is it a problem to lose the data if there is...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    April 4, 2013 at 4:19 pm

    #1603758

  • RE: How to preserve global temporary table data

    Lynn Pettis (4/4/2013)

    ScottPletcher (4/4/2013)

    Lynn Pettis (4/4/2013)

    ScottPletcher (4/4/2013)

    You're vastly more likely to lose a single connection than have the entire instance go down, which would kill a temp table from that...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    April 4, 2013 at 3:18 pm

    #1603743

  • RE: How to preserve global temporary table data

    Lynn Pettis (4/4/2013)

    ScottPletcher (4/4/2013)

    You're vastly more likely to lose a single connection than have the entire instance go down, which would kill a temp table from that connection as well.

    I...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    April 4, 2013 at 3:01 pm

    #1603741

  • RE: Help me tune this query...Please. :)

    Agree absolutely. Can you not specify any time of date range to help limit the rows to be processed?

    And, what the heck, maybe try this first too:

    SELECT CASE WHEN...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    April 4, 2013 at 1:19 pm

    #1603717

  • RE: How to preserve global temporary table data

    rajarshi_ghosh_05 (4/4/2013)

    ScottPletcher (4/4/2013)

    It sounded like one of those types of processes, where you basically just need a temporary "cache" of results / report. Typically those are easy enough for...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    April 4, 2013 at 1:06 pm

    #1603715

  • RE: advanced subquery

    Sean Lange (4/4/2013)

    ScottPletcher (4/4/2013)

    SELECT RefNumber

    FROM #Data d

    GROUP BY RefNumber

    HAVING

    COUNT(DISTINCT EntryType) = 3 AND

    MAX(CASE WHEN EntryType NOT IN ( 0, 2, 11 )...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    April 4, 2013 at 12:50 pm

    #1603706

  • RE: How to preserve global temporary table data

    It sounded like one of those types of processes, where you basically just need a temporary "cache" of results / report. Typically those are easy enough for a user...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    April 4, 2013 at 12:23 pm

    #1603691

  • RE: How to preserve global temporary table data

    You're vastly more likely to lose a single connection than have the entire instance go down, which would kill a temp table from that connection as well.

    I mean, seriously, if...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    April 4, 2013 at 12:20 pm

    #1603690

  • RE: Grouping question

    SELECT

    LEFT(File, 4) AS File,

    MAX(CASE WHEN SUBSTRING(File, 6, 1) = '' THEN Description ELSE '' END) AS Description,

    SUM(Points)...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    April 4, 2013 at 11:00 am

    #1603647

  • RE: advanced subquery

    SELECT RefNumber

    FROM #Data d

    GROUP BY RefNumber

    HAVING

    COUNT(DISTINCT EntryType) = 3 AND

    MAX(CASE WHEN EntryType NOT IN ( 0, 2, 11 ) THEN 1 ELSE...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    April 4, 2013 at 10:49 am

    #1603643

  • RE: How to preserve global temporary table data

    Lynn Pettis (4/4/2013)

    ScottPletcher (4/1/2013)

    sharky (3/31/2013)

    Lynn Pettis (3/29/2013)

    SQLRNNR (3/29/2013)

    Lynn Pettis (3/29/2013)

    ScottPletcher (3/29/2013)

    The advantage to tempdb is that there is less overhead writing data there since SQL "knows" it never has to...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    April 4, 2013 at 8:56 am

    #1603594

  • RE: *MAY* need to switch DBs from Full Recovery to Simple, due to backup space issues...

    jasona.work (4/3/2013)

    ScottPletcher, Once the SP Admin gets done with clearing out the old audit information, actually reducing the on-disk size of the logs (and as you suggest, setting their...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    April 3, 2013 at 10:50 am

    #1603292

  • RE: *MAY* need to switch DBs from Full Recovery to Simple, due to backup space issues...

    Overall that sounds reasonable, given that you are in an emergency situation.

    About how long might it be before SQL auto-truncates the logs? Can I "force" it to happen sooner by...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    April 3, 2013 at 10:24 am

    #1603277

Viewing 15 posts - 6,601 through 6,615 (of 7,619 total)