Viewing 15 posts - 5,686 through 5,700 (of 6,041 total)
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,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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?
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 11, 2011 at 9:25 am
[Jim].[dba].[Murphy] (3/10/2011)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 10, 2011 at 12:28 pm
Carl B. (3/9/2011)
1- You take a full backup...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 10, 2011 at 10:51 am
Steve Jones - SSC Editor (3/9/2011)
Mark W Johnson (3/9/2011)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 9, 2011 at 3:56 pm
This piece is a few years old, and it talks about how quality has become more important at many large software vendors. Looking back across the five years since the...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 9, 2011 at 7:39 am
Those of us who were developing applications in FoxPro, MS Access, or some other ISAM platform back in the 80's and early 90's know the perils of a transactionally inconsistent...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 8, 2011 at 2:10 pm
Transaction logging usually isn't an issue unless you're inserting 100,000+ records one.. at.. a.. time.. in a loop, or the DBA allows the transaction log to grow until it fills...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 8, 2011 at 8:14 am
Of course wether or not a security flaw or bug makes public headlines determines how it is triaged, however it doesn't mean that Microsoft is just sitting on it.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 4, 2011 at 7:45 am
Jeff Moden (3/3/2011)
Telarian (3/3/2011)
Jeff Moden (3/3/2011)
Oh, be careful now. "It Depends". 🙂 Scalar and Multi-Line Table Valued Functions (mTVF) can very quickly turn code into some pretty nasty,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 4, 2011 at 7:33 am
SQLkiwi (3/3/2011)
Eric M Russell (3/3/2011)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 3, 2011 at 11:59 am
When I need to join a resultset from a remote server, like from a linked server connection, neither a View or TVF are beneficial. I'll typically execute a parameterized pass-through...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 3, 2011 at 9:56 am
SQLkiwi (3/3/2011)
Eric M Russell (3/3/2011)
Depending on the circumstance, a view can replace the functionality of a scalar or table valued function and do so more efficiently.
In 2005 or later, I...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 3, 2011 at 9:14 am
Depending on the circumstance, a view can replace the functionality of a scalar or table valued function and do so more efficiently. I once developed a datawarehouse and reporting application...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 3, 2011 at 7:49 am
Viewing 15 posts - 5,686 through 5,700 (of 6,041 total)