November 18, 2013 at 8:00 am
Koen Verbeeck (11/18/2013)
Went over 11,000 points a while back and I also managed to wringle myself into the top 10 (sorry Paul).😎 :w00t:
Congradulations, Koen. Well done.
November 18, 2013 at 9:30 am
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 18, 2013 at 10:27 am
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.
--------------------------------------
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
November 18, 2013 at 10:42 am
Koen Verbeeck (11/18/2013)
Went over 11,000 points a while back and I also managed to wringle myself into the top 10 (sorry Paul).😎 :w00t:
Congrats.
When do you plan to catch up with Gail?
And damn! You're getting too far ahead of me. I'll never catch up at this rate.
Tom
November 18, 2013 at 11:24 am
L' Eomot Inversé (11/18/2013)
Koen Verbeeck (11/18/2013)
Went over 11,000 points a while back and I also managed to wringle myself into the top 10 (sorry Paul).😎 :w00t:
Congrats.
When do you plan to catch up with Gail?
In about 40 years, when she's retired. 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 18, 2013 at 11:27 am
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 18, 2013 at 11:29 am
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
November 18, 2013 at 1:10 pm
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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 18, 2013 at 1:17 pm
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
November 19, 2013 at 9:03 am
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[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"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."
November 19, 2013 at 9:12 am
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. 😉
November 19, 2013 at 9:19 am
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.
November 19, 2013 at 9:22 am
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
November 19, 2013 at 9:35 am
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
Consultant - Straight Path Solutions
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
November 19, 2013 at 9:53 am
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
Viewing 15 posts - 42,166 through 42,180 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply