Viewing 15 posts - 1,411 through 1,425 (of 18,926 total)
While we debug this, you can always find the slow queries and try to tune them
November 10, 2011 at 9:39 am
Did you rebuild all indexes and update all stats with fullscan during the upgrade?
November 10, 2011 at 9:38 am
Is this a 1 time occurance?
If so rewritting this might be very counter-productive.
On such huge code I usually put a couple days aside for a rewrite... so unless you're...
November 10, 2011 at 9:35 am
Reformatted for sanity!
USE [yba]
GO
/****** Object: Table [dbo].[ProspectsInCampaigns] Script Date: 11/10/2011 17:23:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ProspectsInCampaigns]
(
[prospectid] [int] NOT NULL
, [campaignid] [int] NOT NULL
, [result] [int] NOT...
November 10, 2011 at 9:33 am
WayneS (11/10/2011)
Ninja's_RGR'us (11/10/2011)
November 10, 2011 at 9:24 am
Is one of the servers or dbs in case sensitive mode?
November 10, 2011 at 9:23 am
Iulian -207023 (11/10/2011)
another table that updates every hour and there is a query that...
November 10, 2011 at 9:22 am
Brandie Tarvin (11/10/2011)
Would you actually be using a WHERE clause IRL?Or does the WHERE clause exist only to limit your row values at the moment?
No where clause in the final...
November 10, 2011 at 9:06 am
Brandie Tarvin (11/10/2011)
What exactly is the data supposed to be? Product data? What do the dates mean for the data? (I'm looking for the English explanation here...
November 10, 2011 at 9:04 am
Iulian -207023 (11/10/2011)
I think it depend on how often the data does change. If it is updated, let's say, once a day I would see no issue in using With(NoLock).Regards,
Iulian
Then...
November 10, 2011 at 9:00 am
@dev, here's something you might love if you used =>
November 10, 2011 at 8:50 am
Dev @ +91 973 913 6683 (11/10/2011)
GilaMonster (11/10/2011)
Minnesota - Viking (11/10/2011)
my Generate...
November 10, 2011 at 8:44 am
GSquared (11/10/2011)
Try moving the Where clause inside the CTE..
That fixes it too.
GSquared (11/10/2011)
November 10, 2011 at 8:40 am
Chad Crawford (11/10/2011)
Ninja's_RGR'us (11/10/2011)
Father in hospital, house flooded. Need some R&R atm.Best wishes and prayers for a speedy and good outcome.
tx.
November 10, 2011 at 8:31 am
Google decrypt sql server. There's plenty of ways to do that.
Just make sure it's legal for you (vendor contracts).
November 10, 2011 at 8:27 am
Viewing 15 posts - 1,411 through 1,425 (of 18,926 total)