Since you've done several implementations, maybe you can say whether any of them have not been financially beneficial, or if they all, to some degree or another, have been, and...

>>>With 4 TB disk drives expected to dip under $200 once the Thai plants are fully back, space is usually a non-issue.

I was thinking of the stress on the SQL/SP...

Some thoughts (which may or may not be half baked, as my knowledge and experience with SP is limited)...

* Isn't storage of documents inside of Sql Server more expensive than...

Maybe you could forward them to MS OneNote.

I mapped my mind and I was surprised to discover that it only had two branches: "Sex" and "Donuts".

Yes, unindexed views. I would love to index some of my views, but the database I'm working on was created without schemabinding. Thanks again.

Okay, thanks.

BIDS 2010 works.

Very much for lateral thinking, rather than linear, me-thinks, and so might have stronger appeal for them (us).

Microsoft® SQL Server® 2008 R2 Reporting Services Add-in for Microsoft SharePoint® Technologies 2010

But I found the answer here: http://msdn.microsoft.com/en-US/library/bb677365%28v=SQL.90%29.aspx

The full add-in goes on the Sharepoint machine, files...

Adding an integer to your code works like DateAdd() as well.

It was the "Featured Script" in today's newsletter.

Also, you can add or subtract days like so:

DECLARE @DateOnly DATETIME

SET @DateOnly = CAST(FLOOR(CAST(GetDate() AS FLOAT)+1) AS smallDATETIME);

print @DateOnly

Prints just like the original did, but a day later. Subtract 2...

Slightly tangential, but I like to cast as SMALLDATETIME because I usually cut and paste my results into Excel; If I use a datetime, Excel shows 00:00 or somthing but...

Okay, I'm sorry if I wasn't clear, but this is what I was really looking for...

Try this:

* run this script in SSMS:

* left click...