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
integer math
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
2004-10-14
RE: SQL Server Clustering
If you're using the same shared storage unit, having a seperate partition for the TRANSACTION logs isn't going to make a massive difference performance wise because it's still using the same IO. However, saying that, it is probably still a reasonable plan to do this to :a) Keep things tidyb) Prevent Fragmentation (which WILL affect […]
2004-10-14
RE: Shrinking log file
Sorry Steve I had a hard day yesterday, You must be one of the lucky ones.More than once I have had problems with databases that are in full recovery that the log files do not whant to shrink no matter what you try until you 'reset' their recovery. This has remained an enigma but the sollution that […]
2004-10-14
RE: Question of the Day for 14 Oct 2004
As stated above the correct answer is syntax error for the reasons already stated
2004-10-14
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