So after you run a log backup, there is no extra free space within the log, at all?

If your transaction log continues to grow after a log backup, it sounds like your transactions are in an uncommitted state. You should see committed transactions cleared from the log...

Not to argue, but since R2 is a basically just a really big service pack, I'd suggest just leaving things alone. I think R2 can fit right into the basic...

I'm running a system that has millions of rows from about eight years of data. It's based on inserts only. It runs fine. The issue is not the amount of...

Not really. I've been posting about it on my blog for the last two years. Our project is... well, we'll see how it turns out. At the moment, I don't...

PaulB-TheOneAndOnly (5/28/2010)

---

"Data Warehouse" is...

I would argue that while all three compile and run, none of them is "correct." If they were correct, then so would this be, and you know it's not:

SELECTmycolumnFROM MyTable;

SELECTmycolumn...

Greg Edwards-268690 (5/28/2010)

---

A data warehouse is not something you install.

Adventure Works has a transactional data base and a data warehouse model.

Exploring this, and possibly some sample labs, might be helpful.

On...

If you've done a regular install of Operations Manager, Reporting Services was installed as a component. It has to be there.

As far as getting at the datawarehouse, again, you have...

The thing is, it depends. In short recompiles are taking up processor time that could be spent elsewhere. But how often and how long is that processor time taken up?...

Suresh Kumar-284278 (5/28/2010)

---

Hi,

Would there be any performance impact deciding Integer or Varchar data type for a primary key?

Also, would it matter more if that column being Indexed (either Clustered...

Sure, that's a fine way to monitor blocking. There are other blocking scripts available in the scripts section of this web site too.

troy2.net (5/27/2010)

---

What i did wrong ?

I searched the google i get article may you guys know exact difference.

if they ask the difference in the sense , What are they...

Fortunately, unlike SQL Server 6.5, every version of SQL Server since version 7 prevents you from dropping the tempdb (trust me on...

In regards to service packs, you are 100% correct.