The only practical way to report off of 5 million rows is to pull it into an OLAP cube, preferably on a different server or their local PC, and then...

There are a narrow range of data modeling scenarios where a...

Eric Russell 13013 (9/16/2010)

---

A BigInt datatype has max value of 9,223,372,036,854,775,807, so it's large enough to allow several tables to reserve an identity seed of several billion. If you're planning...

A BigInt datatype has max value of 9,223,372,036,854,775,807, so it's large enough to allow several tables to reserve an identity seed of several billion. If you're planning to impelment a...

WayneS (9/15/2010)

---

Eric Russell 13013 (9/15/2010)

---

The problem with social engineering and digital authentication is that it involves information that can be easily forged. If I call someone up and say I'm...

krowley (9/15/2010)

---

Eric Russell 13013 (9/15/2010)

---

The problem with social engineering and digital authentication is that it involves information that can be easily forged. If I call someone up and say I'm...

The problem with social engineering and digital authentication is that it involves information that can be easily forged. If I call someone up and say I'm from the bank, they...

Based on the cases I've read about, it seems that only a small pecentage of data breaches are the result of someone hacking the actual database server. From what I...

Using SQL Server's backup process, you can do what's called a "partial restore", which restores the primary filegroup and whatever secondary filegroups you choose. How useful that would be in...

I think that if an organization generally pays contractors to do stuff like fixing their plumbing, mowing the lawn, or book keeping, then they can find a way to fund...

SQL Server's default transaction isolation level is READ COMMITTED, and I'd suggest leaving it as is. Also, run the update query through Database Tuning Advisor and see what it reccomends.

steveb. (9/14/2010)

---

torpkev (9/14/2010)

---

My biggest annoyance with sa - quite outside of this discussion - is those people who use sa to connect to the database because they don't know...

I use the following script to grant permission to a "power user" role; which isn't an administrator the database but a user who occasionally needs to do things like troubleshoot...

JunkMail Victim (9/1/2006)

---

I've found them to concentrate on the compiled executables of the client applications, but not think much about the unencrypted business logic that resides in stored procedures and...

What do you mean by ReadOnly columns?