Viewing 15 posts - 3,916 through 3,930 (of 6,041 total)
If your auditing process is failing, then that should be a top priority for investigation, and in something like a financial transaction database, you may want to consider suspending operation...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 5, 2015 at 7:22 am
In most scenarios the auditing operation should be done asynchonously, if possible, for performance reasons. But you can't do that if the auditing operation is bundled within batch transaction.
Another reason...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 5, 2015 at 7:15 am
djackson 22568 (5/1/2015)
I recall a discussion here regarding whether college is useful. This is an area where I think a good education is useful. Understanding why things run...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 1, 2015 at 12:50 pm
Eirikur Eiriksson (5/1/2015)
Eric M Russell (5/1/2015)
Eirikur Eiriksson (5/1/2015)
Eric M Russell (5/1/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 1, 2015 at 12:19 pm
Eirikur Eiriksson (5/1/2015)
Eric M Russell (5/1/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 1, 2015 at 10:53 am
Eric M Russell (5/1/2015)
djackson 22568 (5/1/2015)
We are implementing a major product that solves this issue by having a shadow of live, and all...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 1, 2015 at 9:56 am
Steve Jones - SSC Editor (5/1/2015)
david.gugg (5/1/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 1, 2015 at 9:47 am
djackson 22568 (5/1/2015)
We are implementing a major product that solves this issue by having a shadow of live, and all reports are run...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 1, 2015 at 8:56 am
Static code analysis doesn't know how many times the code is executed, how much data it accesses, or how it's impacted when running in parallel with other specific code. However,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 1, 2015 at 8:22 am
As far as I know, we never got any execution plans for reference. We don't know how many pages are being read / written, how often this procedure is called,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 30, 2015 at 2:15 pm
To prevent a conversion error, I had to change 2015-04-30 to 2015-04-10, where the month and day can be interchangable.
set dateformat mdy;
select cast('2015-04-10' as datetime);
2015-04-10 00:00:00.000
set dateformat dmy;
select cast('2015-04-10' as...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 30, 2015 at 8:33 am
Michael Meierruth (4/30/2015)
Eric M Russell (4/30/2015)
Michael Meierruth (4/30/2015)
For easier readability, I always write my hard code dates as 'yyyy-mm-dd'.
99999999 is always assumed by SQL and most programming languages to be...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 30, 2015 at 7:35 am
What I posted previously is ranking top 10 queries by wait (blocked) time. How we define queries as "expensive" depends on where your most urgent bottleneck is. You could perhaps...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 30, 2015 at 7:28 am
Well, you've certainly got your work cut out for you. As someone who comes from an application developer background, I'm sure you know how folks feel about database refactoring. You're...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 30, 2015 at 7:20 am
Michael Meierruth (4/30/2015)
For easier readability, I always write my hard code dates as 'yyyy-mm-dd'.
99999999 is always assumed by SQL and most programming languages to be in ISO standard YYYYMMDD format....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 30, 2015 at 6:50 am
Viewing 15 posts - 3,916 through 3,930 (of 6,041 total)