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,1424,1434,1444,1454,146»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Thursday, September 26, 2013 8:04 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 3:26 PM
Points: 597, Visits: 7,195
Jeff Moden (9/26/2013)
Jack Corbett (9/25/2013)
GilaMonster (9/25/2013)
Someone want to add a voice of reason to this?
http://www.sqlservercentral.com/Forums/Topic1493948-391-1.aspx


I'd try but that tempDB thread has worn me out.


Is that the one where the fellow didn't understand than any TempDB settings made without a reasonable history were purely a SWAG ad someone else chimed in with recommending a 50MB intial setting for the MDF?


Well, if someone's going to be using SWAG, hopefully they also use the YOLO (You Only Lock Once) parameter, too!

... Ok, hit me with the orbital pork chops now




-
Post #1498867
Posted Thursday, September 26, 2013 8:34 AM


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 @ 8:36 AM
Points: 40,615, Visits: 37,080
Jeff Moden (9/26/2013)
Jack Corbett (9/25/2013)
GilaMonster (9/25/2013)
Someone want to add a voice of reason to this?
http://www.sqlservercentral.com/Forums/Topic1493948-391-1.aspx


I'd try but that tempDB thread has worn me out.


Is that the one where the fellow didn't understand than any TempDB settings made without a reasonable history were purely a SWAG ad someone else chimed in with recommending a 50MB intial setting for the MDF?


Yup, but two other people unless I'm mistaken.



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 #1498887
Posted Thursday, September 26, 2013 8:55 AM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 7:27 AM
Points: 35,769, Visits: 32,437
GilaMonster (9/26/2013)
Jeff Moden (9/26/2013)
Jack Corbett (9/25/2013)
GilaMonster (9/25/2013)
Someone want to add a voice of reason to this?
http://www.sqlservercentral.com/Forums/Topic1493948-391-1.aspx


I'd try but that tempDB thread has worn me out.


Is that the one where the fellow didn't understand than any TempDB settings made without a reasonable history were purely a SWAG ad someone else chimed in with recommending a 50MB intial setting for the MDF?


Yup, but two other people unless I'm mistaken.


Yeh... that was a bit crazy. I got a bunch o' PMs from the OP, as well. That one person who pointed to one of Paul's articles as the "source" of the 50MB intial size recommendation was absolutely "precious".


--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 #1498897
Posted Thursday, September 26, 2013 9:10 AM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 7:27 AM
Points: 35,769, Visits: 32,437
Jeff Moden (9/26/2013)
GilaMonster (9/26/2013)
Jeff Moden (9/26/2013)
Jack Corbett (9/25/2013)
GilaMonster (9/25/2013)
Someone want to add a voice of reason to this?
http://www.sqlservercentral.com/Forums/Topic1493948-391-1.aspx


I'd try but that tempDB thread has worn me out.


Is that the one where the fellow didn't understand than any TempDB settings made without a reasonable history were purely a SWAG ad someone else chimed in with recommending a 50MB intial setting for the MDF?


Yup, but two other people unless I'm mistaken.


Yeh... that was a bit crazy. I got a bunch o' PMs from the OP, as well. That one person who pointed to one of Paul's articles as the "source" of the 50MB intial size recommendation was absolutely "precious".


Heh... I shouldn't have looked. Guess I'm a glutton for punishment. I just saw that second person who joined in with the 50MB initial size recommendation. I wonder where people get these notions. I won't mention the author but I do remember one famous SQL book that recommended that you didn't have to worry about presizing databases because the default autogrowth would take care of all that.

Hmmm... I just might have to build a pork chop launcher with more of a range to it.


--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 #1498910
Posted Thursday, September 26, 2013 9:21 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 3:20 PM
Points: 18,064, Visits: 16,099
GilaMonster (9/18/2013)
Stefan Krzywicki (9/18/2013)
GilaMonster (9/18/2013)
L' Eomot Inversé (9/18/2013)
Don't need to is surely an understatement: you are not allowed to, I think?


If you mean the SELECT * INTO, unfortunately that's allowed. I've cleaned so many of those out of client code.


