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,675 reads
SQL Performance
DigitsOnlyEE and AlphaNumericOnly
A nasty fast way to remove non-numeric and non-alphanumeric characters from a string
2019-03-15 (first published: 2016-05-17)
2,441 reads
Translate function for SQL Server
Relational database management systems such as Oracle, Postgres, DB2 and Teradata, as well as other programming languages such as Python, Hive, XSLT and SAS have a Translate function. Now we have one for SQL Server.
2016-06-01 (first published: 2016-05-12)
940 reads
2015-08-31
277 reads
High-Performance Transact-SQL with Window Functions
Window functions are more intuitive and simpler in many cases than alternative SQL methods.
2013-12-02
8,586 reads
RE: Drill Down Problems
The sample was not showing hidden when I would go through the "Edit Group" route, so this was how I setup my report. But when I went into the XML, it listed the hidden and toggle item properties. I didn't know they wee separate items and thought the Wizards (Edit Group, etc) read and wrote […]
2005-05-25
RE: higher reads when using ADO.NET thatn when using Query Analyzer
I ran the example given (added bigger table to give reads but almost exact) and I could not reproduce the behavior. .Net SqlClient Data Provider RPC:Completed exec dbo.myProc @myparam = 'ALL' 358 readsSQL Query Analyzer SQL:BatchCompleted exec dbo.myProc @myparam = 'ALL' 358 reads kay brought up a good tip also, but it's hard to say what actually […]
2005-01-15
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
2004-10-14
Blogs
T-SQL Tuesday #176 One piece of advice that you wish Past you had
This month’s T-SQL Tuesday is hosted by a dear friend, long time SQL Server...
T-SQL Tuesday #176: One piece of advice for Past Steve
By Steve Jones
I almost missed this month, so this is also a good #SQLNewBlogger post. I...
Deleting Old Local Git Branches–#SQLNewBlogger
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
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