Bob Cullen-434885 (1/6/2015)

---

Great question! Like the previous poster, I also have the potential to use this scenario, as we are keeping way too many records in our "live" tables, but...

patricklambin (12/30/2014)

---

As I have installed only SQL Server 2012 and 2014 instances , I am obtaining only the following message

Warning! The maximum key length is 900 bytes. The index 'PK__QoTD__2CB664DD844B62FA'...

I googled "Msg 2714" and answered correctly.

Another solution is adding a xml column to the PlayList table and add the execution order there. So, it's just ONE update on ONE column.

natalie.ignatieva (12/21/2014)

---

This is a great solution, linked list idea adds complexity though. You can easily change the way you rank your songs and make Position column as float. Then you...

I disagree! JOINS are different than IN or EXISTS in the WHERE clause.

JOINS multiply the number of...

Extremely easy!

The answer is in the title!

😀

Bello!

Extremely easy!

Thanks!

ROWCOUNT_BIG() differs from @@rowcount only from the type.

So, ROWCOUNT_BIG() is the correct answer. All other functions may be followed by the OVER clause.

One solution may be this one:

use tempdb

execute (

'

use AnotherDB

declare @a as a

insert @a values(1),(2),(3)

exec z @a

')

or using sp_executesql.

Sql2005 never installed!

Koen Verbeeck (10/29/2014)

---

Louis Hillebrand (10/29/2014)

---

With DATALENGTH you can also use a space as the separator,...

+1

Very interesting!

Thx!