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...
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...
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...
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)
May 1, 2015 at 12:19 pm
Eirikur Eiriksson (5/1/2015)
Eric M Russell (5/1/2015)
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...
May 1, 2015 at 9:56 am
Steve Jones - SSC Editor (5/1/2015)
david.gugg (5/1/2015)
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...
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,...
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,...
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...
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...
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...
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...
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....
April 30, 2015 at 6:50 am
Viewing 15 posts - 3,916 through 3,930 (of 6,041 total)