Sean Lange (8/13/2015)

---

SQLRNNR (8/13/2015)

---

Or a user-defined table type?

Better yet...

A user defined memory optimized table...

Long overdue praise for the lowly tally table. I declare August 33rd as the official Tally Table Appreciation Day.

Grant Fritchey (8/13/2015)

---

Eric M Russell (8/13/2015)

---

SQL Azure should be technically up to the task. However, my understanding is that you get billed based on network transfer fees. How many GB...

Generally speaking:

Table variables have scope limited to what one would expect with other types of variables, and it allow for fixed plans, which is a strong and compelling reason to...

SQL Azure should be technically up to the task. However, my understanding is that you get billed based on network transfer fees. How many GB total of data do you...

Luis Cazares (8/13/2015)

---

Eric M Russell (8/13/2015)

---

Luis Cazares (8/13/2015)

---

Ed Wagner (8/13/2015)

---

Eric M Russell (8/13/2015)

---

But where do you get your tally? There are examples out there; Jeff's is popular. However, it would...

Luis Cazares (8/13/2015)

---

Ed Wagner (8/13/2015)

---

Eric M Russell (8/13/2015)

---

But where do you get your tally? There are examples out there; Jeff's is popular. However, it would be nice if SQL Server...

sumit4bansal (8/5/2015)

---

I have a table with 8 columns, I need to update data in multiple columns on this table, this table contains 1 million records, having single update was taking...

A tally table (or tally set because it's not always a table) is useful for those scenarios where you need to stub in gaps for a resultset. For example, the...

TheSQLGuru (8/12/2015)

---

Eric M Russell (8/12/2015)

---

Where is this...

Where is this feature in SSMS?

It would...

ssk7317 (8/6/2015)

---

I am a Infosec guy and don't know a whole lot of details about Database. But as a part of our infosec lockdown activity, we are giving a shared...

mister.magoo (8/6/2015)

---

You'll be in a big pile of do, because you won't even know who did it - as you want them all using the same ID.

Perhaps you should just...

You can provide business with an equation like the following:

Bytes of Storage =

{? avg orders per day}

X {? avg items per order}

X {? number of days}

X...

Here is something I wrote the other day to grab DB_NAME, LOGIN_NAME, DB_ROLE for all databases on the instance.

if object_id('tempdb..#db_roles') is not null drop table #db_roles;

create table #db_roles

(

primary...