Viewing 13 posts - 1 through 13 (of 13 total)
Check the execution plan in Management Studio.
Query->Include Actual Execution Plan
Chris
January 24, 2010 at 10:20 pm
You can right click on your database and choose tasks -> Import Data.
Then you can walk through the import wizard and on one of the last screens there will be...
January 14, 2010 at 7:25 pm
Here is a blog post about searching across all fields in all tables across a database.
http://chrisbarba.wordpress.com/2009/02/28/search-across-…-in-sql-server/
January 14, 2010 at 7:15 pm
Reporting Services 2008 no longer requires IIS to be installed.
You shouldn't have any trouble with both RS2008 and IIS.
Chris
December 29, 2009 at 3:04 pm
Are you running in a 64-bit environment?
Excel only works in a 32-bit environment (VS is 32bit)
December 28, 2009 at 1:28 pm
I would definitely recommend Reporting Services (it's free with SQL Server).
If you don't want to pay for full SQL Server you can download SQL Server Express with Advanced Services.
It's the...
December 24, 2009 at 9:48 am
You can check the app pool of your reporting services portal site.
I have IIS 7 and I can go the app pools and right click on it.
Then go to advanced...
December 20, 2009 at 9:24 pm
Not sure if this will help or not.
I had a sharepoint site that host a asp.net page that read data from an excel file.
To get around the 64 bit issue,...
December 20, 2009 at 9:09 pm
I would suggest you double check the url of your reporting services portal site.
You could also go to the portal site and deploy it there.
You can create a folder to...
December 20, 2009 at 9:03 pm
You can go to the folder where the report is stored on the reporting services portal site and upload a new file from there.
Then you edit the report to use...
December 20, 2009 at 9:00 pm
You don't have different levels of compression (like in IIS).
You can either compress the backups or not.
When you back up the database (right click on the db and...
December 17, 2009 at 12:56 pm
Here is a list I put together of the new features of SQL 2008.
It has the features seperated by area (security, performance, etc).
It's not all inclusive, but provides a good...
December 17, 2009 at 12:50 pm
There are many new features in SQL 2008 that make it worth upgrading to.
I have complied a list of the easiest features to sell a client on.
http://chrisbarba.wordpress.com/2009/03/29/whats-new-in-sql-2008/[/url]
December 8, 2009 at 10:19 am
Viewing 13 posts - 1 through 13 (of 13 total)