Viewing 15 posts - 3,916 through 3,930 (of 6,035 total)
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
Also, so it's more readable, you can convert miliseconds to hh:mmss format using something like the following.
...
,convert(varchar,dateadd(ms,last_elapsed_time,getdate())-getdate(),108)last_elapsed_time
...
April 29, 2015 at 1:28 pm
First, attempt to rename the .mdb file. If you get access error, then another process has it open.
Also, one of the sysinternals tools can tell you who has the file...
April 29, 2015 at 10:35 am
The following "first responder" query will provide us with some execution statistics like execution time, blocked vs working time, page read count, write count, etc. for each statement contained in...
April 29, 2015 at 8:49 am
Because you're new to this, I'd like to add one final note about filtering on dates. If OrderDate column is a datatype that contains both date + time (ie: DateTime...
April 29, 2015 at 7:47 am
buddy__a (4/28/2015)
April 29, 2015 at 7:30 am
Jeff Moden (4/28/2015)
Eric M Russell (4/27/2015)
OK, I'm sorry for the remark about some users wanting access to the 'SA' account just to feel important.
I wouldn't be. I'm glad that...
April 28, 2015 at 9:19 am
Viewing 15 posts - 3,916 through 3,930 (of 6,035 total)