Viewing 15 posts - 3,916 through 3,930 (of 6,027 total)
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
Steve Jones - SSC Editor (4/28/2015)
Ralph Hightower (4/28/2015)
2 – NOLOCK is required on every query. It makes things run faster.
Instead READ_UNCOMMITTED is...
April 28, 2015 at 8:53 am
One problem you will encounter when digging into root causes is that your search will often need to cross departmental or even oganizational boundaries, especially in the realm of data,...
April 28, 2015 at 6:48 am
PHYData DBA (4/27/2015)
Eric M Russell (4/27/2015)
PHYData DBA (4/27/2015)
Eric M Russell (4/27/2015)
I wish Microsoft would drop support for v2008R2 this year; I'd love to upgarde to v2014.
We would be running anything...
April 27, 2015 at 2:49 pm
PHYData DBA (4/27/2015)
Eric M Russell (4/27/2015)
I wish Microsoft would drop support for v2008R2 this year; I'd love to upgarde to v2014.
We would be running anything after 2008R2 if any of...
April 27, 2015 at 1:52 pm
I wish Microsoft would drop support for v2008R2 this year; I'd love to upgarde to v2014.
April 27, 2015 at 12:41 pm
Gary Varga (4/27/2015)
Eric M Russell (4/23/2015)
...They can now login using their vanity 'SA' account and feel important...
...and then read your post and feel patronised??? That's not collaboration!!!
(I am assuming that...
April 27, 2015 at 11:26 am
Gary Varga (4/27/2015)
Eric M Russell (4/23/2015)
...They can now login using their vanity 'SA' account and feel important...
...and then read your post and feel patronised??? That's not collaboration!!!
(I am assuming that...
April 27, 2015 at 11:11 am
Iwas Bornready (4/27/2015)
We're still on 2008 R2. I wonder when MS will drop support.
I've been told by exectutive management that we'll remain on 2008 R2 until Microsoft drops support... so...
April 27, 2015 at 7:11 am
Viewing 15 posts - 3,916 through 3,930 (of 6,027 total)