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

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...

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...

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...