Viewing 15 posts - 2,611 through 2,625 (of 6,041 total)
It's standard practice in a star schema modeled data warehouse, where rows are versioned in what's called a 'slowly changing dimension' or 'shapshot' fashion, to have a column indicating (ie:...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 12, 2016 at 12:58 pm
Arjun Sivadasan (5/11/2016)
The last couple of months were tumultuous. My teammates quit and I'm the only dev...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 12, 2016 at 9:53 am
drew.allen (5/11/2016)
Eric M Russell (5/11/2016)
TheSQLGuru (5/11/2016)
Eric M Russell (5/11/2016)
drew.allen (5/11/2016)
Eric M Russell (5/11/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 11, 2016 at 2:42 pm
TheSQLGuru (5/11/2016)
Eric M Russell (5/11/2016)
drew.allen (5/11/2016)
Eric M Russell (5/11/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 11, 2016 at 1:45 pm
Because they grew up in an era without cubicles, the younger wave of IT recruits are (generally) more socially adept than those of us with gray hair; I'll give them...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 11, 2016 at 12:53 pm
drew.allen (5/11/2016)
Eric M Russell (5/11/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 11, 2016 at 11:58 am
For what it's worth, this one can be paramaterized in terms of the number of dates returned, and it doesn't require a pre-existing tally table, which might be useful in...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 11, 2016 at 9:46 am
Iwas Bornready (5/11/2016)
The problem I just had with it is that I do not have permissions to run this on production.
You can try requesting the following from the DBA:
-- allow...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 11, 2016 at 7:53 am
If you're organization is starting an IT automation initiative, then simply put: resistence is futile. When it does come time to downsize, then I guarantee you that those of you...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 11, 2016 at 7:12 am
Perhaps what you need is a composite unique key, which would be the business code combined with something like a date/time column. For example, let's assume an Employee table is...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 10, 2016 at 12:38 pm
If you have a database with heavy write activity, something like a high volume DW or ETL staging, then placing the transaction log on a RAM drive would probably yield...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 10, 2016 at 12:01 pm
For this type of row filtering based on TOP(x) ranking, you can use the DENSE_RANK() function like so. You'll need to experiment with the PARTITION BY and ORDER BY clause...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 10, 2016 at 11:46 am
There is no WHERE clause. This procedure will update all rows in the each column with the same value, which I'm sure this is not what you intend.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 10, 2016 at 9:59 am
TheFault (5/10/2016)
m_swetz (5/10/2016)
Money is good relatively speaking, but work/life balance is poor as the expectation is that I can be reached at all times, can work weekends, etc.
There's often a...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 10, 2016 at 9:23 am
onlo (5/10/2016)
Unfortunately, we only use SQL Server 2014 Standard Edition, we can't use the memory optimized table feature.
Can I move just one table (it is a staging table) to a...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 10, 2016 at 9:04 am
Viewing 15 posts - 2,611 through 2,625 (of 6,041 total)