Larry Kruse (6/23/2010)

---

The query to examine distribution is:

SELECT

(ABS( USER_ID ) % 10) AS PartNo, COUNT(*) As UserCount

FROM Users

GROUP BY ABS( User_ID )%10

ORDER BY ABS( User_ID )%10

The results are:

PartNoUserCount

0206665

1206586

2206548

3206496

4206463

5206367

6206660

7206383

8206507

9206529

CREATE PARTITION...

Instead of trying to insert into the table variable inside the dynamic...

This is a scope problem.The table variable declared is outside the scope of the dynamic SQL.

Either declare the table variable inside the dynamic SQL or if functionality requires it outside,

use...

yes u r right 🙂

craig 84462 (3/21/2010)

---

HI there,

While@@FETCH_STATUS=0

if @Statisticvalue <=100

Begin

Try giving a begin after the while.

Since the volume of data is enormous..try partitioning the table as date based and further the records can be purged based on partitions.The other option is to delete the records...

Try using Merge statement

Hi

I am trying to understand your scenario...

Why do you require the newid() to be printed in the trigger?

Hi

Try making use of the output clause.

Eg:

create table tab (i uniqueidentifier,j int)

declare @tab table (i uniqueidentifier,j int)

insert into tab

output inserted.i ,inserted.j into @tab

values(NEWID(),1)

select...

Ray K (12/3/2009)

---

Not sure whether or not this is applicable, but this sounds similar to the scenario presented in an article I read here a few weeks ago.

Here's the link...

Thanks for the prompt response :-).

But I require occurrences of the columns in all tables in all sps for proposing indexes.

So require to consider the alias names used in the...

Higher Level may not be a solution as per the functionallity .

whats your solution?Can you post.I have similar such problem.Will check whether your solution can be used.

There are two types of errors that will not be handled by TRY…CATCH if the error occurs in the same execution level as the TRY…CATCH construct:

Compile errors, such as syntax...

Ya i understand u require the values of the columns.The below script will do the same

Modify this script to suit your need and to meet the performance.The previous post will...