GilaMonster (1/10/2010)

---

I ran across this late last night, linked from, of all places, a fitness site. Several points that I greatly agree with.

hackers have a reputation for meeting simple questions...

Paul White (1/10/2010)

---

Indeed. i was thinking of an 0900 number...

Thanks for the great read.

Lynn Pettis (1/9/2010)

---

ifila (1/9/2010)

---

--SELECT DISTINCT TOP 1000 Email

SELECT COUNT(DISTINCT(Email))

FROM(SELECT Email1,Email2,Email3, Email4,Email5,Email6,Email7,Email8,Email9,Email10 FROM outputresume3

WHERE ((contains (originalresume, '"project" and "manager" and "php"'))

...

I disagree that a mistake was made in posting the...

Nice one Jeff. I missed it the first time around (and never searched for anything that pulled it up here at SSC). Adding this one to my reference...

That is extremely annoying. Some PMs and some emails is one thing - but then to go to the next medium.

If it is somebody I know, I would be...

AndrewSQLDBA (1/9/2010)

---

Thank you to everyone for the wonderful ideas and thoughts about this issue

I greatly appreciate the code samples given by Jason, I will keep that one in my stash...

drew.403 (1/8/2010)

---

...

Is it possible to have a select statement (or 2) return the records? again I'm using a webserver and need it to be able to run from code in...

Jeffrey Williams-493691 (1/8/2010)

---

CirquedeSQLeil (1/8/2010)IMO - static ports. This will help to prevent connection issues due to port changes.

Every Instance must be on a different port - otherwise SQL server...

BTW - you're welcome.

rambilla4 (1/8/2010)

---

Thank you, I got it. But I want to know which one is the Best practice

1. Dynamic ports for all named instances

2. Set a static port for all named...

Server Configuration Manager --> TCP/IP properties --> IP Addresses -->TCP port should have something and dynamic should not.

ALZDBA (1/8/2010)

---

IMO, sampling the proc cache on a daily basis is a way to long interval.

It is indeed a good way with minimal impact and no modification of existing stuff.

FWIW...

A method I have used in the past was similar but only worked for 2005. However, I did not modify any procs.

I setup a daily job to run the...