I have a deadlock graph captured from Profiler.
It shows two different SPID's executing the stored procedure sptListingDelete and getting deadlocked....
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.
i have two tables:
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
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...
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
anyone have any ideas how to make this run faster?
CREATE PROCEDURE dbo.spaSynchCLSearch
SET NOCOUNT ON
-- clear data
i installed this, now trying to confirm....how?
tried a the usual @@versions, etc
we have a busy online listing/property search application
major functions of the website are:
is it possible to capture the calling object that caused a trigger to fire?
ALTER procedure [dbo].[sptIndividualLastUpdateRefresh]...
i have one publisher and 4 subscribers setup.
2 of my subscribers are down due to network issues.
there are transactions going all the time.
i wanna be able to click a button and my STG envionment is fully refreshed from my TST environment. (the whole database)
i tried the sql server...
is there anyway to lable(for example) lookup tables in my sql server 2005 database?
i want to be able to query all my lookup tables and report back...
We have a real estate site that gets over 15 million searches a day.
We now have a company called FAST http://www.fastsearch.com/) that is after us...
i have a database that needs to be moved because of hardware issues.
the current db is on a sql server 7.0 box that has a code page of CP 1252.
sql server 2000
is there a limit on how much sql server itself can transfer from box to box?
is sql server limited by on I/O capacity/speed...
Separate names with a comma.