<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss Content Posted by Steve Jones
»
SQL Trace
13 posts, Page 1 of 2
1
2
»»
SQL Trace
Rate Topic
Display Mode
Topic Options
Author
Message
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Thursday, September 18, 2008 11:28 PM
SSC-Dedicated
Group: Administrators
Last Login: Yesterday @ 6:14 PM
Points: 31,421,
Visits: 13,734
Comments posted to this topic are about the item
SQL Trace
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #572265
Robert-378556
Robert-378556
Posted Friday, September 19, 2008 7:30 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 8:40 AM
Points: 1,078,
Visits: 848
It's like the question: What is the color of apples?
a) some are red, some are green
b) some are red, some are yellow
c) partly red, partly green
d) brown
Which answer is 100% correct? None and all of them.
Post #572504
michael.kaufmann
michael.kaufmann
Posted Friday, September 19, 2008 7:59 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, February 06, 2013 11:51 PM
Points: 1,263,
Visits: 1,079
Can't but agree with you.
"[...] If the disk fills while the database is online, the database remains online, but data cannot be inserted. [...]" (see http://msdn.microsoft.com/en-us/library/ms366198.aspx)
So I guess it's one of those "you're basically right but you haven't got it right" things. ;)
Post #572543
Cliff Jones
Cliff Jones
Posted Friday, September 19, 2008 8:08 AM
Hall of Fame
Group: General Forum Members
Last Login: Yesterday @ 12:39 PM
Points: 3,397,
Visits: 3,405
With a server side trace you can choose the drive to which the trace goes. One of the benefits of doing that is that it won't fill up the drive where the OS resides. I would not choose the drive that the data files are on.
Post #572557
michael.kaufmann
michael.kaufmann
Posted Friday, September 19, 2008 8:39 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, February 06, 2013 11:51 PM
Points: 1,263,
Visits: 1,079
You are perfectly right and I fully agree.
However, my comment was targeted at the way the question of the day was worded--there is no indication of where the trace would be stored and hence leaving room for actually 'check all that apply' and not just 'one correct' answer. Just as Robert pointed out in the first comment.
Post #572592
Lynn Pettis
Lynn Pettis
Posted Friday, September 19, 2008 8:55 AM
SSC-Insane
Group: General Forum Members
Last Login: Today @ 12:11 AM
Points: 21,602,
Visits: 27,431
Sometimes, I think people think too hard with some of the questions.
Lynn Pettis
For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here
or
when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here
and
here
Managing Transaction Logs
SQL Musings from the Desert
Fountain Valley SQL
(My Mirror Blog)
Post #572610
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Friday, September 19, 2008 9:13 AM
SSC-Dedicated
Group: Administrators
Last Login: Yesterday @ 6:14 PM
Points: 31,421,
Visits: 13,734
Even if the disk fills up, data can be interested into a database provided it does not need to grow. Databases typically have free space in them, and if yours don't, I'd argue you aren't managing them well.
The question is about trace, not about databases, and you're making assumptions that don't need to be made. The questions typically are based on a simple situation, not trying to cover all bases.
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #572632
michael.kaufmann
michael.kaufmann
Posted Friday, September 19, 2008 10:30 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, February 06, 2013 11:51 PM
Points: 1,263,
Visits: 1,079
Apologies for my wholistic approach and for quoting MSDN.
Post #572707
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Friday, September 19, 2008 10:37 AM
SSC-Dedicated
Group: Administrators
Last Login: Yesterday @ 6:14 PM
Points: 31,421,
Visits: 13,734
You misquoted MSDN. The quote before that says IF the data files need more space and can't get it, a database engine error is issued. The quote misleads people to believe that SQL Server behaves like Word, Excel, Access, etc. in that every insert requires new disk space.
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #572713
Shubh Chandra Jha-248340
Shubh Chandra Jha-248340
Posted Saturday, September 20, 2008 1:09 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Monday, December 07, 2009 4:52 AM
Points: 117,
Visits: 22
I think question is good and answer is also good.
Out of space not stop your service, but it also not allow
to continue
your work
Post #572946
« Prev Topic
|
Next Topic »
13 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
