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...

xsevensinzx (8/11/2015)

---

I'm facing the same issues right now as we migrate to a new data center and possibly migrate data from SQL Server to a new Hadoop environment.

I find it...

jckfla (8/11/2015)

---

Xavon (8/11/2015)

---

IT needs a more general version of Hofstadter's law. That is why when asked to estimate time, I generally add a 150% pad (100% for issues during...

GilaMonster (8/11/2015)

---

Eric M Russell (8/11/2015)

---

GilaMonster (8/11/2015)

---

Grant Fritchey (8/11/2015)

---

Updating statistics...