2017-03-09 (first published: 2017-02-16)
1,669 reads
numbers
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
RE: Changing Field Names in Tables
check out SP_Rename 'OldTableName', 'NewTableName', 'OBJECT' SP_Rename 'dbo.Table.ColName', 'NewName', 'COLUMN'
2005-02-16
Defrag/Re-Index
My Database hasn't been Defragged or Reindexed in over a year (maybe never) and it is timing out all over the place,so I really need to do this soon! I have been reading about indexes since the begining of the week (I knew nothing till then). I have also read almost everything on this site about them […]
2005-01-05
2 reads
RE: Moving to new file group
If you need performance in your database, then consider placing the data and indexes on different filegroups which are on different drive arrays or LUNs. It makes the backup/restore process longer, but you will receive data faster as the reads are across multiple drives. Another way to move a table or index is to use […]
2005-01-03
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
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