View Complete Post
I've recently upgraded from SQL Server 2000 to SQL Server 2008. My accounting and marketing team is skilled and has been using SQL Query Analyzer for years to run smaller queries and build small Crystal Reports. Unfortunately Query Analyzer is
now bundled into the management studio. That's a bit too much software for this level of power users.
Is there a client-side query analyzer for SQL Server 2008? I'd rather use a Microsoft product than a 3rd party tool, but I suppose I could do that too. Looking for something simple that will:
1. Show users the database tables and/or views
2. Run queries
Perhaps query analyzer isn't the way to go and my team needs a different reporting system. If this is the way MS is heading, could you direct me towards a product or service that allows power users to get the information they need? They will
still need to look at raw data to build Crystal Reports though.
In my last column, I discussed MicrosoftÃÂ® Application Center Test and how it could be used to measure the performance of your Web application (see Extreme ASP. NET: Tools of the Trade: Application Center Test).
MSDN Magazine August 2005
We recently upgraded to a 2008 development web server and I installed all the stuff to get dot net 1.1 app working on the server. I can host them and they work. My problem is that when I try to open one in VS 2003 I get the following error. I set up the web server the same as my previous one, and I think a long time ago I got this error when we set up current one but do not remember how to resolve it. So I moved my project files from the old server to the new server and then I get these errors.
The web Server reported the following error when attempting to create or open the Web Project located at the following url: Http://localhost:/MobTracker. 'Http/1.1 500 server error
When I ran this query from SQL 2000 it takes 1 second. now in SQL 2008 R2 the same query is 20 times slower.
This is the query and the numer of records and the time in SQL 2008 R2:
SELECT * FROM dbo.CxP_Saldos
0 seconds, 923 Rows
SELECT * FROM S_Conta.Cuentas
0 seconds, 662 Rows
SELECT * FROM S_Conta.Cuentas c INNER JOIN dbo.CxP_Saldos s ON c.id = s.CtaProv
18 seconds, 923 Rows
how can I submit the actual execution Plan?