Rem70Rem (11/18/2014)

---

Hi,

I am debating to where to install SQL on a brand new machine. Should I do the install on the C drive or on a different one?

Half...

dissociative

Lynn Pettis (11/18/2014)

---

GilaMonster (11/18/2014)

---

Lynn Pettis (11/17/2014)

---

Even in single table queries I recommend using table aliases in the FROM clause and using that alias on the columns in the select list....

Sadly the question posed can lead to confusion and a low correct answer rate due to the availability of four correct answers.

The correct answers listed are only for trace flag...

mcinvalek (11/17/2014)

---

I have come across a few tables that are created using dot notation, but not all of the columns are referenced.

Notice the dummy script below. The first col...

You can use dbcc shrinkfile. I would leave 20GB free space inside of the file to allow for various database activities including growth.

The problem with shrinking a file is...

I'd give it to the database server.

Here is a script that will make it very easy to get the space used and to insert it into a table.

http://bit.ly/tablespace

I like that idea.:-D

tapcon

schwizla (11/17/2014)

---

Hi, thanks for your replies. I agree, certified DBA figures will not really paint the accurate picture for the reason you state. But I'm guessing that's the only tangible...

sKreetz! (11/17/2014)

---

Thanks for the quick reply GilaMonster!

Does this also apply to dba's changing their own or other dba permissions to access this information? I would like the dba's to be...

FWIW - "no_infomsgs" does not suppress errors and corruption. It just suppresses the informational messages that most people discard anyway.

As for the agent job, if there is corruption, it...

Jeff Moden (11/17/2014)

---

schwizla (11/17/2014)

---

Hey everyone. Does anyone have any idea roughly how many SQL DBA's there are globally or how they are geographically dispersed? I am thinking that really the...

Putty