Viewing 15 posts - 856 through 870 (of 8,415 total)
jcb (1/31/2012)
I need to ask...Changing the column from varchar(245) to varchar(max) is an option?
VARCHAR(something <= 8000) would be better. MAX types prevent online index builds (before SQL Server 2012...
January 31, 2012 at 11:24 am
GilaMonster (1/31/2012)
jcb (1/31/2012)
Can You rely on a trigger to safe truncate the data to the column?No, because types are checked before triggers fire.
Yes, if you use a view 😉 ...
CREATE...
January 31, 2012 at 11:21 am
b5535084 (1/31/2012)
January 31, 2012 at 11:01 am
peter-757102 (1/31/2012)
I often wished for a ransomization (on/off) setting, that forces deliberately anti-ordered results and expression execution order to quickly identify hidden false assumptions in queries.
Yeah. I doubt we...
January 31, 2012 at 10:03 am
peter-757102 (1/31/2012)
I did check some on the net myself (long live Google)....and this is what I get from it:
I guess another consideration might be what to use as the clustering...
January 31, 2012 at 10:02 am
b5535084 (1/31/2012)
where rn=1 (so it would be included)
and removed the top 1, so I now looks like:
select nco.*, nci.ORDER_ITEM_ID o2
From...
January 31, 2012 at 10:00 am
peter-757102 (1/31/2012)
Can you explain (or have a link that does a good job at it), why one would want to go that route over clustered storage in that scenario?
Not offhand,...
January 31, 2012 at 9:32 am
b5535084 (1/31/2012)
January 31, 2012 at 9:31 am
peter-757102 (1/31/2012)
I took a look at the plans and what confused me is the apparent lack of clustered indexes (i noticed table scans instead of clustered index scans)!
The table names...
January 31, 2012 at 8:40 am
If those two queries produce identical results, it is just luck. Your original queries had (rn = 1) ordered by order_item_id ascending for the JOIN option (which would give...
January 31, 2012 at 7:58 am
Koen Verbeeck (1/31/2012)
January 31, 2012 at 7:09 am
The criticism of the question's wording is just a little on the harsh side for my taste. After all, this is a one-point question with a 50/50 choice. ...
January 31, 2012 at 5:29 am
Hugo Kornelis (1/31/2012)
There are good reasons why the only way to reference another table is through a workaround that's complicated enough to fool SQL Server.
I wish this feature did not...
January 31, 2012 at 5:15 am
karthikaug18 (1/31/2012)
so if i am doing select * from (indexed_view) does it touches the base tables to retrieve the data.?
It might do. In Developer and Enterprise Edition the optimizer...
January 31, 2012 at 4:39 am
Divine Flame (1/31/2012)
Get the book SQL Server Execution Plans by Grant Fritchey to learn about execution plans (available on this same site in books section).
The free PDF is here: http://www.red-gate.com/our-company/about/book-store/assets/sql-server-execution-plans.pdf
I...
January 31, 2012 at 4:35 am
Viewing 15 posts - 856 through 870 (of 8,415 total)