Viewing 15 posts - 1 through 15 (of 17 total)
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...
October 15, 2012 at 2:53 pm
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.
January 30, 2012 at 6:18 am
Partitioning, even if limited.
April 20, 2011 at 9:39 am
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.
October 29, 2010 at 9:56 am
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...
October 29, 2010 at 6:15 am
Great question and very relevant to concurrency and data integrity issues.
October 11, 2010 at 9:24 am
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...
October 8, 2010 at 6:40 am
'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...
October 7, 2010 at 11:25 am
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...
October 5, 2010 at 10:17 pm
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,...
October 5, 2010 at 9:36 am
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...
October 5, 2010 at 6:31 am
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...
October 2, 2010 at 9:21 pm
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...
October 2, 2010 at 6:33 pm
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... :-)...
October 2, 2010 at 5:26 pm
In the example,
create table a
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...
October 2, 2010 at 4:57 pm