GilaMonster (3/5/2012)

---

Though since this is the SQL 2000 forum, it needs mentioning that...

If you're in some...

mikemartineac (3/4/2012)

---

Hello,

In a stored procedure, I have a view as my data source. Unfortunately, views restrict the use of parameters. In my case, I need to get a value into...

Perry Whittle (3/4/2012)

---

kilkenny (2/27/2012)

---

My company has been getting a lot of requests from our clients to put into place more stringent security practices. I just received the word from...

agustingarzon (2/29/2012)

---

We are going to develop a project where clients will be able to Create their own SQL tables and fields.

The idea is to give the client the possibility...

Databases have a much smaller surface area for security breaches than do Web applications. For a database, you're basically concerned with how accounts, role membership, or object permissions have changed,...

I ran across a piece that surveyed some salaries and it shows that people working with cloud platforms are commanding higher salaries, even when the underlying technologies are the same....

SQLRNNR (2/28/2012)

---

I am curious to see more of how Hadoop will play in the MS BI stack with big data. Is it more of a fad, or does it...

GilaMonster (2/28/2012)

---

On 2008 both select into and insert ... select can be minimally logged, insert... select requires that the table is empty to start and a tablock hint specified for...

rvasanth (2/26/2012)

---

Hi,

I am using SQL Server 2008 R2.

I am having an table with 10M records (around 40 fields). If i fetch 1M records with simple...

Your supervisor at work should really be the one providing you with guidance about what BI tools you need to learn. Other than padding your resume, there is no point...

Several times a year, I'll take a weekend sabbatical. I'll immerse myself in some project that stretches the scope of my experience, like rennovate the bathroom or replace the water...

"Where traditional databases hit their limits, Hadoop starts to emerge as a much better fit for solving unique analytics challenges," Lockner says. "Because data can be incorporated from multiple sources...

Have you traced the SP:Recompile event? If so, then is there a correlation between an increase in recompiles to some activity in the database, like following the reload of tables?

What I typically do is execute a pass-through style query on the remote server using EXEC ('..') AT REMOVE_SERVER syntax and output the result into a temp table, which I...