Viewing 15 posts - 181 through 195 (of 782 total)
SKYBVI (6/30/2011)
Will the option"Keep index online while reindexing" help solve the deadlock issue?
Regards,
Sushant
sorry, cant perform that operation as its a standard edition not an enterprise edition
Regards,
Sushant
June 30, 2011 at 9:08 am
Will the option
"Keep index online while reindexing" help solve the deadlock issue?
Regards,
Sushant
June 30, 2011 at 8:58 am
SQLRNNR (6/28/2011)
You have something that is running at the same...
June 30, 2011 at 8:54 am
Vicki Peters (6/27/2011)
Perhaps I am missing something, but this seems to handle everything on the database level. I am looking for server-level scripting as well.
you can find the script to...
June 27, 2011 at 2:42 pm
maybe one of the trn files are (not copied/deleted) and so it keep on searching for that file as it cant apply other files...
Reapplying log shipping on tht db...
June 22, 2011 at 9:43 am
ALZDBA (6/21/2011)
for more info on the appy operator have a look at http://www.sqlservercentral.com/articles/APPLY/69953/
Cool...
thxs !!
Regards,
Sushant
June 21, 2011 at 1:57 pm
@ alzdba
That was it.
THANKS A LOT !!!
Its little bit difficault to understand but iam trying 🙂
Regards,
Sushant
June 21, 2011 at 11:25 am
ALZDBA (6/18/2011)
alter table x
alter column seqnr bigint identity( yourstartvalue, yourincrementvalue ) ;
Keep in mind, you should no longer insert that column...
June 21, 2011 at 9:43 am
ALZDBA (6/16/2011)
Select ITEMNMBR
, ROW_NUMBER() over (order by (select 1)) * 16384 as SeqNumbr
from IV00101
where ITEMNMBR not...
June 17, 2011 at 8:43 am
Yes, i checked out the seqnumbr values, each value goes on increasing by 16384..
That means I have to check the max value of seqnumbr and then increment it by 16384...
June 16, 2011 at 2:44 pm
ALZDBA (6/11/2011)
The index is on three columns, including sequencenumber, the other two are the same columns a with the PK except itemnumber.
You...
June 14, 2011 at 11:03 am
Don Urquhart (6/10/2011)
SKYBVI (6/10/2011)
Don Urquhart (6/10/2011)
June 10, 2011 at 2:32 pm
@ ALZDBA
USE [RTW]
GO
/****** Object: Index [AK3tcsINVTB00026_AttribAsgn] Script Date: 06/10/2011 16:12:41 ******/
CREATE UNIQUE NONCLUSTERED INDEX [AK3tcsINVTB00026_AttribAsgn] ON [dbo].[tcsINVTB00026_AttribAsgn]
(
[tcsFLST_AttribGroup] ASC,
[tcsFLST_ItemAtrib] ASC,
[SEQNUMBR] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE...
June 10, 2011 at 2:12 pm
Viewing 15 posts - 181 through 195 (of 782 total)