Based on visiting http://www.dtsearch.com it appears that dtSeach indexes and searches documents on your PC/Network. Full Text Search is a SQL Server Feature that allows you to do search...

I don't think there is a way to do that. It is a system function where MS does not provide the code. You could write your own UDF...

Adam Bean (3/6/2008)

---

Cory Ellingson (3/6/2008)

---

The biggest issue I had was with linked servers from the 64bit to 32 bit SQL servers. I had to run an update on all...

I have almost never gone back into older code without seeing ways I can improve it. Mainly because I am on sites like this and trying to learn more...

Isn't a Profiler someone who works for the FBI or something and tries to "get into the head" of the criminal? You know like on Criminal Minds 😀

I don't...

Matt Miller (3/5/2008)

---

I used to throw something like that into my Email signature.

It looked something like:

After I had been using it for a while, I got...

Thanks to all for the advice. I managed to get through the install okay. Now for actually using it!

Also I found something interesting about the REporting Services Windows...

EdVassie (3/5/2008)

---

Hopefully you will haveseen this already, but in 64-bit you MUST set the upper memory limit for SQL Server. Otherwise it treats the pagefile space as part of...

Looks like it should work.

Grant Fritchey (3/5/2008)

---

FWIW, I put two people through phone screens yesterday. Both had more than 8 years experience in SQL Server. Both were listed as senior level consultants. Neither could...

When you use the Like operator with a leading wildcard (%) an index scan is the best you will get. Also using Select * also will give you at...

Okay I am running my install and getting this warning:

- ASP.Net Version Registration Requirement (Warning)

Messages

ASP.Net Version Registration Requirement

32-bit ASP.Net is Registered. Required 64-bit ASP.Net to install Microsoft Reporting Services...

Lookup linked server in Books On Line or google it.

Did you or someone else go through the process of setting up a linked server? Remote Servers are being phased out in favor of Linked Servers.

Which server are you...

Okay, I found out that SSIS Lookups in Full Cache Mode are case-sensitive from these two places:

http://geekswithblogs.net/dtotzke/archive/2007/02/06/105585.aspx

http://sqlblogcasts.com/blogs/jorg/archive/2008/02/12/SSIS-_1320_-Lookup-Transformation-is-case-sensitive.aspx

I was able to solve my problem by going to the advanced tab and...