Viewing 15 posts - 5,596 through 5,610 (of 6,041 total)
The most obvious way would be a SQL Profiler trace. The TextData column of the SQL:BatchCompleted event class will give you the StartTime and name of the procedure call and...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 20, 2011 at 11:29 am
GSquared (5/20/2011)
Eric M Russell (5/19/2011)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 20, 2011 at 6:48 am
I guess it depends on how you define a bug. If an application or database functions within the parameters defined by the requirements, then it has no bugs; even if...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 20, 2011 at 6:42 am
My guess is that either the transaction has already completed or you've rebooted the server by now. However, I found an article on Microsoft's CSS site about troubleshooting and resolving...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 19, 2011 at 8:11 am
It should be considered a good practice for a DBA to setup a notification or report of what objects are created or updated on the production server. That way one...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 18, 2011 at 7:46 am
Welsh Corgi (5/17/2011)
I'm no longer a kid (Goat).:hehe:
I think it's the title of "Babe" when juxtaposed with that avatar of a cute little puppy that throws people off.
😀
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 17, 2011 at 1:05 pm
Would "working harder" within the context of programming would mean taking fewer breaks?
I walk into the office at 8:30ish and leave about 6:30ish, setting aside about 2 hours a day...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 17, 2011 at 11:03 am
Welsh Corgi (5/15/2011)
I'm sorry. I will not post again to this forum. Best regards to everyone.
There is only a 53 point spread between "Say Hey Kid" and "Right There with...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 17, 2011 at 6:59 am
Steve Jones - SSC Editor (5/16/2011)
Jagadeesh Medabalimi (5/15/2011)
For me, SQL Server would be great if they can deliver exactly what they promise.Productivity, Security, Performance, Scalability, Robustness, and finally solid ROI.
What...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 16, 2011 at 11:21 am
Have you compared the execution plan between the two sessions?
ARITHABORT is one of those settings that can affect index usage, for example if it is OFF, then SQL Server may...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 13, 2011 at 2:50 pm
First time job seekers, those wanting to break into a new filed, and even recent college graduates are having the toughest time in this economy. Jobs are somewhat harder to...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 13, 2011 at 8:00 am
GilaMonster (5/12/2011)
Eric M Russell (5/12/2011)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 12, 2011 at 4:33 pm
No worries. The day that database administrators and developers are no longer needed; I'll just gracefully walk out the door and ride off into the sunset in my flying car.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 12, 2011 at 2:35 pm
richarddelcarmen (5/11/2011)
That's also what I fear.
You may already know this, but had you been running SQL Server 2005+, you could query T-SQL commands from the recent past from either the...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 12, 2011 at 2:14 pm
JP Dakota (5/11/2011)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 11, 2011 at 10:48 am
Viewing 15 posts - 5,596 through 5,610 (of 6,041 total)