I hope society never advances to the point where an understanding of relational set theory by the average person is required just to get by; most of our parents barely...

Whenever someone requests the creation of a new report, and the specifications don't seem clear or feasible (for example 50 columns fit upon an 11' landscape page), then I'll ask...

SKYBVI (9/17/2010)

---

@ eric

Ya, true , you have to give them a login and permission too.

About the refresh page, there is a option in connection properties,

refresh after __ minutes and also

refresh...

SKYBVI (9/17/2010)

---

Go to excel --> data

data -->other sources

-->sql server

-->new connection

write t sql script there

execute, the excel would be filled with the result

of the t sql specified..

no use of...

If users suddenly report that the database application is unresponsive, and you're looking for a first response script to tell you stuff like what connections are active, what processes are...

Most Oracle developers love cursors. I mean, it's so obvious they're in love. If you read an Oracle PL/SQL developer guide, it will be full of sappy love poetry dedicated...

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