Viewing 15 posts - 76 through 90 (of 824 total)
We use snapshots extensively in development and they have been a godsend there; they have saved us untold hours. However, for our production systems we avoid snapshots except as...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
September 23, 2008 at 8:22 am
Thomas Keller (6/10/2008)
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 10, 2008 at 2:53 pm
Eric, that's a good point about 2000. Traces in SQL 2005 have been significantly improved in several ways including making them generally less expensive. I just assumed that...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 10, 2008 at 2:41 pm
Jack Corbett (6/10/2008)
Eric Stimpson (6/10/2008)
You can examine the contents of the trace after you've stopped it by using this select:
Therein lies the rub, I think. A trace used for...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 10, 2008 at 1:26 pm
GSquared (6/10/2008)
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 10, 2008 at 10:33 am
Jack Corbett (6/10/2008)
DCPeterson (6/10/2008)
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 10, 2008 at 10:18 am
Jack Corbett (6/10/2008)
DCPeterson (6/10/2008)
Now, tracking which queries were sent, which tables/columns were queried, and who sent them makes sense and is easily accomplished with a trace.
This is why I did...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 10, 2008 at 9:11 am
These were a pretty good basic overview of two of the options available. I think there is one option that was left out that offers much more flexibility than...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 10, 2008 at 8:32 am
Sir Slicendice (5/2/2008)
The standardized hierarchical nature makes it...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
May 2, 2008 at 11:44 am
Thanks for thinking! That was my main goal, to get people to THINK instead of just accepting what vendors were feeding us.
One quick correction if I may:...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
May 2, 2008 at 10:34 am
Someguy (5/2/2008)
By the time I'm getting here, we're on 12 pages of replies. Admitting that only a handful of people will read this far, I might as well throw in...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
May 2, 2008 at 9:06 am
There's a much simpler way to do this:
select ServerUptimeInHrs = datediff(hh, Login_time, current_timestamp)
from sys.dm_exec_sessions
where session_id = 1
That gives you the hours, obviously days, minutes or whatever are just as easy...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 11, 2008 at 4:02 pm
I don't tend to make extensive use of views. Most of the time they are used to simplify query writing, or to provide an abstraction layer between users and...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 3, 2008 at 4:24 pm
No, the discussion is not "off topic" because the original article, and many of the earlier posts are informed by the pay gap myth. My posts were merely to...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
March 24, 2008 at 8:49 am
Thank you, I figured I was doing something stupid like that, I just couldn't see it for anything.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
March 4, 2008 at 1:51 pm
Viewing 15 posts - 76 through 90 (of 824 total)