Remi thanks. Just fuzzy thinking here in re-reading the original post I see that cartesian result is required. I must have a thing about requesting data that is not needed or creating a cartesian result when it is not needed. Speed and more Speed is always a concern. And it appears that I could use a does […]
2005-04-21
This was my original idea too butI did check the nulls - none. Only NOT nullable fields were the ones in the PK's in the tables and none of them was null in any of the tables..?select A.name, B.name, B.isnullable from sysobjects A, syscolumns B where A.id=B.id and B.isnullable = 0 and A.name like 'vins%' […]
2005-04-21
I agree as well.In the academic world everything can be made perfect, though in the real world everything ultimately has to be a tradeoff.. because it always depends I do belive (and hope I do as well) to always motivate comments when I say I think something is 'bad', and also try to provide or […]
2005-04-21
As a personal 'best practice' I ALWAYS reboot after SP or hotfix installations. You never know when you are going to run into that one instance that will drive you nuts ! And I even do so after an initial installation as well ...
2005-04-19
As I mentioned above: The /3Gb switch only applies to Virtual Memory, not physical memory. Therefore, it should not be needed to use the /3Gb for >4Gb and <16Gb.As far as I can see right now: Use of the /3Gb switch with less than 16Gb is needed when you need more than 2Gb for procedure […]
2005-04-08
Have you already tried to search here for "interview"? Returns several very useful threads.
2005-03-22
Run sp_configure "c2 audit", 1reconfigure with overrideRecycle the SQL Server.C2 auditing is now enabled and you will see trace files under mssql\data directory.
2005-03-21
2005-03-13
This is another variant:create function dbo.udfCamelCase(@strin varchar(500)) returns varchar(500) AS begin declare @copy varchar(500), @i int, @len intset @copy = lower(ltrim(rtrim(@strin))) select @copy = upper(left(@copy,1)) + substring(@copy,2, len(@copy)-1), @len = len(@copy) set @i = charindex(' ',@copy,1)while (@i < @len-1) and @i <> 0 begin set @copy = stuff(@copy,@i+1,1,upper(substring(@copy,@i+1,1))) set @i = charindex(' ',@copy,@i+1) end […]
2005-03-11
HI. I have a sql table that has a field that acts as a key but the field was not set up as key. I know there are duplicate values in that field and I want to be able to display the rows where this particular field has been duplicated. Can someone share some sql […]
2005-03-10
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers