The built-in Windows 2000 defrag is absolutely rubbish. You need at least 15% free disk-space to do a defrag and even if you have the tool will tell you...

I too have misgivings about the CLR. I've read somewhere that there are people in Microsoft who have misgivings. Something to do with a badly written piece of...

Nice debate Joe.

Short circuiting has been true of in every SQL you know about. I didn't know but I do now. Perhaps I should buy some of your...

OK, so EXISTS short circuits. Great. One less thing to worry about.

I would hardly call using stuff that has been in MS SQL Server since version 7 (and...

sp_help 'your table name here'

Brings back all sorts of information on the table including the primary key.

Joe, does EXISTS short out SELECT * FROM..?

If you are programming for SQL Server then why ignore valid SQL statements?

If I am going to develop for cross platform compatibility then...

If you are going to do it Joe's way then perhaps

UPDATE Poz

SET tip = 'k'

WHERE EXISTS

(SELECT TOP 1 J.con

...

Well, the field itself will simply reject any date that isn't in the correct format but if you had a stored procedure to do some bespoke error handling you could...

Yes, continuous push replication. Only the tables are replicated.

I solved the problem by removing the triggers but the idea that the inserted table contains NULL values in the field...

If you are adding an IDENTITY field to an existing table this suggests that the table doesn't already have a primary key and doesn't link to anything. It may...

It is a convoluted subject and one I don't fully understand myself.

It was covered in an article in SQL Server Standard by one of the Brians.

The gist of it is...

The biggest problem is where someone tries to write a query to access a specific user table that is not their user table.

As you know SELECT * FROM Authors will...

No it is not valid syntax.

You could try creating a view and then indexing that.

UPDATE poz

SET tip='k'

FROM pos INNER JOIN juridic ON poz.con = juridic.con

WHERE juridic.dosar='p'

Pass your colleges in as a delimited string and use the following function

CREATE FUNCTION dbo.fnSplitDelimited ( @sInputString1 VARCHAR(8000) , @sSplitChar CHAR(1))

RETURNS @tbl_List TABLE (Id1 Int PRIMARY KEY )

AS

BEGIN

DECLARE@lInputStringLength1Int ,

@lPosition1Int ,

@lSplitChar1Int...