Viewing 15 posts - 5,746 through 5,760 (of 6,105 total)
In this case, the constraint is: DF__Contacts__Label__0B335E0F. I'm assuming the column was created with a DEFAULT value, because this looks like a SQL Server generated constraint name. However,...
February 1, 2002 at 2:09 pm
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...
February 1, 2002 at 2:06 pm
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...
February 1, 2002 at 9:54 am
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...
February 1, 2002 at 8:49 am
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....
February 1, 2002 at 8:45 am
And the problems didn't start occuring until after the help desk software was installed? What help desk software?
K. Brian Kelley
February 1, 2002 at 8:33 am
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...
February 1, 2002 at 8:27 am
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...
February 1, 2002 at 8:25 am
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...
February 1, 2002 at 8:11 am
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...
February 1, 2002 at 8:08 am
See the other topic.
K. Brian Kelley
January 31, 2002 at 7:55 pm
Unfortunately, no, as per Microsoft:
quote:
Trial versions of SQL Server 2000 Personal Edition, which runs on the Windows 98 and Windows Millennium Edition...
January 31, 2002 at 7:53 pm
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...
January 31, 2002 at 7:33 pm
Viewing 15 posts - 5,746 through 5,760 (of 6,105 total)