If you're using Windows 2003 or later, you can rely on the operating system password policy.

For the SQL logins, see the CHECK_EXPIRATION and CHECK_POLICY options of the CREATE LOGIN...

I'm not sure that I understand this:

"the distribution, model, and MSDB moved themselves back to the orginal server hard drive from where they were moved"

...I suppose that you have limits regarding the number of pets that can travel in a certain container (depending on the pet, on the container, etc.....) - this could add...

Several pets can travel in a container, but I suppose that a pet cannot travel in more than one container at once...:-)

So you have an "one to many" relationship between...

...and attach an execution plan, if possible...

Run sp_configure with no parameters or query the sys.configurations catalog view. See BOL for details, permissions, etc.

Examining the actual execution plan would be really helpful - it shows you what to change (indexing, table structure), if you need any change.

Please see

http://www.sommarskog.se/dyn-search-2005.html

for solutions to challenges...

My guess is that the code corresponds to a search form - if you give more details, you can get help if you need further changes...

You're welcome...

Now examine the actual execution plan and see if you can still improve the code and / or indexing. For example, UNION adds a "sort" step to the execution...

I'm not sure that the full-text search is the main culprit for the lack of performance.

Can you eliminate the "UNION" and ORs from your code?

You're welcome 🙂

...and also see http://www.mssqltips.com/tip.asp?tip=1409

Let me recommend some excellent resources about using arrays as input parameters:

- http://www.sqlmag.com/Article/ArticleID/100657/sql_server_100657.html

- http://www.sqlmag.com/Article/ArticleID/100975/sql_server_100975.html

- http://www.sommarskog.se/arrays-in-sql-2005.html

Can you give more details about what you want to achieve?

Bru Medishetty (12/1/2009)

---

dmoldovan (11/30/2009)

---

Also if you do bulk data import / inserts, change the recovery model to "bulk logged" or "simple". BOL will guide you through the steps you need...