Viewing 15 posts - 2,731 through 2,745 (of 3,655 total)
I would be extremely suprised to find that Windows defrag and Diskeeper were the same product.
No-one would willingly buy a product that was as bad as Windows defrag.
May 24, 2005 at 1:11 am
I think the problem is that as you gain seniority you get promoted and assigned to lead teams without anyone giving any advice or training on how to go about...
May 23, 2005 at 2:12 pm
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...
May 23, 2005 at 8:02 am
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...
May 17, 2005 at 1:41 am
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...
May 16, 2005 at 1:47 pm
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...
May 16, 2005 at 8:02 am
sp_help 'your table name here'
Brings back all sorts of information on the table including the primary key.
May 16, 2005 at 7:23 am
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...
May 16, 2005 at 7:19 am
If you are going to do it Joe's way then perhaps
UPDATE Poz
SET tip = 'k'
WHERE EXISTS
(SELECT TOP 1 J.con
...
May 16, 2005 at 2:02 am
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...
May 13, 2005 at 1:46 am
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...
May 12, 2005 at 9:59 am
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...
May 11, 2005 at 1:27 pm
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...
May 11, 2005 at 7:57 am
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...
May 11, 2005 at 6:59 am
No it is not valid syntax.
You could try creating a view and then indexing that.
May 11, 2005 at 4:11 am
Viewing 15 posts - 2,731 through 2,745 (of 3,655 total)