| Author |
 Topic  |
|
RickD
Slow But Sure Yak Herding Master
United Kingdom
3560 Posts |
 Posted - 07/14/2010 : 09:17:05
|
Should have got him to turn on Recursive triggers..  |
 |
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 07/14/2010 : 10:44:30
|
| It crossed my mind. But then the next question would be "It only works for 64 minutes" ... or whatever the recursion limit is. |
|
|
|
RickD
Slow But Sure Yak Herding Master
United Kingdom
3560 Posts |
Posted - 07/14/2010 : 10:58:37
|
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?". |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 07/14/2010 : 15:11:13
|
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" |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 07/22/2010 : 11:35:04
|
"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! |
|
|
|
webfred
Flowing Fount of Yak Knowledge
Germany
8515 Posts |
Posted - 07/22/2010 : 12:26:30
|
delicious 
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
robvolk
Most Valuable Yak
USA
15559 Posts |
Posted - 07/22/2010 : 12:38:59
|
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. |
|
|
|
webfred
Flowing Fount of Yak Knowledge
Germany
8515 Posts |
Posted - 07/22/2010 : 12:48:25
|
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. |
|
|
|
webfred
Flowing Fount of Yak Knowledge
Germany
8515 Posts |
Posted - 07/22/2010 : 12:51:35
|
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. |
|
|
|
robvolk
Most Valuable Yak
USA
15559 Posts |
Posted - 07/22/2010 : 13:06:02
|
| I just posted Paul Randal's blog entry on why not to shrink. Hopefully that will sink in. |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 07/22/2010 : 14:52:15
|
| I hope it will shrink in too. Hic! |
|
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
|
|
robvolk
Most Valuable Yak
USA
15559 Posts |
Posted - 07/22/2010 : 21:18:33
|
| 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) |
|
|
|
russell
Pyro-ma-ni-yak
USA
4993 Posts |
Posted - 07/22/2010 : 22:07:03
|
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
 |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
|
|
jen
Flowing Fount of Yak Knowledge
Sweden
4110 Posts |
Posted - 08/19/2010 : 10:08:33
|
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... |
|
|
|
robvolk
Most Valuable Yak
USA
15559 Posts |
|
|
robvolk
Most Valuable Yak
USA
15559 Posts |
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
sqlscottgleason
Starting Member
USA
1 Posts |
|
|
Topic |
|
Twit List
Scott Gleason