What version of windows are you running 32 or 64 bit?

If your running 64 bit windows, then what version of sql are you running 32 or 64 bit?

If you are...

The physical MDF/LDF files contain empty space so the DB does not need to expand the files everytime a record is inserted.

sp_spaceused (SQL 2000/2005/2008)

There are several DMV's for 2005/2008

In 2008...

That's what needs to be done, the application needs to make the decision on what if any data can be truncated. It's very poor design that thry set up...

zuma01 (4/21/2010)

---

Hi,

I have a brand new shiny HP DL380 Server and have 8 x 146GB 15K SAS drives to play with.

What would the best way to configure these for...

mw112009 (4/21/2010)

---

We just upgraded to 32 GB ( The max for the server ).

I beleive the operating system needs about 2 GB or RAM.

So how much would you recommend (...

If you had 10 varchar(8000) fields, you could certainly have a problem. The applications really should address this.

Also, it needs to be remembered that a bitmap is created for NULL's

If memory serves me it 2 bytes + 1 additional byte for every eight columns

SQL will grow 50GB.

All transaction will be allowed until the used data hits around the 300GB mark, then SQL will be unable to grow because of the limitations of the...

select *...

The data is still there, you just probably doing a select using grid view. Change to "Results to Text"

Also, ZZZZ + Char(10) + Char(13) + XXXX

will be:

ZZZZ

XXXX

just use char(13),...

Use SQL 2008 and use TDE.

But since you have settled to 2005, use a third party tool to encrypt it.

rames.net (4/9/2010)

---

Seems to be a silly question but really the answer requires for me.

I have a small doubt, Generally when I got alert on tempdb log file size 75 %...

Actually, that's probably...

Let SQL make the decision. If you dedicate 4/4 and the first instance is using 100% (hence processor queueing) and the second instance is using 5%, you have available...

I may not fully understand your question, but I'll try to answer.

On a SQL 2008 cluster, every instance of SQL can be a default instance. That's because each cluster...