November 21, 2013 at 10:18 am
rodjkidd (11/21/2013)
GilaMonster (11/21/2013)
Stefan Krzywicki (11/21/2013)
I think you might be able to get some performance benefit if you choose your partition column very carefully.Maybe. Depends on the query forms
If you find what your most used or slowest or most important query parameter is and partition by that, you could see a performance benefit from it on those queries.
Probably not
https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/
Excellent article as usual there Gail!
Problem here is the business is looking for a "this will make it faster" answer, and I'm saying it could help, we need to run some tests... Oh is that a "it depends", I think it is 🙂
Business is always looking for the "make it faster" answer to everything and it shouldn't take any time or testing to implement. In fact, it should have already been done. :w00t:
November 21, 2013 at 10:23 am
Ed Wagner (11/21/2013)
rodjkidd (11/21/2013)
GilaMonster (11/21/2013)
Stefan Krzywicki (11/21/2013)
I think you might be able to get some performance benefit if you choose your partition column very carefully.Maybe. Depends on the query forms
If you find what your most used or slowest or most important query parameter is and partition by that, you could see a performance benefit from it on those queries.
Probably not
https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/
Excellent article as usual there Gail!
Problem here is the business is looking for a "this will make it faster" answer, and I'm saying it could help, we need to run some tests... Oh is that a "it depends", I think it is 🙂
Business is always looking for the "make it faster" answer to everything and it shouldn't take any time or testing to implement. In fact, it should have already been done. :w00t:
I call it the MS Project school of management: "All QA will be done on Thursday afternoon and we will launch on Friday."
November 21, 2013 at 10:32 am
Revenant (11/21/2013)
Ed Wagner (11/21/2013)
rodjkidd (11/21/2013)
GilaMonster (11/21/2013)
Stefan Krzywicki (11/21/2013)
I think you might be able to get some performance benefit if you choose your partition column very carefully.Maybe. Depends on the query forms
If you find what your most used or slowest or most important query parameter is and partition by that, you could see a performance benefit from it on those queries.
Probably not
https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/
Excellent article as usual there Gail!
Problem here is the business is looking for a "this will make it faster" answer, and I'm saying it could help, we need to run some tests... Oh is that a "it depends", I think it is 🙂
Business is always looking for the "make it faster" answer to everything and it shouldn't take any time or testing to implement. In fact, it should have already been done. :w00t:
I call it the MS Project school of management: "All QA will be done on Thursday afternoon and we will launch on Friday."
That's about accurate. And we should do all our production releases on Friday afternoon after people have left early. Oh, wait...didn't we get rid of the entire QA team in the interests of saving money? That's okay, it went through the QA phase, so that's good enough, isn't it?
November 21, 2013 at 11:57 am
rodjkidd (11/21/2013)
Problem here is the business is looking for a "this will make it faster" answer, and I'm saying it could help, we need to run some tests... Oh is that a "it depends", I think it is 🙂
tbh, the answer should be 'This probably won't make things noticeably faster unless we take a great deal of time to change the queries to benefit from the partitioning. Is such a large query refactoring in scope?
🙁 about the photos. I have about 2 photos of me from PASS.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 21, 2013 at 1:16 pm
Gotta love situations like this...
Please install this program to make it easier for us to make your server (OS) more secure that requires this OS feature you've never needed before (.NET4)
Followed by:
OH GAWD LOOK AT ALL THESE VULNERABILITIES IN .NET4 THAT YOU'VE NOT PATCHED YET!!!
Thank any deity I can think of that they're not pushing to get this installed NOW.
I've already put it on several of my QA boxes just to make sure it wouldn't hose SQL. Thinking (planning) to wait on production until the next round of MS patches come out...
November 21, 2013 at 1:19 pm
jasona.work (11/21/2013)
Gotta love situations like this...Please install this program to make it easier for us to make your server (OS) more secure that requires this OS feature you've never needed before (.NET4)
Followed by:
OH GAWD LOOK AT ALL THESE VULNERABILITIES IN .NET4 THAT YOU'VE NOT PATCHED YET!!!
Thank any deity I can think of that they're not pushing to get this installed NOW.
I've already put it on several of my QA boxes just to make sure it wouldn't hose SQL. Thinking (planning) to wait on production until the next round of MS patches come out...
That prompt doesn't inspire your confidence?
November 22, 2013 at 7:54 am
I got to meet another Threadizen last night. Revenant is doing some seriously wild stuff with the technology we all use. If you get the chance to talk to him about it, do so.
Thanks for coming out and hanging out with me.
Now... I need DBCC TIMEWARP so I can get home faster. I'm truly sick of being on the road. Where did you guys put the security certificate?
"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 22, 2013 at 8:40 am
Grant Fritchey (11/22/2013)
I got to meet another Threadizen last night. Revenant is doing some seriously wild stuff with the technology we all use. If you get the chance to talk to him about it, do so.Thanks for coming out and hanging out with me.
Now... I need DBCC TIMEWARP so I can get home faster. I'm truly sick of being on the road. Where did you guys put the security certificate?
We put it in the cloud, in a SQL Azure Database. You know about those, right? :w00t:
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
November 22, 2013 at 8:42 am
All, on that project, basically the first person to work on this said here are x number of things you can do that will make it faster! And the project has always been based around that.
Had a meeting about it this morning, they have a fixed date in the sand and will go live regardless and will take the hit afterwards!
The new test server may be in place before go live, so make of that what you want.
Had kick off of new project, only I didn't! Project manager forgot to invite two stakeholders and realised another was on holiday. So that was a good start. It lasted less than 5 minutes. So about par the course for here.
I also worked on an SSIS package for speeding up the import. They have only implemented for the first part of this due to lack of testing and the deadline. The first part runs significantly faster, a sixth of the time, but then relies on a set of stored procs that take the data apart RBAR! They have decided that's fast enough. Oh well.
Gail. Right well I think I may have a few others of you around the event. But I'll send what I have, including the best of he the bunch from the dodgy set, I'll do a bit of post prod work, and see what comes out!
Rodders...
November 22, 2013 at 10:54 am
Grant Fritchey (11/22/2013)
I got to meet another Threadizen last night. Revenant is doing some seriously wild stuff with the technology we all use. If you get the chance to talk to him about it, do so.Thanks for coming out and hanging out with me.
Now... I need DBCC TIMEWARP so I can get home faster. I'm truly sick of being on the road. Where did you guys put the security certificate?
Oops - the security certificate has expired. Was it my turn to renew it?
Jason Wolfkill
November 22, 2013 at 11:18 am
Well, doing the job search thing is tedious. Thinking about applying for this position but pretty sure I only meet half the requirements. I think this company is either looking for Superman or actually needs at least two people to fulfill the requirements:
About The Position
We are currently seeking a dynamic Database Programmer Analyst III to join our team at our office in Colorado Springs, Colorado. The Database Programmer Analyst III will provide technical leadership in the advancement of application and reporting systems at ValueOptions, Colorado.
Position Responsibilities
Will adhere to solid SDLC principles and practices for software delivery and support.
Subscribe to a methodology that includes, but is not limited to, requirements gathering, analysis and design, coding and testing, documentation, implementation and support.
Assess, prioritize and delegate development tasks, activities and deliverables.
Must be a mentor to other staff members and be a strong customer advocate.
Will see the big picture, and develop implementation plans accordingly.
Education
Bachelor's degree in computer science.
Relevant Work Experience
Eight to ten years database programming experience using two or more of the following databases; MS SQL Server, Oracle, Sybase, Informix, DB2. Ten years using two or more of the following programming languages, including associated IDE's and development tools; Perl, ColdFusion, Java, C++, Visual basic, ASP. Eight+ years in the following web technologies; ColdFusion, ASP, Apache, IIS, html, CGI, TCP/IP, ODBC, Java Script. XML experience is a plus, but not necessary. 10-12 years of software development leading to a senior software developer position.
Knowledge, Skills & Abilities
Application reengineering to include database upgrades and conversion.
Application and database troubleshooting
Developed and supported n-tier architectures
EDI and health Care a plus, especially knowledge of ANSI X12 v5010 standards (837s, 834s, 820s, 999s, 277s, etc.)
Organize and prioritize tasks and deliverables
Adaptable to new technologies and IT practices
November 22, 2013 at 11:30 am
Lynn Pettis (11/22/2013)
Well, doing the job search thing is tedious. Thinking about applying for this position but pretty sure I only meet half the requirements. I think this company is either looking for Superman or actually needs at least two people to fulfill the requirements:About The Position
We are currently seeking a dynamic Database Programmer Analyst III to join our team at our office in Colorado Springs, Colorado. The Database Programmer Analyst III will provide technical leadership in the advancement of application and reporting systems at ValueOptions, Colorado.
Position Responsibilities
Will adhere to solid SDLC principles and practices for software delivery and support.
Subscribe to a methodology that includes, but is not limited to, requirements gathering, analysis and design, coding and testing, documentation, implementation and support.
Assess, prioritize and delegate development tasks, activities and deliverables.
Must be a mentor to other staff members and be a strong customer advocate.
Will see the big picture, and develop implementation plans accordingly.
Education
Bachelor's degree in computer science.
Relevant Work Experience
Eight to ten years database programming experience using two or more of the following databases; MS SQL Server, Oracle, Sybase, Informix, DB2. Ten years using two or more of the following programming languages, including associated IDE's and development tools; Perl, ColdFusion, Java, C++, Visual basic, ASP. Eight+ years in the following web technologies; ColdFusion, ASP, Apache, IIS, html, CGI, TCP/IP, ODBC, Java Script. XML experience is a plus, but not necessary. 10-12 years of software development leading to a senior software developer position.
Knowledge, Skills & Abilities
Application reengineering to include database upgrades and conversion.
Application and database troubleshooting
Developed and supported n-tier architectures
EDI and health Care a plus, especially knowledge of ANSI X12 v5010 standards (837s, 834s, 820s, 999s, 277s, etc.)
Organize and prioritize tasks and deliverables
Adaptable to new technologies and IT practices
It sounds like they want somebody who can at least understand both the database side and the application side of things. The question is whether they want a wiz at DB development who understands the application stuff or an application wiz who understands the database stuff. (If they want someone who is simultaneously a DB wiz and an application wiz, they'll have a hard time finding one.) You've got the DB side down. I'd say that if you feel comfortable having even a very basic conversation about the concepts and principles of some of the other stuff, go for it. If what they really need is a DB wiz, you'll be a good candidate. If what they really need is a ninja application coder, it's probably not the right fit for you anyway.
Jason Wolfkill
November 22, 2013 at 11:47 am
wolfkillj (11/22/2013)
Lynn Pettis (11/22/2013)
Well, doing the job search thing is tedious. Thinking about applying for this position but pretty sure I only meet half the requirements. I think this company is either looking for Superman or actually needs at least two people to fulfill the requirements:About The Position
We are currently seeking a dynamic Database Programmer Analyst III to join our team at our office in Colorado Springs, Colorado. The Database Programmer Analyst III will provide technical leadership in the advancement of application and reporting systems at ValueOptions, Colorado.
Position Responsibilities
Will adhere to solid SDLC principles and practices for software delivery and support.
Subscribe to a methodology that includes, but is not limited to, requirements gathering, analysis and design, coding and testing, documentation, implementation and support.
Assess, prioritize and delegate development tasks, activities and deliverables.
Must be a mentor to other staff members and be a strong customer advocate.
Will see the big picture, and develop implementation plans accordingly.
Education
Bachelor's degree in computer science.
Relevant Work Experience
Eight to ten years database programming experience using two or more of the following databases; MS SQL Server, Oracle, Sybase, Informix, DB2. Ten years using two or more of the following programming languages, including associated IDE's and development tools; Perl, ColdFusion, Java, C++, Visual basic, ASP. Eight+ years in the following web technologies; ColdFusion, ASP, Apache, IIS, html, CGI, TCP/IP, ODBC, Java Script. XML experience is a plus, but not necessary. 10-12 years of software development leading to a senior software developer position.
Knowledge, Skills & Abilities
Application reengineering to include database upgrades and conversion.
Application and database troubleshooting
Developed and supported n-tier architectures
EDI and health Care a plus, especially knowledge of ANSI X12 v5010 standards (837s, 834s, 820s, 999s, 277s, etc.)
Organize and prioritize tasks and deliverables
Adaptable to new technologies and IT practices
It sounds like they want somebody who can at least understand both the database side and the application side of things. The question is whether they want a wiz at DB development who understands the application stuff or an application wiz who understands the database stuff. (If they want someone who is simultaneously a DB wiz and an application wiz, they'll have a hard time finding one.) You've got the DB side down. I'd say that if you feel comfortable having even a very basic conversation about the concepts and principles of some of the other stuff, go for it. If what they really need is a DB wiz, you'll be a good candidate. If what they really need is a ninja application coder, it's probably not the right fit for you anyway.
I agree that they're looking for someone who knows both sides of the world (database and application) but it isn't clear which expertise they're really seeking. It looks like a "working manager" position to me - someone who leads a team and also does work.
They cover a group of database database platforms, but they probably don't need them all.
They cover a group of development environments and languages, but they probably don't need them all.
The alphabet soup of technology is pretty normal, but they probably don't need them all.
The things that really stand out to me are ColdFusion and EDI.
I see the bottom line as they want someone with a decent amount of experience and not a newbie. It's in the location you want and it won't cost you anything to apply, right? It might turn out to be worth it. If it isn't a good fit, you don't have to accept the position.
November 22, 2013 at 12:17 pm
Lynn Pettis (11/22/2013)
Well, doing the job search thing is tedious. Thinking about applying for this position but pretty sure I only meet half the requirements. I think this company is either looking for Superman or actually needs at least two people to fulfill the requirements:About The Position
We are currently seeking a dynamic Database Programmer Analyst III to join our team at our office in Colorado Springs, Colorado. The Database Programmer Analyst III will provide technical leadership in the advancement of application and reporting systems at ValueOptions, Colorado.
Position Responsibilities
1. Will adhere to solid SDLC principles and practices for software delivery and support.
2. Subscribe to a methodology that includes, but is not limited to, requirements gathering, analysis and design, coding and testing, documentation, implementation and support.
3. Assess, prioritize and delegate development tasks, activities and deliverables.
4. Must be a mentor to other staff members and be a strong customer advocate.
5. Will see the big picture, and develop implementation plans accordingly.
Education
...
Half? I see there as being (edited above) 5 responsibilities, none of which is onerous.
1. Follow their process. What's complex about that?
2. This really means that you talk to people, come up with a design, code and test it, document it, deliver it, fix bugs, answer questions. Sounds complex, but this is what writing code is.
3. manage your own schedule. Again, not a big deal.
4. Help others.
5. Think.
Lynn, if you think you only meet half of these, you are severely overthinking your job search. This is basic stuff.
The fact that a description is long or includes lots of items doesn't necessarily mean they want all of them (then mention 2 of the languages, some things a plus), or that it's a very busy, complex job. It could be, but really this is a general list of all things you might be asked to do. Or a list of many things you might do once a year.
November 22, 2013 at 12:39 pm
Lynn Pettis (11/22/2013)
Well, doing the job search thing is tedious. Thinking about applying for this position but pretty sure I only meet half the requirements. I think this company is either looking for Superman or actually needs at least two people to fulfill the requirements:About The Position
We are currently seeking a dynamic Database Programmer Analyst III to join our team at our office in Colorado Springs, Colorado. The Database Programmer Analyst III will provide technical leadership in the advancement of application and reporting systems at ValueOptions, Colorado.
Position Responsibilities
Will adhere to solid SDLC principles and practices for software delivery and support.
Subscribe to a methodology that includes, but is not limited to, requirements gathering, analysis and design, coding and testing, documentation, implementation and support.
Assess, prioritize and delegate development tasks, activities and deliverables.
Must be a mentor to other staff members and be a strong customer advocate.
Will see the big picture, and develop implementation plans accordingly.
Education
Bachelor's degree in computer science.
Relevant Work Experience
Eight to ten years database programming experience using two or more of the following databases; MS SQL Server, Oracle, Sybase, Informix, DB2. Ten years using two or more of the following programming languages, including associated IDE's and development tools; Perl, ColdFusion, Java, C++, Visual basic, ASP. Eight+ years in the following web technologies; ColdFusion, ASP, Apache, IIS, html, CGI, TCP/IP, ODBC, Java Script. XML experience is a plus, but not necessary. 10-12 years of software development leading to a senior software developer position.
Knowledge, Skills & Abilities
Application reengineering to include database upgrades and conversion.
Application and database troubleshooting
Developed and supported n-tier architectures
EDI and health Care a plus, especially knowledge of ANSI X12 v5010 standards (837s, 834s, 820s, 999s, 277s, etc.)
Organize and prioritize tasks and deliverables
Adaptable to new technologies and IT practices
The company isn't sure what it is looking for and threw in all the tech words they've heard. Why in the world would you be looking for someone that knows Perl, ColdFusion, Java, VB and ASP? They're trying to throw a wide net because they know they need some things done, but haven't narrowed down what.
--------------------------------------
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,196 through 42,210 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply