Since an Access DB was not really designed to be concurrent user you may gain some benefit by upsizing to SQL Server. You can test it first. The...

First, are you including all the tables in your database in the IN list? If you are you should get rid of the IN and use where TABLE_CATALOG =...

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.