Michael J. Swart posted an interesting question: he had a large table with 7.5 billion rows and 5 indexes. When he deleted 10 million rows, he noticed that the indexes were getting larger, not smaller.
2019-03-22
2,752 reads
Data Compression and Snapshot Isolation don't play well together, you may not see a performance benefit
2014-10-02
3,557 reads
This is the result set it presented and I don't understand.... I am running a summary on activity for the year...my columns being the different activities and the months - the timeframe I'm not sure what this is....1 D June 1 D August 6 D November 30 D December 2 P June 32 P July 1 PK June 1 PK July 2 PK August 3 PK November 3 PK December 2 U […]
2005-05-25
Hi, All: Here is a question that I could not figure out. Please share your idea if you know the answer... I have a table: id col1 col2 --- ----- ----- 1 A kk 1 B jj 1 C bb 2 D qq 2 E ffThe following should be the result: id col1 col2 --- ------- -------- 1 A,B,C kk,jj,bb 2 […]
2004-05-14
I have the following query that retrieves a list of users that belong to a particular group (in this case groupid 1).SELECT su.sysuser_firstname, su.sysuser_lastname, sug.sysuser_id, sug.sysusergroup_id FROM sysuser_sysusergroup sug, sysuser su WHERE sysusergroup_id = '1' AND sug.sysuser_id = su.sysuser_id ORDER BY su.sysuser_lastname, su.sysuser_firstnameI need to figure out a query that will return only users that […]
2004-05-13
4 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