I agree with David, but I am going to say a Quote a buddy told me once. SQL Server has gotten so big, you can no longer say you...

Sorry didn't reply been out of office, thanks for picking up my slack David :D.

I have never found really a book that has all the answers for performance tuning, I...

Database Mirroring (as name suggests) is database level, so if you are looking for a way to find out which servers are participating in Database Mirroring sessions; this is not...

I have given each instance/tempdb its own disk. In setting up multi-instance/multi-node SQL Cluster environments, I use disk mount points for one. So each instance gets a mount...

As David suggested that is not possible nor is it proper way to do consolidation. Things you need to evaluate are Processor Usage, Disk I/O, Network Usage, and...

Hi,

Question for you, are you using this query in a stored procedure? If so you might have issue with parameter sniffing; which can cause SQL Server...

I use the SQL Scheduler job for my "SQL Automation Engine" I designed. Works pretty slick ;-).

So I would go with scheduler route :D.

- Mohit.

Assuming the user has permission to execute job with in SQL Server; I think you can simply use sp_start_job.

So make sure the user has SQL Server client tools installed on...

Hi 🙂

I got response from Microsoft, it is for Natural Langauge processing and was used in SQL 7.0 and 2000 but starting 2005 it is not used by SQL Server...

Thanks Paul.

What Tal said is also correct, I did actually found a noise.dat file in C:\Windows\System32 that was hidden. In addition to the langauge files; I don't know...

Interesting I have never read anything on that file; how is that file applied in the Index build or search functionality?

My issue turned out to be simple; my automation process...

Further research it appears it excludes other preposition keywords; however it does index many keywords. I found following keywords are also being excluded:

about, after, as, at, before, between, but,...

winan888 (9/4/2009)

---

Hello,

Thanks for your info, I got confuse today!.. my app runs very very slow .. my app vendor asks me to shrink database and defrag db..

I am new...

What...

There are many more tests you can do; at the end of it you have to be confident that the cluster will stay up. If you are happy with...