Thank you both for your responses. I did not mean to mark your reply as spam, there was something odd posted under it, I thought that was what I flagged.

Anyway,...

While I appreciate your sentiment, and I of course already did that, I thought I'd approach our community to see what others felt was important, not just some regurgitated blog...

Thank you both for your input and ideas. I've never encountered a relational db that just imported data and performed calculations lol

I just changed from DBA'ing the last...

Sorry - I just noticed the date on this - DOH!

Hi Sam,

Did anyone ever get back to you on this? I've been running SSRS in SharePoint integrated mode for almost...

I didn't install a new driver, I thought of that but realized that the .NET connection string from the web app server is version specific...

Your messages actually look a lot like the messages we receive from our SAN during a backup, that may be something to check if there are SAN backups occurring they...

Hi, I did a recent in-place upgrade from SQL Server 2008 R2 to SQL Server 2012 SP1 CU8 and dropped and re-added mirroring and now we are having the same...

thanks for your reply, that is exactly what I decided to do

It's nice to see that you aren't accepting plagiarism, it must be very difficult to monitor such things within the blogs, posts etc.

Here is a bit of code I...

(Sorry for some reason I couldn't edit my post, please see below)

Or.. should I put the values in a fact table and just have the property data in the dimension?

The...

We are using Avamar succesfully in our environment.

We use it to do our Full backups and we backup t-logs with native backups to the file system, then sweep those...

Thanks,

yes, without the column it uses the index.

The execution time is 1m 24s

This took 30s longer.

Perhaps there is nothing that can be done, there is over 2 million rows in the table and I have to select each column, including the text...

Thank you for your suggestion, I appreciate your time and thoughts.

I will try this and post back.

Sure, it's:

[dbo].[MyTable](

COLMAIN_ID [int] NOT NULL,

COL1 [char](12) NOT NULL,

COL2 [char](4) NOT NULL,

COL3 [datetime] NULL,

COL4 [int] NOT NULL,

COL5 [int] NOT NULL,

COL6 [char](4) NOT NULL,

COL7 [char](10) NOT NULL,

COL8 [int] NOT NULL,

COL9 [datetime] NULL,

COLText_10...