Are you sure that you are deploying to a 2008 report server and not a 2005 report server?

Have you gone into SQL Server Surface Area Configuration Manager and set the server to allow remote connections via either Named Pipes or TCP/IP Or both?

Here's a list of resources on this site for Profiler.

We would need more details in order to provide performance optimization tips. Here's a list of optimization resources on this...

Most, if not all, of these settings are part of the connection. ADO, ADO.NET, and ODBC all have different defaults so sometimes it depends on the method used to...

Sure you can re-use your data source. When you select New Dataset it gives you the option of selecting a data source or creating a new one.

I don't see you execute the T-SQL code anywhere. All I see you doing is creating a variable initializing it with a T-SQL string. At some point you...

Grant Fritchey (8/13/2009)

---

This is going to become a new badge of honor for people going for jobs or qualifying for MVP:

"And this article I wrote was plagiarized five times in...

RBarryYoung (8/12/2009)

---

If you want to test for a network/display type issue, then change your SELECT query to a SELECT .. INTO #temp and time that. If it is significantly...

Are you returning ALL the rows and ALL the columns? If not, what is your WHERE clause? Have you looked at your execution plan?

Have you checked blocks? ...

There are a whole lot of resources out there.

http://www.jumpstarttv.com - short (3-5 minute), specific how-to videos

http://channel9.msdn.com/Tags/ - videos on just about everything microsoft. Over 200 on SQL Server 2008...

I'm not sure that there is a tool out there that will do what you want. Any comparison tool is going to be looking to compare the same schemas.

One...

I pretty much always point people to Michelle Ufford's Index Defrag Script[/url] for index maintenance.

Just be sure you didn't use any Enterprise Edition only features when developing using Developer Edition.

Typically if you have a View that you need to pass parameters to, you would create a table-valued function. You should be okay with that performance-wise as long as...

I'm not sure you can have truncate permissions without having DROP.