Lab Sql

I have around 300 tables which are located in different partition and now these tables are not in u… Read more Efficient Way To Change The Table's Filegroup

Suppose I have a table like this: id | part | value ----+-------+------- 1 | 0 | 8 2 | 0 … Read more How To Enumerate Groups Of Partitions In My Postgres Table With Window Functions?

I have data that looks as such: +-----+--------+--------+--------+ | ID | score1 | score2 | score3… Read more Ranking Values To Determine Highest Value

I'm trying to Partition a Table by both Year and Month. The Column through which I'll parti… Read more How To Partition A Table By Month ("both" Year & Month) And Create Monthly Partitions Automatically?

I am trying to drop an empty table drop table temp; the query is running forever. So, I tried to fi… Read more How To Find The Queries That Is Blocking Another Query?

I want to dynamically declare the range of my partition function. I don't want to hard-code the… Read more How To Dynamically Declare Partition Range In Partition Function In Sql Server

I'm familiar with the concept of using partitions in Oracle as a technique to pubish incrementa… Read more Partition Exchange As Publishing Technique In Sql Server?

I'm trying to create a table which takes dates of when a employee is sick and create a new colu… Read more Tracking Continuous Days Of Absence From Work Days Only SQL