Left 4 Dead

THis...

This will help as a starting point on SSRS Expressions -http://msdn.microsoft.com/en-us/library/ms157328.aspx

Managing Transaction Logs - http://www.sqlservercentral.com/articles/Administration/64582/

Why is my transaction Log full - http://www.sqlservercentral.com/articles/Transaction+Logs/72488/

Stairway to Transaction Log management - http://www.sqlservercentral.com/stairway/73776/

Recovery Models - http://msdn.microsoft.com/en-us/library/ms189275.aspx

Accidental DBA Guide - Chapter 8 - http://www.sqlservercentral.com/articles/books/76296/

SQL Server Backup...

You need to define what consitutes your base anchor and ensure that it has a full hierarchy tree underneath it, now Svr1 doesnt have a hierarchy link to Srv4 so...

CAKE!!!!!!!!!!!!!!

Then as you are doing regular maintenance 8 will probably be the better option.

If you read just on to the next paragraph it details what MAXDOP to use for upgrades,...

Transaction log's active portition of the log moved to an earlier point in the file, allowing to shrink more

Took a transaction log backup then shrank the file

Switched recovery to simple,...

Shrinking data files causes fragmentation in your indexes, so I would strongly recommend you go and check for index fragmentation.

If a database has grown to a size it is usually...

What version of AX are you running 2009? 2012? Have you recently done an upgrade? Do you run AX batch processing or any types of AX or database...

You cannot shrink past the marked active portion of the log.

If the portion of the log was released and another earlier portion of the log marked as active then you...

First off your selecting the whole of the table as your base point, so there should be a where clause in the CTE before the union WHERE PubSrv = 'Svr1'.

Then...

poratips (11/12/2012)

---

Hello,

I have situation that my developer wants some tables from Prodction DB server to their desktop m/c.

We have already sql express installed and Database and tables ae already there...

Your rounding is not following correct rounding rules, typically anything between 0-4 is rounded down and 5-9 rounded up, so to round a value to 10.44 it would have...

Transaction log backups are there so that you can revert to a point in time.

If you dont do transaction log backups you need to ask yourself why is your database...