Forum Replies Created

Viewing 15 posts - 4,831 through 4,845 (of 9,399 total)

  • RE: Table Space growth based on each year

    Eirikur Eiriksson (10/28/2015)


    Admingod (10/28/2015)


    I am populating all the table information to main table on daily basis based on date time stamp. However, how to create a script to query against...

  • RE: Today's Random Word!

    anthony.green (10/29/2015)


    Ed Wagner (10/29/2015)


    anthony.green (10/29/2015)


    Ed Wagner (10/28/2015)


    Eirikur Eiriksson (10/28/2015)


    Jeff Moden (10/28/2015)


    Eirikur Eiriksson (10/28/2015)


    Ed Wagner (10/28/2015)


    Eirikur Eiriksson (10/28/2015)


    happygeek (10/28/2015)


    nibble

    Quark

    String

    Tension

    "Wait-till-last-minute"

    (83-code-reviews-in-2-days-on-urgent-project :sick::blink::unsure:)

    Ultimate tensile strength (UTS)

    Shear

    Sheep

    Lamb Chops

    Minted

    Coin

  • RE: What can I do to speed up my production daily full-backup?

    johnwalker10 (10/28/2015)


    Have you checked the box to compress the backup? There is lots of air in many databases.

    Empty space doesn't get backed up, only the allocation of empty space. ...

  • RE: Today's Random Word!

    anthony.green (10/29/2015)


    Ed Wagner (10/28/2015)


    Eirikur Eiriksson (10/28/2015)


    Jeff Moden (10/28/2015)


    Eirikur Eiriksson (10/28/2015)


    Ed Wagner (10/28/2015)


    Eirikur Eiriksson (10/28/2015)


    happygeek (10/28/2015)


    nibble

    Quark

    String

    Tension

    "Wait-till-last-minute"

    (83-code-reviews-in-2-days-on-urgent-project :sick::blink::unsure:)

    Ultimate tensile strength (UTS)

    Shear

    Sheep

    Lamb Chops

  • RE: Table Space growth based on each year

    So you're already gathering the data about the space used by each table? It sounds like you've got the hard part done already. Post the DDL for your...

  • RE: What can I do to speed up my production daily full-backup?

    What kind of disks are you backing up to? I've seen SAN drives run backups of the same database faster than local drives. When we switched to a...

  • RE: Table Space growth based on each year

    Same here. It allows you to track growth over time, but I only track databases. I don't go down to the table level, although it does sound like...

  • RE: Refresh Test from Prod

    Another thing to consider is the speed of your storage you're writing the backup to, copying it to and then reading it from. I've seen SAN volumes perform much...

  • RE: Sending out emails.

    I can't give you any advice on SSRS itself, but if you're using sp_send_dbmail to send your email, then you're probably using T-SQL to generate your list of recipients. ...

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    Eirikur Eiriksson (10/28/2015)


    Ed Wagner (10/28/2015)


    allnelsons (10/28/2015)


    So, question about these splitter functions (which are pretty much the most used tools in my arsenal, btw!), are they faster/more efficient being run from...

  • RE: Today's Random Word!

    Eirikur Eiriksson (10/28/2015)


    Jeff Moden (10/28/2015)


    Eirikur Eiriksson (10/28/2015)


    Ed Wagner (10/28/2015)


    Eirikur Eiriksson (10/28/2015)


    happygeek (10/28/2015)


    nibble

    Quark

    String

    Tension

    "Wait-till-last-minute"

    (83-code-reviews-in-2-days-on-urgent-project :sick::blink::unsure:)

    Ultimate tensile strength (UTS)

    Shear

  • RE: Today's Random Word!

    Eirikur Eiriksson (10/28/2015)


    happygeek (10/28/2015)


    nibble

    Quark

    String

  • RE: Refreshing a table using CREATE TABLE, DROP and Rename

    I have the same situation, but I don't rename the original. I create the temporary table and populate it, drop the original and rename the temporary one to the...

  • RE: Today's Random Word!

    crookj (10/28/2015)


    Revenant (10/28/2015)


    DonlSimpson (10/28/2015)


    Ed Wagner (10/28/2015)


    anthony.green (10/28/2015)


    Ed Wagner (10/28/2015)


    whereisSQL? (10/28/2015)


    anthony.green (10/28/2015)


    whereisSQL? (10/28/2015)


    crookj (10/28/2015)


    anthony.green (10/28/2015)


    Ed Wagner (10/28/2015)


    anthony.green (10/28/2015)


    Ed Wagner (10/28/2015)


    anthony.green (10/28/2015)


    Ed Wagner (10/28/2015)


    Sushi

    Wasabi

    Soy

    Bean

    Navy

    Sailor

    Pirate

    Eye-Patch

    Arrrrrrrrrrr

    Treasure

    Loot

    Classifieds

    Ad

    Subtract

    Number

    1024

    Byte

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (10/28/2015)


    At least some people have proper manners

    😎

    That type of thing is very nice to see. It conveys genuine gratitude. Thanks, Eirikur, for posting a link here.

Viewing 15 posts - 4,831 through 4,845 (of 9,399 total)