|
|
Search
You searched for the word(s):
Showing page 7 of 39 (389 total posts)
< 1 second(s)
-
cred ca asta e si cazul meu:
http://www.sql-server-performance.com/articles/per/advanced_sql_locking_p1.aspx
dar nu vad si solutia :)
alex.
-
La Index properties am urmatoarele pe iStatusCode
Page fullness 79%
Total fragmentation 0%
bifa pe: automaticaly recompute statistics
use row locks when accesing the index
use page locks when accesing the index
use index
fara bifa la: fill factor
multumesc,
alex.
-
da, apare in sys.dm_db_index_usage_stats
/*
CREATE FUNCTION INDEX_ID
( @table sysname,
@index_name sysname )
RETURNS int
AS
BEGIN
DECLARE @indid int
SELECT @indid = indid FROM sysindexes
WHERE id = OBJECT_ID(@table) AND name = @index_name
RETURN @indid
END
GO
*/
SELECT dbo.INDEX_ID('tbl1', 'iStatusCode')
select * from ...
-
daca reusesc sa-mi dau seama cum fac rost de deadlock graph...da
astia sunt indexii care exista pe tabela respectiva....nu am cluster
CREATE NONCLUSTERED INDEX [iModifiedDate] ON [dbo].tbl1
(
[ModifiedDate] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
CREATE NONCLUSTERED INDEX ...
-
si mai am si eu 2 intrebari:
1. daca deadlockul apare pt ca pe aceeasi tabela se face in acelasi timp si select si update, credeti ca ajuta cu ceva daca updateul il fac pe tabela si selectul pe tabela il fac printr-un view?
2. la un index care e pe disable cand ii dau enable el face si rebuild (necesita timp)?
multumesc
alex.
-
DataExecutiei vine tdin tbl1
am facut modificarile dar mai am o intrebare,
acest union
(select ExternalCode,MessageCode from tbl2 union all select ExternalCode,MessageCode from tbl2_HIST) b
il folosesc de f multe ori in interiorul procedurii mele (de unde apartine si codul postat anterior) doar ca se schimba clauza de where (se modifica ...
-
aceste 2 proceduri ''se bat cap in cap'':
CREATE PROCEDURE ChangeStatus
@Index bigint,
@StatusCode int,
@MessageResponse varchar(4000)
AS
declare @message varchar(255),@errormessage varchar(255),@return int,@debug int
select @return=0,@message='',@errormessage=''
if not exists (select 1 from tbl1 where MessageCode=@Index) ...
-
salut,
Select b.ExternalCode, a.*, c.CodStare
from tbl1 a,
(select * from tbl2 union select * from tbl2_hist) b,
tbl3 c
where DataExecutiei = @Data
and a.CodMesajOut = b.MessageCode
and c.CodMesajOut = a.CodMesajOut
and c.CodStare = 32
and a.CodMesaj = 8
Order by a.CodMesaj
multumesc.
alex.
-
ai dreptate, am sa-ti urmez sfatul....revin
multumesc
alex.
-
ma refer ca nu stiu exact cum sa aflu toate procedurile/locurile unde ar trebui sa folosesc optiunea asta.
alex.
... 7 ...
|
|
|