Viewing 15 posts - 5,656 through 5,670 (of 6,022 total)
DataChomp (3/22/2011)
Naturally, my favorite data product is SQL...
March 22, 2011 at 8:19 am
If you call a SQL DBMS "relational" then what do you expect me to call a DBMS that really is relational? How can we have a proper discussion about different...
March 21, 2011 at 2:49 pm
So you are acknowledging that those problems exist in SQL. In fact you go to a lot of trouble to avoid them. Sometimes there are no workarounds and sometimes the...
March 21, 2011 at 12:14 pm
David Portas (3/21/2011)
Eric M Russell (3/21/2011)
Aging and inadequate are not descriptive enough terms; could you elaborate more on what you perceive as the "fundamental problems of SQL"?
The problems of SQL...
March 21, 2011 at 9:48 am
David Portas (3/20/2011)
March 21, 2011 at 8:21 am
richardd (3/18/2011)
Eric M Russell (3/17/2011)
If an application must use VarDate columns, then they should at least code it using ISO standard format YYYYMMDD...
But if you're using real dates, why not...
March 18, 2011 at 1:16 pm
CirquedeSQLeil (3/17/2011)
March 17, 2011 at 2:46 pm
Ron Porter (3/17/2011)
Mike B in AK (3/17/2011)
March 17, 2011 at 11:23 am
richardd (3/17/2011)
Nakul Vachhrajani (3/16/2011)
I have seen people using VARCHAR for storing everything (dates, money, floats)! Their excuse? Globalization/Internationalization.
How can anyone claim that storing a date as the string "09/01/2001" is...
March 17, 2011 at 10:04 am
The representation of dates as character strings in a database (what I'll call a "VarDate") is one of the leading causes of business intelligence disasters.
The day will come when another...
March 17, 2011 at 7:41 am
There are many different scenarios, but if what you need is access to the database itself, then you can always attach a copy of the mdf file(s) to a SQL...
March 16, 2011 at 7:44 am
Just because a database platform is good enough for Facebook or Google, that doesn't mean it's good enough for online banking or e-commerce. I believe that financial and operational data,...
March 14, 2011 at 7:52 am
So after the staging server has finsihed updating it's copy of the database, you do what with the synonymns on the production server? Point your queries to a different database?
March 11, 2011 at 5:58 pm
Generally speaking, transaction logging is trivial during the normal day to day operations of a OLTP database, especially if the log files are on separate storage from data files.
If...
March 11, 2011 at 9:25 am
[Jim].[dba].[Murphy] (3/10/2011)
March 10, 2011 at 12:28 pm
Viewing 15 posts - 5,656 through 5,670 (of 6,022 total)