Thanks David 🙂

tymberwyld (1/6/2009)

---

thierry.vandurme (1/6/2009)

---

I don't really understand how this reduces server resource utilization except for network traffic. If a user is paging through the data screen, only a screen full of...

cetin (1/6/2009)

---

I think the code in that article (the one that uses row_number) has one problem. What if:

User A retrieves first page (rows 1-25 in name order)

User B deletes one...

jctrelfa (1/6/2009)

---

Please forgive my ignorance - but this seems like a lot of extra overhead:

DECLARE @max_id INT

SET @max_id = (SELECT max(contactid) FROM [Adventureworks].[Person].[Contact])

INSERT INTO Contacts

SELECT TOP 1000000 --<<<--THE NUMBER OF...

So to verify/recap, the default action for SQL Server is to start a new trace file each time it's rebooted and it keeps at max 3 trc files. That...

Carla Wilson (11/12/2008)

---

Adam Haines (11/12/2008)

---

Good article!

This type of query can be handled much easier in SQL 2005, but I would still try to avoid a correlated subquery in SQL 2000....

Good article!

This type of query can be handled much easier in SQL 2005, but I would still try to avoid a correlated subquery in SQL 2000. You can move...

Sounds like you have a very active server. The default trace will only maintain 5 trace files at a time. I believe your issue is that you can only...

YSLGuru (11/11/2008)

---

Adam,

Oustanding article; gives what users really want! Interesting question though, any thoughts as to why one may have Default trace data going back only a few days even...

Marcia Q (11/11/2008)

---

Thanks for posting this article - I didn't know this trace was out there.

Does anyone have any suggestions as to why my default trace doesn't show up? ...

Brian Strickland (11/11/2008)

---

Forgive me for being unclear, but our servers don't have a log.trc file. There are a number of other trc files with naming conventions like log_xxx.trc. On one...

Brian Strickland (11/11/2008)

---

I think this is a very cool tool. My only problem is that on all our servers, the most recent trc file is not log.trc, it is something...

Jack,

Thanks for the BOL quote. I find it somewhat amusing that MS states that sys.traces should be used instead of fn_get_trace_info on the sys.traces page; however, on the fn_trace_getinfo...

Yes, you have to tell SQL to explicitly turn off this feature by issuing the sp_configure command.

I cant really say what the exact cost is because the cost is dependent on multiple...