Viewing 15 posts - 3,931 through 3,945 (of 6,041 total)
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
...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 29, 2015 at 7:47 am
buddy__a (4/28/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 27, 2015 at 1:52 pm
I wish Microsoft would drop support for v2008R2 this year; I'd love to upgarde to v2014.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 27, 2015 at 7:11 am
I'll step up to the plate and work 50 hours a week, if there is a deadline approaching or when troubleshooting an issue in production. Also when learning a new...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 27, 2015 at 6:59 am
Viewing 15 posts - 3,931 through 3,945 (of 6,041 total)