Easy one for Friday, thanks 🙂

bilal 17797 (7/9/2014)

---

Hi,

I want to write sql query which runs in a background on cyclic basis. Basically i want to count the row entries of 1 table and store the...

Query should be

select mvID, title, rating, length...

You need to use ALTER PARTITION SCHEME to put next set of data & ALTER PARTITION FUNCTION with SPLIT RANGE command to do the job.

Refer:

ALTER PARTITION SCHEME - http://technet.microsoft.com/en-us/library/ms190347(v=sql.110).aspx

ALTER...

Physical joins are the ones, which will be used by sql Server internally. You will not write queries with them unless you explicitly specify with Hints.

Logical joins: Inner join, Outer...

chengchong36 (7/9/2014)

---

Last week I backed up my SQL Server by using BE 2012. I named the file "SQL Server BAK" which contained copies of my SQL Server databases. A few...

Nice one, thanks for sharing

if runtime temp table is ok then you can use below:

SELECT * INTO #tempTable FROM...

Thanks for sharing.

+1

Please share if you have already done something.

There are options like CTE, Self - joins,...

It is hard to say without any details. How you...

Koen Verbeeck (7/8/2014)

---

Hardy21 (7/8/2014)

---

The clustered index has an advantage over all other indexes: since it always includes all columns, is always covering. Therefore queries that can leverage the clustered index...

I hope it is not Live system as you have not mentioned about it.

You need to drop primary key & add it again with CLUSTERED clause as below

ALTER TABLE mappingTable...

Nice One.

I did quick search for COMPUTE. 😉

Hany Helmy (7/5/2014)

---

The 1st query results a cartesian product (6 rows) & only 1 answer starts with 6 rows, so no need to continue reading. This could have been more...