Viewing 15 posts - 1 through 15 (of 89 total)
To identify runs of eight 1s you can use the following select statement:
select * from
( select
case
when Val...
October 8, 2020 at 9:10 am
Hello kuopaz, the following elegant solution uses only windowed sums to obtain the desired result:
/* INPUT TEST DATA (from original post) */
declare @T table(ID int not null...
October 7, 2020 at 9:26 pm
Maybe few of us did notice this enhancement that was somehow secretly added in a service pack, but since SQL 2016 SP1 we may use CREATE OR ALTER and it...
November 6, 2019 at 10:44 am
Because so many breaches stay undetected for years (or forever?) it is not hard to imagine how this data could be used for 'social hacks' or impersonation. Knowing a lot...
February 25, 2019 at 2:37 am
vsamantha35 - Wednesday, August 23, 2017 1:20 PMSELECT
....
....
WHERE t1.tran_dt BETWEEN DATEADD(DAY,-DAY(t2.updated_dt) + 1,t2.updated_dt) AND DATEADD(DAY,-1, DATEADD(MONTH,1,DATEADD(DAY,-DAY(t2.updated_dt)+1,t2.updated_dt)))
Hello Sam,
I'm always glad...
August 25, 2017 at 6:33 am
Looking at this I feel that the example starts off denormalised.
The usual reaction of an DBA fits again: it depends. The source for the language codes is not...
August 7, 2017 at 3:37 am
In my humble opinion, to work together as a team, it is indeed good to know each others strong and weak points, better and lesser qualities, and maybe some core...
July 11, 2017 at 3:14 am
To me the rise of the ORM is an obvious indicatior for the need for object oriented databases by application developers. To share data, one must not only be able...
February 21, 2017 at 3:34 am
Hello muralikrishna2489,
Did you notice that in your orginal query as well as in some of the answers, three intervals are set...
February 17, 2017 at 2:56 am
January 18, 2017 at 2:50 am
Check the power settings of your server. We've had a simular issue in the past. Changing the power settings from balanced to high performance nearly doubled its SQL processing speed....
October 19, 2016 at 1:34 am
GilaMonster (10/14/2016)
river1 (10/14/2016)
Every time I call this procedures I pass difterent parameters and it seems that the query plans demage performance based on this.
With recompile might fix that,...
October 18, 2016 at 5:39 am
RonKyle (7/8/2016)
July 8, 2016 at 1:17 pm
Too bad a bunch of developers assume this intelligence is already present in today's database engines, using code first to persist their objects without further considerations about consistency and performance....
July 8, 2016 at 3:32 am
To Gail Shaw:
It is not an easy task to maintain referential integrity in a data warehouse. We decided to consolidate the data from different sources into one data store with...
June 23, 2016 at 1:45 am
Viewing 15 posts - 1 through 15 (of 89 total)