naresh_ee (4/9/2010)

---

Hi dude when the transactions will happens automatically the log size will grow,so on the time there is an option to shrink the log file,below are the command executed...

Outstanding article, Wayne. I must have missed it when it was first published. Nice job.

Your article raised a doubt in my mind. You write

Temporary tables can have named constraints, indexes,...

There must be something that makes your log grow. Try tracing the activity with profiler, maybe you'll find the issue there.

If it keeps growing, this means that your database is heavily hit by writes. You probably need to take log backups more frequently.

Growing the file by 1 Mb could lead...

You're welcome.

Glad I could help.

Gianluca

CirquedeSQLeil (4/8/2010)

---

I won't dignify your lack of dignification with a curious dignifying...

There are free export tools available, like this one:

http://www.codeproject.com/KB/database/DTS_Export.aspx

I'm sure there are others around, try to google for them. Finding this one took me 1 minute.

You could pick the port currently in use by the instance.

If you want to know the port numbers currently in use by the system, use this:

NETSTAT -anp TCP

Edit: Removed to make Lynn curious. 😀

Topic of the day: commutative posts. :w00t:

Jeff Moden (4/8/2010)

---

Heh... I've run into that many, many times. Perhaps an article titled "The execution plan lies"....

This should do the trick:

SELECT docID, projid, typeid, ver

FROM #DOCS AS A

WHERE ver = (

SELECT TOP 1 ver

FROM #DOCS AS B

WHERE A.projid = B.projid

AND A.typeid = B.typeid

ORDER BY CASE...

Oh, I see. Sorry, I misunderstood your question.:blush:

Well, I don't know if there's a best practice for choosing a port number. I can only tell you that the port numbers...

Lynn Pettis (4/8/2010)

---

You know how at work one aw s**t wipes out a thousand atta boys? In parenting it's one atta boy wipes out a thousand aw s**ts, at...

When your reader app is blocked, open the Activity Monitor and try to identify the connection used by the writer app.

I don't remember if SQL 2005 SSMS Activity Monitor displays...