Posted: 5/30/2008 6:09:47 PM EDT
|
Anyone else write SQL for a living? I am just getting started with T/SQL and DB2 in a professional setting. I had done some work with it in school but this is totally different.  I have working with it for the last 5 months on simple reports but now I am starting to get into more complex stuff.We use it to push the data to our reporting software, Crystal Reports 10 currently, we are upgrading to XIr2 in the middle of June. Some folks in my group are just not able to pick it up, to me it seems pretty intuitive but different people think differently. You guys have any tips or helpful links to help a newbie out. 
|
If you use MS SQL Server, the SQL profiler is your friend. It helps you tune your queries by telling you where the most time is being spent. Also be careful of your joins and use indexed colums where possible. |
I use the analytic tool, is that what you are talking about? We are upgrading to MS SQL 2005 in July. This is a very large company that is way behind in their software. 
|
|
I'm the DBA for the Public Defender of a certain Judicial Circuit. We're on MS SQL 2000 right now but I'm trying to get them to SQL 2005. I have done many SQL 2000 to SQL 2005 conversions and the only thing I really don't like is the new version of the Enterprise Manager, otherwise known as the SQL Server Management Studio. Other than that, upgrades are quick and painless. |
No in SQL management studio it is under the tools menu as SQL Profiler. msdn.microsoft.com/en-us/library/ms173757.aspx |
Yeah, I don't have 2005 just yet.
|
|
Crystal is the damn devil. It's a dead end technology. Run like hell. Crystal is pretty, but Reporting Services is quick, easy, cheap and extensible. I write SQL all day, every day. BI, cubes, data mining, SSIS, Reporting Services, Analysis Services, all of it. 2008 will be out soon. If they haven't adopted 2005by now, they are behind the game. If you have specific questions, let me know. |