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,2164,2174,2184,2194,220»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Monday, November 18, 2013 11:27 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 7:40 AM
Points: 15,733, Visits: 28,134
Stefan Krzywicki (11/18/2013)
Grant Fritchey (11/18/2013)
I'm not aware of any major structural changes for partitioning in 2014, but I'm sitting at the MVP Summit, let me ask people...

No one is aware of anything like that. I'm with you partitioning can work to improve performance, but only after you set up all kinds of other stuff... and you have to really need it. Just partitioning, just because, no. It's not a performance enhancer in most cases. In fact, I wouldn't advocate for it for performance, ever. I'd advocate for it for management.


Thanks, the way he kept emphasizing it and saying everyone should be using it, I was thinking I'd gotten it all wrong.


That's odd. I'd want to push back on him to understand what he means.


----------------------------------------------------
"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 #1515318
Posted Monday, November 18, 2013 11:29 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:16 AM
Points: 2,777, Visits: 7,282
Grant Fritchey (11/18/2013)
Stefan Krzywicki (11/18/2013)
Grant Fritchey (11/18/2013)
I'm not aware of any major structural changes for partitioning in 2014, but I'm sitting at the MVP Summit, let me ask people...

No one is aware of anything like that. I'm with you partitioning can work to improve performance, but only after you set up all kinds of other stuff... and you have to really need it. Just partitioning, just because, no. It's not a performance enhancer in most cases. In fact, I wouldn't advocate for it for performance, ever. I'd advocate for it for management.


Thanks, the way he kept emphasizing it and saying everyone should be using it, I was thinking I'd gotten it all wrong.


That's odd. I'd want to push back on him to understand what he means.


Maybe I'll ask through the meetup site.


--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
Post #1515319
Posted Monday, November 18, 2013 1:10 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Yesterday @ 2:50 PM
Points: 21,744, Visits: 15,435
Stefan Krzywicki (11/18/2013)
Grant Fritchey (11/18/2013)
Stefan Krzywicki (11/18/2013)
Grant Fritchey (11/18/2013)
I'm not aware of any major structural changes for partitioning in 2014, but I'm sitting at the MVP Summit, let me ask people...

No one is aware of anything like that. I'm with you partitioning can work to improve performance, but only after you set up all kinds of other stuff... and you have to really need it. Just partitioning, just because, no. It's not a performance enhancer in most cases. In fact, I wouldn't advocate for it for performance, ever. I'd advocate for it for management.


Thanks, the way he kept emphasizing it and saying everyone should be using it, I was thinking I'd gotten it all wrong.


That's odd. I'd want to push back on him to understand what he means.


Maybe I'll ask through the meetup site.


Personally I thought it was more of a sales pitch. The deck he used was the sales slide deck after all.


And while on the topic of that UG meeting, I am sorry I did not meet you there. I don't know how I missed that one. It was on my todo list.

Wayne Sheffield and I were both at the meeting from out of town.




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 #1515336
Posted Monday, November 18, 2013 1:17 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:16 AM
Points: 2,777, Visits: 7,282
SQLRNNR (11/18/2013)
Stefan Krzywicki (11/18/2013)
Grant Fritchey (11/18/2013)
Stefan Krzywicki (11/18/2013)
Grant Fritchey (11/18/2013)
I'm not aware of any major structural changes for partitioning in 2014, but I'm sitting at the MVP Summit, let me ask people...

No one is aware of anything like that. I'm with you partitioning can work to improve performance, but only after you set up all kinds of other stuff... and you have to really need it. Just partitioning, just because, no. It's not a performance enhancer in most cases. In fact, I wouldn't advocate for it for performance, ever. I'd advocate for it for management.


Thanks, the way he kept emphasizing it and saying everyone should be using it, I was thinking I'd gotten it all wrong.


That's odd. I'd want to push back on him to understand what he means.


Maybe I'll ask through the meetup site.


Personally I thought it was more of a sales pitch. The deck he used was the sales slide deck after all.

And while on the topic of that UG meeting, I am sorry I did not meet you there. I don't know how I missed that one. It was on my todo list.

Wayne Sheffield and I were both at the meeting from out of town.


Oh, it certainly felt like a sales pitch, which is part of why I was so surprised he harped so strongly on using partitioning.


