| Author |
Topic |
|
David Singleton
Starting Member
35 Posts |
 Posted - 2010-02-20 : 16:12:13
|
| Sorry for the newbie question. 1/ If I have questions about SSAS and SSIS and Administration, that are general, do I post them in the 2005 or 2008 forums?2/ Is there a forum specific to SQL performance issues, if not where to post those questions.PS I did try search but didn't find anything.David SingletonMicrosoft MVP Dynamics NAV |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-02-20 : 16:45:29
|
| 1. It depends on which version you are using.2. It depends on where the performance problem is. If it's a question about the T-SQL code, then put it in the T-SQL forum. If it's more of a general performance issue on the server, then I'd suggest the Admin forum. But really it doesn't matter too much as most people who answer questions here check all of the forums. A moderator can always move the topic to the appropriate forum too.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
 |
|
|
David Singleton
Starting Member
35 Posts |
Posted - 2010-02-20 : 19:05:47
|
| Thanks Tara.Version is both, since the stuff I do needs to work on both. So I guess unless its 2005 specific, I will ask int he 2008 does that sound right?The performance questions will mostly be hardware related or configuration related, so I guess as you say the Admin forum probably works.Thanks for the quick reply.David SingletonMicrosoft MVP Dynamics NAV |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-02-21 : 01:31:56
|
If they are common, I suggest you post them in the latest (2008) forum.Hi David, greetings from another SQL MVP.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
David Singleton
Starting Member
35 Posts |
Posted - 2010-02-21 : 10:06:35
|
| Thanks, for sure it makes sense to put it in the latest version if it applies, will do. Its good to see fellow MVPs here, its always a good sign of a quality forum. I have worked mostly on the application side (Navision) but now plan to concentrate more on the backend (aka SQL ) side, so I will start having questions soon, but hopefully I can also contribute. Although I have been working with SQL since 6.5, its only the last few years that I have started really learning about it in detail. My biggest issue is that we can't change the way the application works, and we are stuck with some really bizarre things that Navision does, for example EVERY request to the server starts with SELECT * FROM in fairly fat tables, and recently they changed things so that EVERY scan uses a Dynamic Cursor. So we need to do a lot of playing to make it work. Right now I am searching the forum and reading before I start asking questions that are already answered. I look forward to joining in in this community.David SingletonMicrosoft MVP Dynamics NAV |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-22 : 01:13:49
|
| " EVERY request to the server starts with SELECT * FROM in fairly fat tables"That is not so bad if it only pulls one row. We have generic maintenance routines that do that [except that we explicitly list the column names, natch!] - on the assumption that the form will display all, or most, of the columns.But for multiple rows it is a crap."EVERY scan uses a Dynamic Cursor"Also sounds like crap. How do such companies get successful? Or maybe this is how they die ... |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-22 : 01:15:31
|
| OK, I googled Navision. So this is some ERP solution that MS have now bought. I figure the SQL quality will be made to improve ... |
|
|
|
David Singleton
Starting Member
35 Posts |
Posted - 2010-02-22 : 04:14:52
|
quote:
Originally posted by Kristen
OK, I googled Navision. So this is some ERP solution that MS have now bought. I figure SQL quality will be made to improve ...
Well Microsoft bought the product in 2002 when it still ran on its own Native database (with very high performance) and the port to SQL was just starting to get out there. And the cursors are a recent thing. Seven years seems like enough time to get this thing working.  And unfortunately no the select * statements are often getting millions of records. But I am guessing this doesn't belong in this forum ;)David SingletonMicrosoft MVP Dynamics NAV |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-22 : 04:16:30
|
 +++++ |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2010-02-22 : 04:50:19
|
i've been consulting on a navision project last year.the damned thing did select * from tableand then each time a user clicked next or previous did another select * from table and used a client cursor to go back or forward.the solution was to upgrade to the next version  ___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.7 out! |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2010-02-22 : 09:25:47
|
quote:
Originally posted by spirit1...the solution was to upgrade to the next version ...
It always is.CODO ERGO SUM |
|
|
|
David Singleton
Starting Member
35 Posts |
Posted - 2010-02-22 : 10:22:28
|
quote:
Originally posted by Michael Valentine Jones
quote:
Originally posted by spirit1...the solution was to upgrade to the next version ...
It always is.CODO ERGO SUM
Not always. Often the next version makes it worse.David SingletonMicrosoft MVP Dynamics NAV |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2010-02-22 : 11:44:37
|
quote:
Originally posted by David Singleton
quote:
Originally posted by Michael Valentine Jones
quote:
Originally posted by spirit1...the solution was to upgrade to the next version ...
It always is.CODO ERGO SUM
Not always. Often the next version makes it worse.David SingletonMicrosoft MVP Dynamics NAV
You're talking about reality.I'm talking about what the vendor says.CODO ERGO SUM |
|
|
|
David Singleton
Starting Member
35 Posts |
Posted - 2010-02-22 : 11:50:00
|
quote:
You're talking about reality.I'm talking about what the vendor says.CODO ERGO SUM
So very true. David SingletonMicrosoft MVP Dynamics NAV |
|
|
|
|
Which forum to post in.