Great question! Staright forward and to the point. Compression is new to SQL Server backup and something we could all use more knowledge about.

Great question Bit Bucket. Concise and to the point with a clear answer. 😎

What makes this even worse is when you use universal source control.

The quickest way to mess up the spaces and tabs in our SQL source is when we extract it...

I have tested this on three seperate servers this morning and the answer should be Yes and NO.

Model is Read-Only = True but all new databases are Read-Only = False.

I...

This is a question I ask during the Interview.

Setting the "serialzation" or "Transaction Level Isolation" are the most common wrong answers.

The right answers are all over this MSDN document.

I like the question.

I don't like the confilicting documentation.

http://msdn.microsoft.com/en-us/library/ms177570.aspx

Same article also mentions that this is a...

We use TFS 2010 lab manager to help out with this. We had to make a seperate Hyper V server environment to support it, but it was worth it....

solomon.jernas (11/25/2011)

---

1) We have two sites Silverton and Port Elizabeth, the data from Silverton needs to be read and reports need to be generated...

Stan Kulp-439977 (11/29/2011)

---

My goal was to create an introduction to writing functional script tasks while keeping it as simple as possible. Using a script task as a data transformation component...

Great article and nice set of Script example code.

I have a question about it though.

We do a lot of similar ETL updates to row records during import by using SSIS...

Great question Dwayne!

Dwayne Dibley (11/18/2011)

---

Hi all

Thanks for the feedback on the question. The results as they stand make for some interesting reading. Only 31% got the answer correct. So this...

GPO (11/17/2011)

---

There are good reasons to avoid using BETWEEN when comparing two datetimes. Particularly in the example the answer uses. You should be using the various symbols for GREATER THAN...

Hugo Kornelis (11/16/2011)

---

If I had the possibility to mark...

Hugo Kornelis (11/16/2011)

---

My question is: would you like a few more questions of this kind, or would submitting the rest of the questions I was planning expose me to death...

Jeff. That is very...