Viewing 15 posts - 16 through 30 (of 38 total)
I think that's quite a complex solution to an unnecessary complex problem. I don't see why a report is needed at all - it seems to me that the reporting...
July 30, 2015 at 4:11 am
The movement away from schema-defined XML to schemaless JSON will only exacerbate the problem. With NOSQL work still has to be done, but processing is deferred from ETL to query...
April 13, 2015 at 4:12 am
For IO constrained environments, striped backups come into their own when the backups are compressed: Since the compression process is inevitably single-threaded, increasing the number of striped backup files permits...
February 19, 2015 at 1:09 am
Backup the database elsewhere, reforat the drive with 4096 sector size and restore. Or copy everything off, reformat and copy back on.
November 14, 2013 at 12:16 am
The whole basis of this article is undermined because the author picked an unsuitable edition of SQL Server for comparison: SQL Server Compact would be the equivalent product and would...
July 19, 2012 at 4:12 am
Gift Peddie's comment goes a good way to explaining why I'm a contractor. I do my hours and walk out the door. No more working for free - that's for...
January 3, 2012 at 10:55 pm
call.copse (12/7/2011)
...The US state also sanctions murder...
Murder by definition is an illegal killing. You could say that capital punishment is state-sanctioned killing, but murder it is not.
Infact the bible makes...
December 7, 2011 at 4:23 am
I'm a consultant here in the UK. I either contract to be paid on an hourly basis, or on a daily basis, so the unpaid overtime only kicks in for...
December 6, 2011 at 3:03 am
A common problem among developers is an unwillingness to master the entire software stack. If you want great software, you must develop expertise in all layers including DB and OS.
September 27, 2011 at 1:55 am
Colin Barry (9/19/2011)
Why have a service issue the GUIDs? A small bit of clr code could do what you need and would be fast. You could then let your...
September 19, 2011 at 8:34 am
Sergiy - What I'm trying to say is that the original idea of coming up with a more efficient globally unique identifier is good. However its usage in order to...
September 19, 2011 at 5:26 am
Sergiy - It isn't the job of programmers/developers to reinvent the wheel of infrastructure: There are a number of infrastructure topologies that already exist to deal with datacentre destruction scenarios,...
September 19, 2011 at 2:55 am
gahayden (9/15/2011)
For many years, when storage was expensive, single fields were often used to depict mutiple entities and...
September 15, 2011 at 4:50 pm
hxchi (9/15/2011)
To synchronize the two server clocks to 1 millisecond precision is not a trivial task.
Especially because Windows internal system clock has a default resolution of 3 milliseconds!
September 15, 2011 at 7:34 am
Utilising a separate table to store the highest existing identifier is not a good strategy for performance because it introduces a hot-spot into the insertion process: In order to insert...
September 15, 2011 at 6:54 am
Viewing 15 posts - 16 through 30 (of 38 total)