Role of DBAs

Four roles are listed in first Chapter of Professional Microsfot SQL Server 2008 Administration: Production DBA,Development DBA, Business Intelligence DBA & Hybrid DBA. For smaller organzations, Hybird DBA...

Could you check how many free space in the Data_3.ndf

Did you do any reindex before shrinkdatabase which will increase the file size?

Maybe you can try this statement

DBCC SHRINKDATABASE...

That works!!! Thanks Jim

I see the Performance Point Demo on Heroes event in Hawaii, it will very cool.

I wish I can bring it in. It builds on share point - My environment...

Are you going to build a Data Warehouse or reporting on existing suggestion database schema? Is aOLTP schema or OLAP schema?

Analysis Services is best tool from Microsoft to build data...

Wow, that's great.

For the first extended store procedure xp_fileexist which exists in Sql 2000. Others are new in SQL 2005.

Thanks a lot. 🙂

Open your report, click Data tab, and select Dataset dropdown and view whether there is a duplicate dataset, if does exist, just delete it.

I think when you are report...

Where do you find the time gap? ReportServiceLog file, could you post it?

Yes, it is from Chris's Blog. It works for table with group also. I only have the code from previous project, and forget where I got it from. Do...

How about try this way?

Step 1: Add following code your

'*************************************************************************

' -- Display green-bar type color banding in detail rows

' -- Call from BackGroundColor property of all detail row textboxes

'...

For your question 3, here is my suggestion.

Add ReportViewer control to your asp.net page, set the ProcessingMode to Remote, then add your reporting server information under "ServerReport" section.

There...

The page break will work when render in PDF.

If you design the report (rdl) and want to display long report a single page, open the report in visual studio, choose layout design, find InteractiveSize in Report properties window,...

One thing you can try to add a report parameter, and add a textbox in page header, assign the textbox value to parameter's value.

Great, I am looking for that. Thanks for sharing.