RE: Joins vs one flat table
check Denormalisation on the web. There a whole set of info needed to take that decision
2003-05-08
1 reads
editorial
2003-05-07
1 reads
RE: Renaming columns, stored procs, triggers
Depending on how many offending columns there are: I would be inclined to do this: 1) Generate SQL for the entire database. Only grab stored procs, triggers, etc; the things you aren't going to be changing manually. 2) Create your script to update all the object names appropriately. Record the original and updated names as […]
2003-05-07
RE: Failover Clustering
Thanks bkelley. Cool website too http://www.warpdrivedesign.org. Can log shipping be implemented with clustering? How does this work? Is there any documents out there that outline how this works.
2003-05-07
RE: Auto Close and Auto Shrink - Just Don't
On the databases I have AutoClose off. It's one of those really bright ideas that no one wants. Autoshrink is off because I found it twice trying to shrink itself during a very heavy I/O time (which added to the length of time for the process). I just use DBCC SHRINKFILE(table, size). Patrick
2003-05-07
1 reads
RE: Use Results from a Cross Join for dynamic SQL
Have to look again tomorrow, but can u tell me what results you would expect from 1 A Yes 1 A Yes 1 A Yes 1 B Yes 1 B Yes 1 C Yes 2 B Yes 2 B Yes 2 B Yes 2 C Yes 2 C Yes 3 A Yes 3 D Yes […]
2003-05-07
1 reads
RE: Use Results from a Cross Join for dynamic SQL
Hey, not quite there yet, but not bad. If you have only 6 respondents you cant have a base size of more then 6. In your case you are getting 14... Basicly if respondent 1 has mentioned A then we dont count him for B when looking at AB he only gets counted once. Again […]
2003-05-07
1 reads
RE: Computer lazy after error on programming with SQL
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-05-07
RE: Use Results from a Cross Join for dynamic SQL
Yes, I think thats right for one respondent. I am saying 1 A Yes 1 B Yes 1 C Yes Might produce 1 A or 1B or 1 C if 1 respondent has answered 1 to all the products. However with if we have 2 respondents and resp1 give yes to A and B. And […]
2003-05-07
1 reads
RE: Use Results from a Cross Join for dynamic SQL
Are you saying 1 A Yes 1 B Yes 1 C Yes produces A 1 AB 1 AC 1 BC 1 and 1 A Yes 1 B Yes 1 C No produces A 1 AB 1
2003-05-07
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers