The problem I was having is that I wanted to give a user CONTROL permissions on only one schema of the database. The client software will not allow a...

MCTS / MCTIP exams are available for SQL Server Business Intelligence and Developer roles. Be sure to read the Audience Profile to see if it matches your expectations.

BI

http://www.microsoft.com/learning/career/en/us/jobs/bi-dev.aspx

http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-448&locale=en-us

Developer

http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-433&locale=en-us

Virtual labs...

Partitioning, even if limited.

I agree, I like woodworking, music, sudoku and C&C, and electrical/electronics work, as well as data analysis. These seem to be common themes on these posts.

I would probably have started out repairing things. In a small town, in a small shop repairing bikes, cameras, or watches. Then moving to a mid-size town with lots...

Great question and very relevant to concurrency and data integrity issues.

Now close the 2nd SSMS window that the inserts 2 & 3 were executed in and rerun the SELECT from the 1st/create window. You'll notice that it still returns...

http://msdn.microsoft.com/en-us/library/ms189292.aspx#BKMK_persisted

'You can create an index on a computed column that is defined with a deterministic, but imprecise, expression if the column is marked PERSISTED'

--If I wanted to find all those...

Ok Robert, you made me dig into this one deeper. We see the misconceptions about physical vs. logical ordering of pages in a clustered index, but there also seems...

the cost of changing the physical order within a page is not that much; the page is in cache anyway, it is alwayys read and written as a whole,...

It's not surprising that so many people get this wrong. Not much effort is given by authors to fully explain this, perhaps a few don't know either. I...

http://en.wikipedia.org/wiki/RAID

Raid 1 requires a minimum of 2 disks and protects against n-1 disk failures, not a 'single' disk failure, although it would protect against any 'single' disk failure even in...

Thanks Sankar and Hugo for a good question. The performance and NULL handling are interesting and the wording really allowed only 1 realistic answer, knowing that UNIQUE constraint still...

I agree. I'm somewhat new to this site, but poorly worded questions sometimes take more thought to deduce the writer's meaning than just answering or researching the material... :-)...

In the example,

create table a

(

col1 int,

col2 int,

col3 as col1,

)

col3 is technically a computed column, but uses only an extremely low amount of cpu time, especially since it does only a...