SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 The Yak Corral
 Twit List
 New Topic  Reply to Topic
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 88

RickD
Slow But Sure Yak Herding Master

United Kingdom
3608 Posts

Posted - 07/14/2010 :  09:17:05  Show Profile  Reply with Quote
Should have got him to turn on Recursive triggers..
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 07/14/2010 :  10:44:30  Show Profile  Reply with Quote
It crossed my mind. But then the next question would be "It only works for 64 minutes" ... or whatever the recursion limit is.
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

United Kingdom
3608 Posts

Posted - 07/14/2010 :  10:58:37  Show Profile  Reply with Quote
Yeah, but you'd get an hour of peace, even longer if he is on 64 bit.

Then you'd just get (in a day or so), "My server seems to be running really slowly, not sure why, can you help?".
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30265 Posts

Posted - 07/14/2010 :  15:11:13  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Slow? Regarding locks during the transaction length, his database will be completely stopped...
That would be fun.


N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 07/22/2010 :  11:35:04  Show Profile  Reply with Quote
"I want to shrink my database"

"Its a bad idea"

"I want to shrink my database"

"Its a bad idea because ..."

"I want to shrink my database"

"Here's a more detailed explanation of why its a bad idea ..."

"I want to shrink my database"

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=147587

Your turn!
Go to Top of Page

webfred
Flowing Fount of Yak Knowledge

Germany
8765 Posts

Posted - 07/22/2010 :  12:26:30  Show Profile  Visit webfred's Homepage  Reply with Quote
delicious


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

robvolk
Most Valuable Yak

USA
15676 Posts

Posted - 07/22/2010 :  12:38:59  Show Profile  Visit robvolk's Homepage  Reply with Quote
My turn?

If you broke a mirror on Friday the 13th while walking under a ladder indoors while opening an umbrella and a black cat ran across your path, shrinking your database would still be worse luck.
Go to Top of Page

webfred
Flowing Fount of Yak Knowledge

Germany
8765 Posts

Posted - 07/22/2010 :  12:48:25  Show Profile  Visit webfred's Homepage  Reply with Quote
That would be a good idea for a signature


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

webfred
Flowing Fount of Yak Knowledge

Germany
8765 Posts

Posted - 07/22/2010 :  12:51:35  Show Profile  Visit webfred's Homepage  Reply with Quote
There is another thing which will perform much better if it is not shrinking...maybe that is a convincing argument?


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

robvolk
Most Valuable Yak

USA
15676 Posts

Posted - 07/22/2010 :  13:06:02  Show Profile  Visit robvolk's Homepage  Reply with Quote
I just posted Paul Randal's blog entry on why not to shrink. Hopefully that will sink in.
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 07/22/2010 :  14:52:15  Show Profile  Reply with Quote
I hope it will shrink in too. Hic!
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 07/22/2010 :  18:33:19  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Deja vu. Got a very similar one over at SSC. Also really, really, really wants to shrink the DB after the index rebuild.
http://www.sqlservercentral.com/Forums/Topic956921-145-1.aspx

--
Gail Shaw
SQL Server MVP
Go to Top of Page

robvolk
Most Valuable Yak

USA
15676 Posts

Posted - 07/22/2010 :  21:18:33  Show Profile  Visit robvolk's Homepage  Reply with Quote
I can't be too harsh on him, I use to shrink after reindexing at my old job. Problem was, I had a server I couldn't replace with disks I couldn't replace and weren't big enough. Fortunately I don't work there anymore and they finally got a replacement server (after I leave of course)
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 07/22/2010 :  22:07:03  Show Profile  Visit russell's Homepage  Reply with Quote
I walked into a client and they had a scheduled job to run every night -- truncate the log on every db, then shrink it.

of course every db was in full and there were no tran log backups. that one made me smile
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30265 Posts

Posted - 08/19/2010 :  07:52:04  Show Profile  Visit SwePeso's Homepage  Reply with Quote
It's a very simple problem dear folks
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=149012



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

jen
Flowing Fount of Yak Knowledge

Sweden
4110 Posts

Posted - 08/19/2010 :  10:08:33  Show Profile  Send jen a Yahoo! Message  Reply with Quote
no endearments in your post Peso? I think your reply will be accepted without question if you start it with...

Dear, the answer is...

--------------------
keeping it simple...
Go to Top of Page

robvolk
Most Valuable Yak

USA
15676 Posts

Posted - 08/19/2010 :  16:15:22  Show Profile  Visit robvolk's Homepage  Reply with Quote
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=149025

<Kenny Rogers> You got to know when to hold 'em, know when to fold 'em... </Kenny Rogers>
Go to Top of Page

robvolk
Most Valuable Yak

USA
15676 Posts

Posted - 09/08/2010 :  13:28:10  Show Profile  Visit robvolk's Homepage  Reply with Quote
File this under "I'm not even gonna try":

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=149873

Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37143 Posts

Posted - 09/08/2010 :  13:34:14  Show Profile  Visit tkizer's Homepage  Reply with Quote
quote:
Originally posted by robvolk

File this under "I'm not even gonna try":

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=149873



Like I said in the 29k thread, I answer the easy ones.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

sqlscottgleason
Starting Member

USA
1 Posts

Posted - 09/11/2010 :  13:50:00  Show Profile  Reply with Quote
Here is a little video for them from
"The SQL Super Hero's Cave of Best Practices"

http://www.youtube.com/watch?v=SZRWAaDVmAs&feature=youtu.be

All DBAs should get at least a smerk (if not a full ROFLOL) from this vid.

Scott Gleason
Go to Top of Page
Page: of 88 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.19 seconds. Powered By: Snitz Forums 2000