2014-10-01
2,020 reads
2014-10-01
2,020 reads
A new article from Wayne Sheffield that examines the ranking functions in SQL Server. Learn how you can use ROW_NUMBER(), NTILE(), RANK(), and DENSE_RANK() in your applications.
2010-04-20
14,575 reads
I will add an index for all the searched fields with a fill factor of 90%. Do you think this is a good fill factor as the table could get into millions of records quickly. Also, do you think this will help in reporting where I have to join this table w/ other tables (other […]
2004-10-21
SELECT sg.sysusergroup_id, sg.sysusergroup_name FROM sysusergroup sg WHERE sg.sysusergroup_id NOT IN( SELECT susg.sysusergroup_id FROM sysuser_sysusergroup susg WHERE sysuser_id = '1' )Just as an alternative to the outer join technique./rockmoose
2004-05-19
Oops - went horizontal when you wanted vertical DECLARE @colName VARCHAR(30) DECLARE enabledCol CURSOR FOR SELECT columnname from TABLE WHERE ENabled OPEN enabledCol FETCH NEXT FROM enabledCol INTO @colName WHILE @@FETCH_STATUS = 0 BEGIN SET @selSQL = 'SELECT ''' + @colName + ''' ColName, ' + @colName + ' colValue FROM <sourcetable> where <condition> EXEC […]
2003-07-09
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers