IIRC, the initial size of the log is stored in the header, and you cannot shrink below this initial size. As mentioned, not sure this is worth it for 15MB,...

Use CONVERT with the format you want. I assume you want 101.

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

I'll try to do better in London in March.

calvo (11/5/2014)

---

I know it's just a report from the Miami Herald but he had already admitted to the DEA that he was using steroids while he was denying the use...

Administer was not listed, and I'd forgotten about it. I've awarded back points and changed the question to reference database level permissions.

Excellent and thanks for the offer. Submit it on site and we'll get you feedback.

Eric M Russell (11/12/2014)

---

When I first saw the title "Double Up During Trips", I thought it was going to be a post about how to save money by doubling up...

I guess I'd say you're buying 2014 no matter what. That's what's being sold for new licenses.

So, go 2014.

I've got limited knowledge here, but AFAIK, the Windows Cluster moves over those items that are clustered in Windows, which could be SQL Server. If you had an instance of...

chrisn-585491 (11/12/2014)

---

My favorite story of efficiency was the the old AppleWriter that worked in 16k memory (kilobytes for you youngin's ) and could still handle documents that were a megabyte...

chrisn-585491 (11/12/2014)

---

Managers investing in developers??!?? LOL (That's a good one...)

I'm convinced that Steve lives in an entirely different world from myself. 98% of my professional education, knowledge and skills were...

chgn01 (11/12/2014)

---

Thank you for your input. I am agree with you. but... can we refer to this link?

http://use-the-index-luke.com/sql/partial-results/top-n-queries

I think "Order By" just do for "Top (n)" rows not...

You cannot recover passwords. No modern, well designed software allows this. It is a big security hole.

Maintenance plans can work well for trimming older files as well. I like Ola's solution for backups. It works well.

If I Google "SQL Server 2008 R2 Express Edition" the first link is a download from Microsoft. They have made it available.

If you need developer editions, search for those, and...