Viewing 13 posts - 1 through 13 (of 13 total)
Yes, with recreating the index I will use the following order
Non-clustered -> primary key -> clustered
So rebuilding of whole table will be performed last.
Thought?
September 14, 2012 at 1:02 am
4 non-clustered, 1 clustered and 1 primary key.
For bulk insert.
September 13, 2012 at 10:43 pm
Thanks for the reply, I found that and managed to locate the files affected. But what is the error behind it? Not seems to be able to find the solution.
April 8, 2010 at 12:08 am
[Code]
select top 100 u58.deal_type_cde , ucb.*
from u58_deal_hist u58
join ucb_exp_hist ucb on u58.deal_id = ucb.deal_id
where ucb.batch_id = 297326
and u58.batch_id = 297325
and ucb.deal_id like 'IMGATD%'
[/code]
There are indexes...
March 25, 2009 at 12:04 am
This is what I get when trying to run the query
Msg 240, Level 16, State 1, Line 6
Types don't match between the anchor and the recursive part in column "String"...
August 26, 2008 at 12:40 am
Hi All
The query return in a table however I would like to return in 1 single row. eg "Project Lead;Developers"
Thanks
August 25, 2008 at 6:29 pm
Yes, I am trying to stimulate a dead lock.
Thanks I think I have enough info.
Derek
July 18, 2008 at 12:14 am
Thanks for the solution. It works perfectly. What is the function over (Partition BY) does? What is the different between Over(Partition By) and Over(Order by).
October 25, 2007 at 11:07 pm
As a high level overview, what you'll be wanting to do s look at the exec plan, find the high percentage cost operations and see what you can do to...
October 18, 2007 at 5:45 pm
Define performance? If you're concerned with the time that the query takes, use statistics time. If you're concerned wiht the amount of IO, use statistics read. If you're concerned with...
October 18, 2007 at 1:06 am
Viewing 13 posts - 1 through 13 (of 13 total)