Thanks for your part 1 article. I wish it had been published 4 weeks ago as it took me several hours to get to the stage of being ready to try out the Report Designer (using a real database of ours in a dev VM)! I think I really need to see Part2 - when […]
2004-03-04
2004-03-04
The only issue with implementing using a partitioned view is that you cannot use identity in any of your base tables, so if you have you WILL NOT see a performance improvement. I have seen some of the same problems and a lot can be done by indexing correctly, what you are joining on, and […]
2004-03-03
Thank you. The second certainly appears on target.Can you give me a reference, just for my network admin's reading enjoyment?
2004-03-03
I also think the answer quoted is incorrect :-BOL quotes "text in rowWhen OFF or 0 (disabled, the default), it does not change current behavior, and there is no BLOB in row. When specified and @OptionValue is ON (enabled) or an integer value from 24 through 7000, new text, ntext, or image strings are stored […]
2004-03-02
The first answer is the correct one. i.e.sp_tableoption N'Employee', 'text in row', '2000'Eventhough the other one with two statements is also correct, it is verbose.Elegant way is the one above.... Thanks..
2004-03-02
I have a very complicated SQL or at least it is to me the newbie. I have 4 tables -- EVENT, ENTITY, PERSON_INVOLVED, GLOSSARY. The EVENT table is the main table. Each EVENT can have one or more PERSON_INVOLVED record. Each PERSON_INVOLVED record has one ENTITY record. I need a view of the event, person_involved as patient, person_involved […]
2004-03-01
2 reads
SELECT SUM(*) as FINALVALUEFROM(select count(*) as Count_A from A UNION ALL select count(*) as Count_B from B UNION ALL select count(*) as Count_C from C UNION ALL select count(*) as Count_D from D UNION ALL select -1*count(*) as Count_E from E ) T
2004-02-26
2004-02-26
I have a newly installed SQL Server 2000 instance on a Windows 2000 Server machine, installed under the administrator account on Kong. SQL Server is configured for Windows authentication.The database is configured with only TCPIP.I have added two users, jcc\tom and jcc\keith (me).Tom is able to create an ODBC connection from his workstation with no […]
2004-02-25
2 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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