To piggy-back on what Andy has already said... varchar saves you space, char performs "slightly" better. Is that slight performance increase noticeable? Probably not for most uses.

The overhead...

I think Andy is speaking of typical OLTP environments. Barring an indexed view, if we find we're having to make a large number of JOINs to return data, we...

There is an article in the most recent SQL Server Magazine that briefly mentions it in relation to Page Splits/sec. Basically, the advice is to run it twice and...

I'm not seeing anything in the knowledge base off-hand, but I'll keep searching.

Two questions just to make sure:

1) Is Full Text Search installed on the server?

2) Is Full Text Search...

That does sound extremely unusual, perhaps a Microsoft feature. Have you tried to recreate the behavior from a different client as opposed to the server?

K....

There are tools such as Mercury Interactive's WinRunner and LoadRunner which can stress test an application, but they aren't the only ones in the business. Do you need to...

What is the hotfix? We run applications here that are highly reliant on COM+ and I'd be interested in reading up on what the fix is.

K. Brian Kelley

bkelley@sqlservercentral.com

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

We run several SQL Server clusters, but we tend not to remove BUILTIN\Administrators from SQL Server, even on non-clustered servers for a myriad of reasons discussed in some previous threads....

If these are utility stored procedures intended to be used in every database, you might want to try putting one in the master database and naming it with the prefix...

The model database is what is copied whenever a new database is created. If you are sure you want a certain set of objects in every user database, put...

You can't specify which port the listener is on, so far as I am aware. There may be an undocumented registry hack, but there isn't anything with the normal...

I've gone back and forth in "career paths" from developer to sysadmin to developer (again) to dba to sysadmin (again). So keep in mind that any current choice of...

UDP - User Datagram Protocol. Sits on the same layer of the OSI model as TCP but serves a different role.

It's used for connectionless transport. Low overhead, so...

This doesn't serve as a redirector. It keeps track of the ports each instance is running on. A client can communicate via UDP to port 1434 to retrieve...

The operating system will open up ports for listening, just like you can open up multiple ports for say IIS. The various instances know to listen on those particular...