--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
Post #1515340
Posted Tuesday, November 19, 2013 9:03 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, September 11, 2014 7:42 PM
Points: 2,677, Visits: 19,269
L' Eomot Inversé (11/14/2013)
Lynn Pettis (11/13/2013)
Lynn Pettis (11/13/2013)
It is 23:27 Afghan time. Three minutes until my phone interview. Wish me luck!


Just finished the interview, and I feel like a Junior DBA. I have been working in to sheltered of an area far too long. I could not answer questions about SSRS, SSAS, Clustering, MS Replication. Very little was asked in areas that I feel strong in, T-SQL and tuning code.

I really need to learn more about best practices as well. Sad to be asked about them and not being able to rattle them off the top of my head. Hopefully I hit them even if inadvertently.

I feel very small at the moment.

Don't be silly Lynn, you've no excuse for feeling small. I agree with Grant and Jeff and the three others who have commented so far: your big, not small, in the SQL community.

For myself, I don't claim to understand the first thing about SSAS or SSRS or SSIS or DQS or SSDT. I know some relational theory, T-SQL, and snapshot and transactional replication. I haven't the first clue about clustering, and merge replication is a complete mystery to me. But I don't feel small - why should I? And if I don't, why should you?
As for best practices, I get the impression that you are quite hot on that area, at least so far as best SQL practices are concerend; I don't think I'd ask you about best practice for configuring RAID arrays or choice of network gear or configuring complex hardware geometries, but none of that is about best SQL Server practice. No-one expects you to be totally on top of best practice in every area of IT operations and development, with every type of technology - no-one expects it because (apart perhaps for the odd genius like Wilkes, and of course in his day there was far less of it him to know about) it isn't humanly possible.
"some"....Tom knows "some" of that. jeebus.


---------------------------------------------------------
How best to post your question
How to post performance problems
Tally Table:What it is and how it replaces a loop

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
Post #1515628
Posted Tuesday, November 19, 2013 9:12 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 6:12 AM
Points: 4,326, Visits: 3,366
jcrawf02 (11/19/2013)
L' Eomot Inversé (11/14/2013)
Lynn Pettis (11/13/2013)
Lynn Pettis (11/13/2013)
It is 23:27 Afghan time. Three minutes until my phone interview. Wish me luck!


Just finished the interview, and I feel like a Junior DBA. I have been working in to sheltered of an area far too long. I could not answer questions about SSRS, SSAS, Clustering, MS Replication. Very little was asked in areas that I feel strong in, T-SQL and tuning code.

I really need to learn more about best practices as well. Sad to be asked about them and not being able to rattle them off the top of my head. Hopefully I hit them even if inadvertently.

I feel very small at the moment.

Don't be silly Lynn, you've no excuse for feeling small. I agree with Grant and Jeff and the three others who have commented so far: your big, not small, in the SQL community.

For myself, I don't claim to understand the first thing about SSAS or SSRS or SSIS or DQS or SSDT. I know some relational theory, T-SQL, and snapshot and transactional replication. I haven't the first clue about clustering, and merge replication is a complete mystery to me. But I don't feel small - why should I? And if I don't, why should you?
As for best practices, I get the impression that you are quite hot on that area, at least so far as best SQL practices are concerend; I don't think I'd ask you about best practice for configuring RAID arrays or choice of network gear or configuring complex hardware geometries, but none of that is about best SQL Server practice. No-one expects you to be totally on top of best practice in every area of IT operations and development, with every type of technology - no-one expects it because (apart perhaps for the odd genius like Wilkes, and of course in his day there was far less of it him to know about) it isn't humanly possible.
"some"....Tom knows "some" of that. jeebus.

Yeah...Tom knows "some" of it, but no more than "some". Too bad we don't have a sarcasm icon.



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1515632
Posted Tuesday, November 19, 2013 9:19 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 7:25 AM
Points: 1,244, Visits: 6,683
Stefan Krzywicki (11/18/2013)
SQLRNNR (11/18/2013)
Stefan Krzywicki (11/18/2013)
Grant Fritchey (11/18/2013)
Stefan Krzywicki (11/18/2013)
Grant Fritchey (11/18/2013)
I'm not aware of any major structural changes for partitioning in 2014, but I'm sitting at the MVP Summit, let me ask people...

No one is aware of anything like that. I'm with you partitioning can work to improve performance, but only after you set up all kinds of other stuff... and you have to really need it. Just partitioning, just because, no. It's not a performance enhancer in most cases. In fact, I wouldn't advocate for it for performance, ever. I'd advocate for it for management.