I can't convince them that SELECT * INTO is bad.


May I suggest a cricket bat?


Can each of us take turns with the bat?




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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1498918
Posted Thursday, September 26, 2013 9:23 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 3:20 PM
Points: 18,064, Visits: 16,099
hisakimatama (9/20/2013)
*Huff* *Wheeze* I... I did it! I managed to read the entirety of The Thread! That was... Interesting . Been lurking around here, being generally amazed at the questions posted and everyone's unwavering insistence on being helpful despite the odds. The community here is great indeed.

I may chime in here a bit here and there, if you all won't mind, and if the rollercoaster of subjects strikes my fancy. Hopefully I won't eat a high-velocity pork chop or two in the near future


Are you still sane?




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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1498920
Posted Thursday, September 26, 2013 9:38 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 3:26 PM
Points: 597, Visits: 7,195
SQLRNNR (9/26/2013)
hisakimatama (9/20/2013)
*Huff* *Wheeze* I... I did it! I managed to read the entirety of The Thread! That was... Interesting . Been lurking around here, being generally amazed at the questions posted and everyone's unwavering insistence on being helpful despite the odds. The community here is great indeed.

I may chime in here a bit here and there, if you all won't mind, and if the rollercoaster of subjects strikes my fancy. Hopefully I won't eat a high-velocity pork chop or two in the near future


Are you still sane?


Well, after reading so many posts about kilts, pork chops, Cthulhu, DBCC TimeWarp, hamster poo, and considering my last post in the thread... Probably not




-
Post #1498933
Posted Thursday, September 26, 2013 10:22 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 3:20 PM
Points: 18,064, Visits: 16,099
Steve Jones - SSC Editor (9/25/2013)
No need for a potato gun, lathe, or automation.

If you need it peeled, find someone that deserves a little punishment. Kids are good for this, but the rogue developer who's introduced too many bugs works just as well. Deploy paring knife and well wishes.

If you want to hit something with a flying potato, throw it.


I like that idea. Mess duty for bad developers. S-w-eeeeeee-t




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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1498954
Posted Thursday, September 26, 2013 10:25 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 3:20 PM
Points: 18,064, Visits: 16,099
hisakimatama (9/26/2013)
SQLRNNR (9/26/2013)
hisakimatama (9/20/2013)
*Huff* *Wheeze* I... I did it! I managed to read the entirety of The Thread! That was... Interesting . Been lurking around here, being generally amazed at the questions posted and everyone's unwavering insistence on being helpful despite the odds. The community here is great indeed.

I may chime in here a bit here and there, if you all won't mind, and if the rollercoaster of subjects strikes my fancy. Hopefully I won't eat a high-velocity pork chop or two in the near future


Are you still sane?


Well, after reading so many posts about kilts, pork chops, Cthulhu, DBCC TimeWarp, hamster poo, and considering my last post in the thread... Probably not


Wow - I'd forgotten all about those lonely hamsters.




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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1498955
Posted Thursday, September 26, 2013 10:29 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 5:19 PM
Points: 20,859, Visits: 32,882
hisakimatama (9/26/2013)
SQLRNNR (9/26/2013)
hisakimatama (9/20/2013)
*Huff* *Wheeze* I... I did it! I managed to read the entirety of The Thread! That was... Interesting . Been lurking around here, being generally amazed at the questions posted and everyone's unwavering insistence on being helpful despite the odds. The community here is great indeed.

I may chime in here a bit here and there, if you all won't mind, and if the rollercoaster of subjects strikes my fancy. Hopefully I won't eat a high-velocity pork chop or two in the near future


Are you still sane?


Well, after reading so many posts about kilts, pork chops, Cthulhu, DBCC TimeWarp, hamster poo, and considering my last post in the thread... Probably not



What?? No mention of the Tent in the Desert and its Guard Hippo????!!!!????




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 #1498956
« Prev Topic | Next Topic »

Add to briefcase «««4,1424,1434,1444,1454,146»»»

Permissions Expand / Collapse