I use the LSN values by running RESTORE HEADERONLY. We have a t-log transfer process betwen Singapore and London with t-logs going both ways. London have implemented a solution using...

Omit the ROUND function too. The cast to numeric will take care of the rounding.

ddriver (10/12/2011)

---

I do this sort of operation fairly frequently and just looking at the SSIS package for even the simple case in this example sets me on edge. There are...

In the modern data landscape, I am keenly aware of the cost, both professionally and commercially, of a breach of data security. Working for a large law firm makes that...

You need to make sure there is some language in the document that refers to something like the follwoing points

- All DML is completed according to requirements as applied in...

SSIS is really the only way to go IMHO. Linked servers lead to all sorts of problems down the line: retiring hardware, scaling up and resolving performance issues just to...

Use VMs. You are talking about a dev/staging/QA environment where performance is not an issue. If performance testing is part of the remit, then you should be using hardware as...

Try ToDoList, although it may be overkill for what you need, it does everything you have specified, and it is free!

If you rebuild the indexes, you can skip the stats update.

From BOL:

Operations such as rebuilding, defragmenting, or reorganizing an index do not change the distribution of data. Therefore, you...

What's going on here? The link is incomplete and the snippet that reamins links to some bible readings site.

J-F Bergeron (11/3/2009)

---

Roy Ernest (11/3/2009)

---

Also keep in mind that once you go to SQL 2008 you can always use the SQL Server native compressed back up that reduces the back...

I would argue for replication of the data by some means. Depending on size and latency requirements, an SSIS package could be suitable too.

I have a similar issue where I...

Thanks guys. It is calming to know there are fellow travellers out there. Ninja, I like your advice, Bruce, you are right, time is the biggest limiting factor. One of...

Bruce W Cassidy (2/22/2009)

---

Grant Fritchey (2/20/2009)

---

I do feel for you. I've been there. Trying to convince a programmer who knows everything there is to know that, maybe, just maybe, he's...

Updating it this weekend. Thanks for the pointer to Code Complete. It is on my shopping list.