Thanks, the way he kept emphasizing it and saying everyone should be using it, I was thinking I'd gotten it all wrong.


That's odd. I'd want to push back on him to understand what he means.


Maybe I'll ask through the meetup site.


Personally I thought it was more of a sales pitch. The deck he used was the sales slide deck after all.

And while on the topic of that UG meeting, I am sorry I did not meet you there. I don't know how I missed that one. It was on my todo list.

Wayne Sheffield and I were both at the meeting from out of town.


Oh, it certainly felt like a sales pitch, which is part of why I was so surprised he harped so strongly on using partitioning.


Unless maybe in MPP, where you are sending work to different physical machines.
I would like to see the examples, just to understand what I might be missing and could maybe leverage.

Only really have needed to partition by Dates, and since indexes covered this anyways, it was more for recovery.
We could easily do a partial build in case something went wrong in the main ETL.
This was important to us with a small window to process the cube every night.


Post #1515640
Posted Tuesday, November 19, 2013 9:22 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:16 AM
Points: 2,777, Visits: 7,282
Greg Edwards-268690 (11/19/2013)
Stefan Krzywicki (11/18/2013)
SQLRNNR (11/18/2013)
Stefan Krzywicki (11/18/2013)
Grant Fritchey (11/18/2013)
Stefan Krzywicki (11/18/2013)
Grant Fritchey (11/18/2013)
I'm not aware of any major structural changes for partitioning in 2014, but I'm sitting at the MVP Summit, let me ask people...

No one is aware of anything like that. I'm with you partitioning can work to improve performance, but only after you set up all kinds of other stuff... and you have to really need it. Just partitioning, just because, no. It's not a performance enhancer in most cases. In fact, I wouldn't advocate for it for performance, ever. I'd advocate for it for management.


Thanks, the way he kept emphasizing it and saying everyone should be using it, I was thinking I'd gotten it all wrong.


That's odd. I'd want to push back on him to understand what he means.


Maybe I'll ask through the meetup site.


Personally I thought it was more of a sales pitch. The deck he used was the sales slide deck after all.

And while on the topic of that UG meeting, I am sorry I did not meet you there. I don't know how I missed that one. It was on my todo list.

Wayne Sheffield and I were both at the meeting from out of town.


Oh, it certainly felt like a sales pitch, which is part of why I was so surprised he harped so strongly on using partitioning.


Unless maybe in MPP, where you are sending work to different physical machines.
I would like to see the examples, just to understand what I might be missing and could maybe leverage.

Only really have needed to partition by Dates, and since indexes covered this anyways, it was more for recovery.
We could easily do a partial build in case something went wrong in the main ETL.
This was important to us with a small window to process the cube every night.




I asked. He linked me to a white paper on partitioning. I think someone else told him that and he was just repeating what he'd heard.


--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
Post #1515643
Posted Tuesday, November 19, 2013 9:35 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:47 AM
Points: 11,307, Visits: 13,096


Unless maybe in MPP, where you are sending work to different physical machines.
I would like to see the examples, just to understand what I might be missing and could maybe leverage.

Only really have needed to partition by Dates, and since indexes covered this anyways, it was more for recovery.
We could easily do a partial build in case something went wrong in the main ETL.
This was important to us with a small window to process the cube every night.




Was it this white paper, Partitioned Table and Index Strategies Using SQL Server 2008? I did a quick re-look at that and it doesn't mention anywhere that you should partition everything.




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1515653
Posted Tuesday, November 19, 2013 9:53 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:16 AM
Points: 2,777, Visits: 7,282
Jack Corbett (11/19/2013)


Unless maybe in MPP, where you are sending work to different physical machines.
I would like to see the examples, just to understand what I might be missing and could maybe leverage.

Only really have needed to partition by Dates, and since indexes covered this anyways, it was more for recovery.
We could easily do a partial build in case something went wrong in the main ETL.
This was important to us with a small window to process the cube every night.




Was it this white paper, Partitioned Table and Index Strategies Using SQL Server 2008? I did a quick re-look at that and it doesn't mention anywhere that you should partition everything.


Yup, that's the one.


--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
Post #1515660
« Prev Topic | Next Topic »

Add to briefcase «««4,2164,2174,2184,2194,220»»»

Permissions Expand / Collapse