You cannot shrink a log file below the initial size it was created with.

I believe the steps you'll need to take are:

1) Detach the database

2) Rename/delete the old log file

3)...

It's very difficult to answer this sort of question without:

a) a clear definition of what the actual problem is

b) some sample data/DDL

See here for more detail:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Taking a complete stab in...

Hi,

Probably best off looking up Query Hints in BOL:

http://msdn.microsoft.com/en-us/library/ms181714.aspx

It's pretty straight forward

Lookup Row_Number() in BOL:

http://msdn.microsoft.com/en-us/library/ms186734.aspx

Combining this with a CTE should get you what you need.

If you post some sample data and the expected result, I'm sure someone can post a...

You could create new partitions in Filegroups of appropriate sizes, switch the partitions to the new ones then drop the old filegroups...

Having said that, can data for previous months ever...

Could you post the actual execution plans with and without use of the parameters?

Edit: May be redundant after seeing Paul's post 🙂

Nope, that won't work. Compatibility mode has nothing to do with the database version.

You cannot restore back to SQL 2005 from 2008. Your only option is to script all of...

I use all of the above on a Windows 7 Proffesional laptop and it works fine.

Make sure you apply SP1 and set Management Studio to Run as Administrator though.

No, that's not the case.

Log shipping consists of 3 basic operations. Backup, Copy and Restore.

By default data is backed up every 15 minutes and there are jobs automatically created that...

To answer the question of why it supports Log Shipping but not Mirroring is probably more down to the QA teams at Microsoft rather than the architecture not supporting it....

Not sure I entirely understand your requirement. Are you using <= as "less than or equal to" or are you simply pointing to the columns to explain the logic?

The following...

I'd suggest posting the code you've written, even though it works and carefully explaining the problem you have with the real code. It at least shows that you've put some...

It's difficult to tell from a partial screenshot and without seeing what's in any of these items, but it looks as if you've set all of this up within a...

Well, mathematically speaking you can have any positive/negative number as an exponent but I'm really intrigued as to what the business logic is for needing this.

Care to elaborate?? 🙂

Yes, but if the value of column 1 is positive, you don't want to make the result negative, hence the case statement in my post