Using OVER() to Remove Duplicate Rows
Tables used purely for reporting sometimes lack a unique identifier. Find out how to remove duplicates from such a table when data loads go bad.
2016-11-08
5,799 reads
row_number
Using OVER() to Fix Bad Version Numbers
See how the OVER() clause was used in a live system to fix overlapping field version numbers.
2016-10-17
2,248 reads
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
Convert Rows into Columns
Convert the rows of a SELECT statement into a predetermined number of columns.
2015-12-11 (first published: 2014-07-17)
26,993 reads
2015-01-23 (first published: 2013-10-08)
29,793 reads
RE: Job sequence out of order
Finally I got this problem fixed. The problem is the clustered index of Sysjobsteps table where step id is not in the order it suppose to be. Running DBCC DBREINDEX does not fix the problem, you really have to drop and recreate it. Following are the steps to reconstruct Sysjobsteps table:(1) Stop SQLSERVERAGENT(2) write down the […]
2004-11-17
Service Pack3 Installation problem
Hi All, I am configuring the sample database of MS Project 2003 on Windows Server 2003. But it gives an error of sql server service pack 3. While i installs the sql server SP3 on windows server 2003 it gives an error meanwhile, when it executes script. Let me know ASAP if anybody knows […]
2004-11-15
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: Stored Procedure - Expecting 2 input parameters - WHY??
Steve Jones:I see now - I was using VS.NET 2003 to run the Stored Procedure and now that I set the VALUE for @RowCount to NULL, it works perfectly. I now understand that it is expecting a parameter.Thanks a bunch!
2004-04-13
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