Steve hits upon why I asked the question. Consider having two servers in the same domain with the same name as having two houses side by side both claiming to...

Triggers can always pose a performance problem and I'm not a real big fan of them. I use them when I have to for auditing purposes or when I...

In SQL Server the same function is LEN(). So the query would look as follows:

SELECT *

FROM news

WHERE LEN(title) > 8000

I'm assuming title is a text or ntext field?

K. Brian...

I've not dealt with them personally, as my environments aren't that large. However, to post the TPC benchmarks that SQL Server 2000 has garnered, Microsoft has used partitioned views....

And the problems didn't start occuring until after the help desk software was installed? What help desk software?

K. Brian Kelley

bkelley@sqlservercentral.com

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

Do the safe thing... Have your own backups writing to disk (if you have the space). Then, when they do the backup of the system, they'll pick up your...

The lazywriter process takes care of getting rid of old execution plans, but it doesn't get enacted unless it needs to reclaim the memory, either because another application starts up...

Right. If there's no decimal point, SQL Server will assume the constant to be an integer. Since integer divison should not result in a decimal part (violation of...

Let's start with making sure SQL Server was able to bind to the right port.

SQL Server listens by default on port 1433. When you run a:

netstat -an

do...

See the other topic.

K. Brian Kelley

bkelley@sqlservercentral.com

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

Unfortunately, no, as per Microsoft:

quote:

---

Trial versions of SQL Server 2000 Personal Edition, which runs on the Windows 98 and Windows Millennium Edition...

The simplest way is to break this into two separate CASE statements and concatenate the strings:

SELECT

CASE

WHEN col_one IS NOT NULL THEN col_one

BTW, articles by Steve and Andy on Worst Practices start here:

http://www.sqlservercentral.com/columnists/awarren/worstpracticespart1ofaverylongseries_1.asp

The latest one (which has...