Nasty Fast N-Grams (Part 1): Character-Level Unigrams
An article about tally tables, N-Grams and the fastest character-level N-Grams function available today for SQL Server.
2018-11-22 (first published: 2016-06-23)
11,677 reads
text manipulation
RE: DBCC DBREINDEX and MDF file size
I have done the DBCC DBREINDEX on a 180+ GB database. It did not increase the database (.mdf) file. It DID increase the log (.ldf) file by quite a lot.The end result was that the .mdf file was SMALLER and the .ldf was LARGER. Why? Well the .mdf has the index data and the reason […]
2004-10-22
T-SQL works in QA but fails when part of a job
HI, the title says it all really, the update statement is below and i would be greatful for any comments on why this happens. thanks, ade --Change Links from class to course UPDATE t1 SET t1.e_parent = t2.e_id FROM dbo.capd_moduleenrolment t1 LEFT OUTER JOIN dbo.capd_examsubjectentry t6 ON t6.ese_id = t1.e_id LEFT OUTER JOIN dbo.capd_moduleenrolment t5 […]
2004-10-19
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