Auditing Foundation

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Steve Jones » Auditing Foundation

14 posts, Page 1 of 2

1 2 »»

Auditing Foundation

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Thursday, July 22, 2010 11:22 PM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 8:29 AM
Points: 31,667, Visits: 16,127

Comments posted to this topic are about the item Auditing Foundation

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #957764

UMG Developer

Posted Thursday, July 22, 2010 11:23 PM

SSCrazy

Group: General Forum Members
Last Login: Friday, September 5, 2014 2:00 PM
Points: 2,160, Visits: 2,191

Nice question, thanks! I like the questions that bring up new features to help keep us up to date even if we might not have had the chance to upgrade yet.

Post #957766

Paul White

Posted Friday, July 23, 2010 4:34 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Thursday, February 26, 2015 11:19 PM
Points: 9,928, Visits: 11,237

Lucky guess - didn't know for sure. Good question!

Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi

Post #957862

Ninja's_RGR'us

Posted Friday, July 23, 2010 5:11 AM

SSC-Insane

Group: General Forum Members
Last Login: 2 days ago @ 11:30 PM
Points: 20,622, Visits: 9,642

What the heck is sql traps w00t

???

Post #957878

OCTom

Posted Friday, July 23, 2010 6:29 AM

SSCrazy

Group: General Forum Members
Last Login: Friday, January 30, 2015 7:36 AM
Points: 2,723, Visits: 4,152

Ninja's_RGR'us (7/23/2010)

What the heck is sql traps w00t

???

They catch the rodents running around the database. You have your choice of humane live traps, which became available in SQL Server 2008, or, the old spring-loaded traps which kills the rodent instantly.

What we do here is use the live traps and release them in a database on a server that's disconnected from the network. They eventually get released into the cloud.

Post #957908

ben-637808

Posted Friday, July 23, 2010 6:49 AM

SSC Eights!

Group: General Forum Members
Last Login: Thursday, February 12, 2015 1:15 AM
Points: 983, Visits: 586

SQL 2008 R2 adds the ability to use the captured rodents to automatically find missing indexes and delete those no longer used with no overhead other than the occasional cheesy snack. Unfortunately that's only available in the Enterprise Edition.

Post #957919

Daniel Bowlin

Posted Friday, July 23, 2010 7:03 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, February 25, 2015 9:11 AM
Points: 2,818, Visits: 2,574

Good question thanks. I had to read just a bit to confirm what I thought I knew. Keep pushing newer features with QoTD, it helps us all stay/get current and become even better.

Post #957928