Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
notmyrealname
98 Posts |
 Posted - 2009-04-15 : 08:35:43
|
| Hi.I have been assigned the project of developing a pretty involved SQL application that manages my company's production data. I have been given only Visual Studio to work with. I have no additional access to SQL outside of Visual Studio. I have set up my database, views, sp's and function all within Visual Studio's Server Explorer. The program is going pretty well but we are starting to face performance issues that i am being asked to fix. I feel like i am limited in my ability to diagnose any problems using only Visual Studio. I have been requesting SQL Enterprise Manager but have been told that i cannot have it or any other tools. I've never seen SQL Enterprise Manager and feel like i would learn much more about SQL databases by using it. I suspect alot of the settings contained in Enterprise Manager would not be so obvious in Visual Studio. I've been trying to learn about Enterprise Manager online but it's difficult when you can't test your studies using the tool itself.Could someone please tell me if there are any real advantages of having SQL Enterprise Manager (or any other SQL tools) for someone in my position? Maybe if i give my superiors a laundry list of benefits, they might give in.Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-04-15 : 13:57:21
|
| if you really deal with sql code, then you should have access to enterprise manager/sql query analyser to understand how queries work and also to see object definitions,... |
 |
|
|
|
|
|
SQL Enterprise Manager