Viewing 15 posts - 1 through 15 (of 20 total)
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...
November 8, 2011 at 4:53 pm
Omit the ROUND function too. The cast to numeric will take care of the rounding.
November 8, 2011 at 4:32 pm
October 19, 2011 at 5:13 pm
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...
October 19, 2011 at 4:52 pm
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...
October 18, 2011 at 12:06 am
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...
October 17, 2011 at 11:48 pm
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...
October 17, 2011 at 4:22 pm
Try ToDoList, although it may be overkill for what you need, it does everything you have specified, and it is free!
September 15, 2010 at 8:26 pm
If you rebuild the indexes, you can skip the stats update.
Operations such as rebuilding, defragmenting, or reorganizing an index do not change the distribution of data. Therefore, you...
June 22, 2010 at 6:46 pm
What's going on here? The link is incomplete and the snippet that reamins links to some bible readings site.
January 3, 2010 at 10:13 pm
J-F Bergeron (11/3/2009)
Roy Ernest (11/3/2009)
November 3, 2009 at 7:13 pm
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...
February 23, 2009 at 8:13 pm
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...
February 22, 2009 at 2:26 pm
Bruce W Cassidy (2/22/2009)
Grant Fritchey (2/20/2009)
February 22, 2009 at 1:49 pm
Updating it this weekend. Thanks for the pointer to Code Complete. It is on my shopping list.
February 19, 2009 at 2:12 pm