Sean,

They're migrating to a new SQL instance, so there's going to be a new copy anyway. They can do the RTRIM on the way over, so to speak....

After looking at the Books Online entry for NTILE, it's expecting an "integer expression", and it does allow you to access fields that exist in the PARTITION BY expression, but...

funkseo (12/11/2012)

---

I modified as following and I think it's little bit changed. I removed tep tables and use built-in paging.

ALTER PROCEDURE [dbo].[spGetSiteListFromTagPager]

@Tag nvarchar(64),

@page int = 0

AS

DECLARE @TagID int

SET @TagID =...

Jason-299789 (12/11/2012)

---

sgmunson (12/11/2012)

---

Just adding the Description field to the index on SiteID would probably help quite a bit, although at up to 2K per row, the size of that index...

I think you've got the right ideas. I'd create the table on the new server, based on information you can gather from your existing table, such as selecting...

I'll assume you have a case-insensitive collation for your instance of SQL Server. How about something like this:

CREATE TABLE #TABLE1 (

ID INT NOT NULL PRIMARY KEY CLUSTERED,

COL1 varchar(6),

COL2...

This isn't the right forum for this question, but I think I know why. In your code, you assign a value to the zero subscripted array element, then...

Just adding the Description field to the index on SiteID would probably help quite a bit, although at up to 2K per row, the size of that index would be...

Then perhaps the larger concern is just the overall processing time to perform the task. If the migration is an ALL ABOARD scenario (meaning all the data, all...

Don't forget to adjust for spanning a day, as you'll either have to add extra records to fit it into this paradigm, or you'll need to adjust the queries to...

Just splitting the table doesn't necessarily make things faster. The problem might be what to use as criteria to do the split. If, after all, you...

Figures, that you'd need to span dates. I have some code that works for data that's date unique, but perhaps you can expand the time table involved once...

That's what I thought you might want. Now the next question. Is there any chance that a single record will span dates, such as a 3rd...

I'm wondering if your SUBSTRING function is causing performance grief. How many bytes is the Description field? Is that field contained in the index? If...

FYI, had to edit my last post (before this one) twice - please be sure to check it again...