Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««4,5314,5324,5334,5344,535»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Sunday, August 24, 2014 9:39 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:03 AM
Points: 37,065, Visits: 31,628
Lynn Pettis (8/22/2014)
And Mr. Celko is back with his baseball bat.

In more than one thread.


Heh... they should just add him to the spammer's list except, in his case, it should be set to automatic.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1606956
Posted Monday, August 25, 2014 12:14 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:49 PM
Points: 23,396, Visits: 32,222
Oh dear, the backup process for the production database is changing the recovery model of the development database. Help me.

Really?? When did the The Thread start taking over peoples SQL Server systems? I mean, I know it is sentient, but did it start becoming a prankster?



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1607169
Posted Monday, August 25, 2014 12:35 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:49 PM
Points: 23,396, Visits: 32,222
Oh, and then we have the one backup routine for them all and all to one file. Oh, help me because this process has gone from running 1 hour to running 26 hours.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1607182
Posted Monday, August 25, 2014 12:45 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 6:50 AM
Points: 4,311, Visits: 3,352
Lynn Pettis (8/25/2014)
Oh, and then we have the one backup routine for them all and all to one file. Oh, help me because this process has gone from running 1 hour to running 26 hours.

I saw that thread earlier. The maintenance plan backups us all databases and funnels them into a single backup file. Sigh.



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1607192
Posted Monday, August 25, 2014 1:15 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 3:23 AM
Points: 1,951, Visits: 5,076
Don't think this needs any explanation, too funny


  Post Attachments 
NewLook.png (302 views, 2.18 KB)
Post #1607205
Posted Monday, August 25, 2014 2:26 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:23 PM
Points: 6,253, Visits: 7,428
TomThomson (8/22/2014)
Haven't noticed him recently on SQLServerCentral, though .


Oh, he's been around a while. He stopped at one point. I'd hoped they'd shut his account off.

*sigh* What died recently and resurrected the creature from the pit? I'm too busy to start up another verbal Carpet Bombing against him everywhere he goes. Someone else's turn.



- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1607243
Posted Monday, August 25, 2014 2:29 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:15 AM
Points: 42,994, Visits: 36,148
Lynn Pettis (8/25/2014)
Oh dear, the backup process for the production database is changing the recovery model of the development database. Help me.


I've seen that in production systems. Multiple times.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1607244
Posted Monday, August 25, 2014 3:58 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:49 PM
Points: 23,396, Visits: 32,222
Evil Kraig F (8/25/2014)
TomThomson (8/22/2014)
Haven't noticed him recently on SQLServerCentral, though .


Oh, he's been around a while. He stopped at one point. I'd hoped they'd shut his account off.

*sigh* What died recently and resurrected the creature from the pit? I'm too busy to start up another verbal Carpet Bombing against him everywhere he goes. Someone else's turn.


I apologize now for what I have done. I hope The Thread will forgive me.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1607277
Posted Monday, August 25, 2014 4:14 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 4:51 PM
Points: 21,733, Visits: 15,424
Lynn Pettis (8/25/2014)
Oh, and then we have the one backup routine for them all and all to one file. Oh, help me because this process has gone from running 1 hour to running 26 hours.



And to top it off all transaction log backups also go to the same file.

I have a vendor for a client that insists that it be done that way.




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


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 #1607282
Posted Monday, August 25, 2014 5:29 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 8:01 PM
Points: 8,823, Visits: 9,381
Evil Kraig F (8/25/2014)
TomThomson (8/22/2014)
Haven't noticed him recently on SQLServerCentral, though .


Oh, he's been around a while. He stopped at one point. I'd hoped they'd shut his account off.

*sigh* What died recently and resurrected the creature from the pit? I'm too busy to start up another verbal Carpet Bombing against him everywhere he goes. Someone else's turn.

I had a try today; he was advocating using a hash function to allocate unique tags, believe it or not, instead of dense_trank (which worked fine) as well as objecting to "record" and to duplicate rows. And doing it in a fairly unpleasant manner (albeit far from down to his frequent standard).
It was amusing to see the person he was biting join in and put him down - told him Lynn was helpful and he wasn't.


Tom
Post #1607301
« Prev Topic | Next Topic »

Add to briefcase «««4,5314,5324,5334,5344,535»»»

Permissions Expand / Collapse