Viewing 15 posts - 121 through 135 (of 521 total)
Hm, am I the only one who thinks the given answer is false?
According to it, there will be a "type conversion". But instead there is only a "type conversion error"....
November 2, 2010 at 2:00 am
<nitpick mode="on" />
I would issue a simple ALTER DATABASE db2 SET ENABLE_BROKER, since noone said that the broker service had already been enabled in db1
<nitpick mode="off" />
Ok, common sense told...
October 26, 2010 at 2:40 am
Hugo Kornelis (10/12/2010)
The short explanation is that, within a [delimited identifier], you have to double the ] to get a single ] character.
Ah, that makes sense... Well, it doesn't completely,...
October 12, 2010 at 2:20 am
Got it wrong - did not see the final closing square bracket.
But what "stuns" me is the fact that SQL Server does not deal correctly with this object name.
Looks...
October 12, 2010 at 1:04 am
No Problem Hugo. I was not that clear in my first post, so I can see where you were coming from. And that just emphasizes how important it is to...
October 5, 2010 at 4:57 am
Hi Hugo,
In your explanation you have switched from order of rows accross pages to order of pages.
I have not meant that a physical order is imposed on the pages. I...
October 5, 2010 at 3:02 am
GilaMonster (10/5/2010)
True, but that new page is not necessarily physically located after the existing page.
Agreed. The rows are physically ordered within the "page universe"*, but not the pages themselves
*and...
October 5, 2010 at 2:31 am
I am not satisfied with the answer, indeed I find it very misleading.
As data is inserted or the clustering key values are updated, SQL Server only preserves logical ordering of...
October 5, 2010 at 1:55 am
Hi Steve,
Steve Eckhart (9/30/2010)
Actually, if you read carefully, an index on a computed column CAN include multiple rows and columns from other tables.
Can you give an example of multiple...
September 30, 2010 at 7:50 am
The first answer (All functions that are referenced by the expression are deterministic and precise.) is incorrect as well. As long as the column is persisted, imprecise functions can be...
September 30, 2010 at 1:43 am
UMG Developer (9/23/2010)
September 24, 2010 at 3:07 am
You already told us, you stole from your own blog 😛
But as an honest guess, I think you were just exploring SQL Server, and eventually found the DMV for the...
September 16, 2010 at 8:11 am
This is really great stuff... As already mentioned a few times by others, 5 stars aint enough for this series...
Edit: The link back to the article from the forum actually...
September 16, 2010 at 2:14 am
Oleg Netchaev (9/3/2010)
Hugo Kornelis (9/3/2010)
You could argue that this is simply copying pages from one place to another. What is on the page is irrelevant. The internal...
September 7, 2010 at 11:08 pm
Viewing 15 posts - 121 through 135 (of 521 total)