I have a deadlock graph captured from Profiler. It shows two different SPID's executing the stored procedure sptListingDelete and getting deadlocked....
k. No select top 500 is not what we want to do.
what about IO placement for this table?
the query is coded like this... query tables a,b,c - if 100,000 records found for example, return/exit the sp. (the max is 500 so anything > 500 the...
what is the fastest way to return from a stored procedure if records found are > 500? ?when exists count > 500 return? if < 500, then we get more...
what is the best way to handle a table that gets a ton of select activity from one stored procedure? (indexes, io, etc)
In pre-production environment....(brand new servers) I have setup sql server 2005 transactioanl replication for a database. - Publisher...
sorry, the CI is ListingID, ListingStatusID no NCI's on the Listing table.
part of the sp: FROM dbo.Listing L with (nolock) INNER JOIN #List with (nolock) ON L.ListingID = #List.ListingID INNER JOIN...
i have two tables: Listing Listing_Status I have a search sp that has a parameter: @ListingStatusID. Due to 99% of the records in Listing table...
i had an error earlier on my transactional replication. A primary key insert error. Replication failed. Now the validation check says its out of...
i have 4 subscribers who were all created using IP's. Now Network team here wants to change those boxes IP's. I want to change all 4 subcribers now...
i have a sql server 2005 standard box with a Dev engine and a Tst engine on it for dev, i cannnot see the site settings from within Report Manager...
can somone lay out the high level steps needed from getting raw data, to building a cude, reporting services, etc any online resources explain this...
has to be simulataniously processing here.<br /><br />if my trace had start time data i would be able to confirm. (<img...
further details... select sum(duration) from dbo.TestCasePID90 where objectname = 'sptIndividualAddUpdateFull' --17439795518 micro --17439795.518...
ya. but cannot figure out why this total time is off. ran a trace for 60 minutes total time for all the sptIndividualAddUpdateFull = 290 minutes...
so sp:completed reports what exactly with nested sp calls and triggers? this is my exact case: sptIndividualAddUpdateFull is the main stored...
please explain that cause when i look at profiler i assume these are ALL unique calls
i have a saved trace file thats been loaded into a table - i am concerned about one of the sp's in that trace table so my trace ran for 1 hour the...
Separate names with a comma.
