GetNumsAB
A brand new, high-performing, "GetNumbers" or "fnTallyTable" function that can be used for defeating RBAR.
2020-07-02 (first published: 2016-03-23)
1,079 reads
RBAR
How to Make Scalar UDFs Run Faster (SQL Spackle)
It's a well known fact that Scalar UDFs are the stuff of performance nightmares in T-SQL. But are they really as bad as they say? SQL Server MVP Jeff Moden shows us that they might not really be as big a problem as you might think and what you can do when they actually are.
2014-06-24 (first published: 2012-08-01)
24,601 reads
RE: Saving DTS Packages
What I've done is to open each package in design view and save it off as a VB Script. Then, when I need to bring them back in, I either run the script from VB or from Access.To run the packages from either VB or Access, you need to set the references to Microsoft DTS […]
2004-09-30
RE: Exotic use of User Defined Function
As I pointed, it will be more than 999 number of records in a table.Column data must be assigned automatically by the database. No one wants to rebuid the applications. Anyway any mechanism must create a value and place it as default for the column.User defined function is set the value by default if NULL is […]
2004-09-29
RE: Help with Sql Select statement
quote: I agree also with the normalization aspect as well. Unfortunatly sometimes in the real world (or at least my world ) we get handed a probelem and have to deal with it. And I appreciate all the people who really try to help solve it. and to the rest I enjoy learning new words […]
2003-12-23
RE: QOD 12/17/03
It was very tricky ... and annoying. The next QOD should be: "write a query to grant 2 points to all people that answered "none of the above"
2003-12-17
1 reads
RE: comparing specific rows
Hi Andrew, quote: Is there a way to assign each of the values, i.e. t1.datefield to a variable.... i beleive the code would be DECLARE @var varchar(255) set @var = t1.datefield Is it possible to do this and if so where would i put the code? you can declare the variables and assign like select […]
2003-07-18
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