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

Disk space truely is cheap. Yes, we can get a lot more storage space for our money today, but the I/O speed hasn't kept up at the same pace. So,...

GilaMonster (8/11/2015)

---

Grant Fritchey (8/11/2015)

---

Updating statistics won't change the names...

Alvin Ramard (8/10/2015)

---

GilaMonster (8/10/2015)

---

You can do it, but it is not a good idea. It's liable to cause you problems down the line. Just write one proc for insert, one...