Viewing 15 posts - 1 through 15 (of 42 total)
I found that there were several factual errors in the article and several differences of opinion. The following is a list, in no particular order:
1) "where the developer has...
December 19, 2003 at 5:45 pm
The case against identity keys follows along these points:
1) IDENTITY is proprietary to MSSQL.
2) Over time, the Surrogate key (IDENTITY) and the natural key WILL diverge. This is the...
March 31, 2003 at 5:01 pm
On top of VSS and QA we use the template capability of SQL 2000 (though you can fake this using text files in earlier versions).
In essence, we have a template...
March 31, 2003 at 4:41 pm
From your text, it sounds like the application and the database are at the client site. If the database was under your control, then you would be the only...
March 31, 2003 at 4:29 pm
Some of the SQL configuration settings have different default values in SQL 2000 and this has led to some situations where "everything is the same except the results".
Without seeing your...
March 28, 2003 at 12:11 pm
If you had a static table (Numbers6000) that held all the numbers from 1 through 6000, you could easily find the lowest missing number in YourTable:
where Number not...
March 21, 2003 at 12:14 pm
In Re: "Is it safe to just change the length in systypes?"
I would never make changes to the system tables directly.
One path to consider is to run Profiler while making...
March 21, 2003 at 11:47 am
quote:create procedure test1@val1 float,@val2 intasdeclare @val3 decimal(9,2)select @val3 = @val1insert into testtable1(TestField1, testfield2)values(@val3, @val2)-----------------------exec test1 20.8,12I did it and it is still...
declare @val3 decimal(9,2)
select @val3 = @val1
insert into testtable1
exec test1 20.8,12
I did it and it is still...
March 21, 2003 at 11:41 am
My results were strictly anecdotal. I had two different versions of the same script; the difference being that IsNull was replaced with COALESCE. We had decided to make...
March 11, 2003 at 9:50 am
quote:IsNull and COALSCE are te same except for the number of options supported.
March 10, 2003 at 4:23 pm
You might want to look at establishing a "covering index" for your three hot columns. It would depend on how you filter the retrieved data (WHERE clause). See...
March 4, 2003 at 10:26 am
This is a small modification that is designed to boost performance:
if exists(select * from tblname)
--do your xml stuff here
The EXISTS will terminate the select after the first record is found...
February 27, 2003 at 11:44 am
1) I (virtually) never put anything into the Master database. You mess up something here and you'll need to update your resume ;->
For the same reason, I don't let...
February 26, 2003 at 6:07 pm
quote:Another factor to consider is if the table has no Clustered index there is no guarantee you will get the same results...
February 26, 2003 at 5:44 pm
February 26, 2003 at 5:43 pm