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

I agree that it's best to map local logins to an account on the remote server, rather than have all logins access the linked server using a default security context....

Peter Maloof (2/24/2012)

---

Eric:

Eric M Russell (2/24/2012)

---

For the past several years, I find myself walking up the theatre, reviewing the movie lineup, and then most of the time I'll just walk...

"Dolphin Tale" is one of the other hanful of movies from 2011, and it was one that me and the family enjoyed together.

For TV series, "Spartacus: Gods of the...

For the past several years, I find myself walking up the theatre, reviewing the movie lineup, and then most of the time I'll just walk away disinterested. The same goes...

Samuel Vella (2/8/2012)

---

One thing I would love to be able to do in SQL is this:

(Simple example)

select

A,

...

jyoti.patel (2/20/2012)

---

We would like to automate a way to restart SQL at 5:30AM local time every morning. We have an application that hangs until the SQL service is restarted. Cau...

dbapt605 (2/17/2012)

---

Is it possible to insert a large number of records into a fairly big table, and not have SQL Server lock the entire table against updates or other smaller...