Those Stubborn Database Rules - Finding Them and Scripting Them

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Scott Abrants » Those Stubborn Database Rules - Finding Them...

12 posts, Page 1 of 2

1 2 »»

Those Stubborn Database Rules - Finding Them and Scripting Them

Rate Topic

Display Mode

Topic Options

Author

Message

Scott Abrants

Posted Monday, January 04, 2010 9:23 PM

SSC Rookie

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:13 PM
Points: 43, Visits: 306

Comments posted to this topic are about the item Those Stubborn Database Rules - Finding Them and Scripting Them

Post #841835

Scott Abrants

Posted Tuesday, January 05, 2010 5:32 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:13 PM
Points: 43, Visits: 306

I want to thank Jon W. and Tom W. for helping edit this article before posting.

Post #841990

Grant Fritchey

Posted Tuesday, January 05, 2010 5:34 AM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 12:19 PM
Points: 13,371, Visits: 25,144

Nice article and useful for digging out those silly artifacts.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #841993

Scott Abrants

Posted Tuesday, January 05, 2010 5:36 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:13 PM
Points: 43, Visits: 306

Thank you Grant. I look forward to your presentation at Data Camp 2.0! Keep up the great work you do for the SQL Server community.

Post #841994

Grant Fritchey

Posted Tuesday, January 05, 2010 6:31 AM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 12:19 PM
Points: 13,371, Visits: 25,144

Thanks Scott. I'm looking forward to your presentation at Data Camp 2.0 as well. You need to keep up your work for the community also.

Now, I happen to be closely acquainted with the person setting up the schedule and I know that he's bribable. When did you want to put your presentation on? Was yours at the end of the day or right after lunch, I forget?

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #842022

Scott Abrants

Posted Tuesday, January 05, 2010 7:02 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:13 PM
Points: 43, Visits: 306

Any time slot is good as long as it is not the same time as yours because I am sure everyone will be at that one and the others will be empty. Very nice job on your latest book!

Post #842056

scunnin

Posted Tuesday, January 05, 2010 9:07 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 13, 2013 11:35 AM
Points: 1, Visits: 126

Good find. I believe you just saved me from a significant amount of future stress. I suspect that discovering the lack of support for rules on a future release would have been a painful experience.

Thanks.

Post #842169

SQLRNNR

Posted Tuesday, January 05, 2010 10:47 AM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 6:30 PM
Points: 18,733, Visits: 12,330

Nice article and good info.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #842248

Scott Abrants

Posted Tuesday, January 05, 2010 11:11 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:13 PM
Points: 43, Visits: 306

Thank you for the feedback. My intention is to write a follow up that will actually take the defined bindrules and script out proper constraints. What is interesting is how I ran into these in the first place. This issue came up because this database was created before I entered the picture and a non sql server resource defined the database. I think this is something we all have come across and knowing where the gotchas are is very important. I am planning on giving some of that back story in the follow up. Sound useful?

Post #842267

Giammarco Schisani

Posted Tuesday, January 05, 2010 5:20 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, February 08, 2010 5:40 PM
Points: 3, Visits: 12

Thanks for the article. Very useful. Looking forward for the followup.

_______________________
Giammarco Schisani
Volpet Software - Table Diff

Post #842503

« Prev Topic | Next Topic »

12 posts, Page 1 of 2

1 2 »»

Permissions