I modified your function as follows:

CREATE

FUNCTION dbo.MySeqDates (@LowDate DATETIME, @HighDate DATETIME)

RETURNS @Dates...

In the first code sample, I suppose that this portion should return each number between 0 and 32, right ?

SELECT

a.i...

Q: What is checkpointing?

A: Checkpointing is the point at which the system checks to see if the transaction log needs to be truncated.

This answer is not completely wrong, because...

Oops, I was wrong... The GUID-s generated by SQL Server are random, even if the server runs on Windows 98 ! The GUID-s are sequential only if they are generated...

I answered that in SQL Server 2000, the GUID-s generated by NEWID() are always random (which seemed to be the most appropriate answer), however this is not entirely true.

The...

Good news: Microsoft has issued a fix for this in SQL Server 2000 SP4 (actually, in 8.00.0954):

http://support.microsoft.com/kb/870972

You have to enable trace flag 9055 to activate the "threshold improvement".

Razvan

The DATEPART(WK,...) function does not return the ISO week number. If you need the standard week number, use the following function (the first example from the BOL topic "CREATE FUNCTION"):

CREATE...

I recently found out that Microsoft has added a new KB article for this issue:

http://support.microsoft.com/?kbid=883415

The good news is that there is a hotfix,...

You get an error because "GO" is not a T-SQL keyword, it's a batch separator; normally it should be processed by the client tools (not by the server). You could parse the...

Indeed, you should use the Server Network Utility to enable the TCP/IP protocol (and maybe disable the Named Pipes protocol). It may also be useful to read the following article:

The first part of the procedure is good enough, but a better solution could be done for the final evaluation. Instead of using a temporary table, we can use output parameters in...

Here is another way, without using a subquery:

SELECT item_grp, CASE WHEN COUNT(item_value)<COUNT(*)
 THEN NULL ELSE SUM(item_value) END AS raw_sum
FROM ab_sum_nulls
GROUP BY item_grp

And here is another one, without using a CASE:

Steve,

Regarding your question "why a query with INNER JOIN-s may perform worse than the equivalent query with WHERE conditions": this is theoretically possible (although in very rare circumstances), because of...

AFAIK, the correct syntax is:

CONTAINS (contents, '"lighting" AND "futures"')

Razvan

OK, Frank, go ahead.

It would be nice, however, if you'd have an english version of your site.

Razvan