Were there other processes going on such as backups being run, etc? If so, was some of this backup traffic impacting the network (is the network switched)?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

There are a several possibilities which could explain the difference in query time (and they aren't limited to these examples):

A) One query was blocked by an exclusive lock on the...

Are you speaking of the instructions titled "How to configure Analysis Services for the Web" in Books OnLine where you copy the msolap.asp file to \inetpub\wwwroot\ directory?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

It really depends on the type of conditional processing that needs to be done. Does it involve computed columns, string manipulation, or array comparisons? In some cases...

Yes, it looks like you've got the hang of it!

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

This is a long shot... are the collations different on the columns EmployeePayNumber and TAA_FINAL_APPROVAL_PAY_NO?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

Aside from Steve's question, the answer you can choose which columns to return by specifying the columns by name. Don't do a SELECT *. Do instead a SELECT...

In SQL, since we use single quotes to mark the beginning and end of character strings, we have to double up the single quotes when we intend for single quotes...

The only way I've found is to build a dynamic string and pass it through EXEC or sp_executesql (and this gets nasty on the single quotes for string parameters). ...

If I'm understanding your question right, you have the following situation:

Ser1 linked to Ser2.

Impersonate authentication.

Using NT authentication.

And you are seeing a failure.

Are you trying to access the linked...

This is the primary purpose for ISNULL, to replace a NULL value with some other value. Is there a restriction which prevents you from using it?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

What version of SQL Server are you using?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

OK, the firewall has been eliminated as the root problem since another system within the firewall has the same issue. Are there any applicable error messages in the event...

Could the clustered index have been created with the STATISTICS_NORECOMPUTE option?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

I'm not aware of any, but I can't recall off hand if MDAC 2.5 drivers for SQL Server support Named Instances. I know we have apps in production in...