sreddy (4/13/2009)

find the following soln...

SELECT [ID]

,[Title]

,[fname]

,[lastname]

,[Company]...

Well,

It go's like this, i was just looking for a example of how to do this pice of work, i learnt myself how to partion the table and put together...

Any quick examples, for the above one.

i have shown how i am creating a Primary and Dependent tables.

so how do you want to structure the proc. Can a proc be...

Thanks Paul,

So you say to have a sliding window, but how do i make sure about the data in the dendent tables also get archived in the same way.

The sliding...

Hi,

Thank you for your response, we want the partition in such a way that all the dependent records are also partitioned correctly.

and we have a live partition where data will...

I am sure that if no outsourcing then the aftershocks will be rightly felt in all parts of the world.

May be a poor lad in this case but Not a...

1) Look at the column is it a computed column.

2) Take a look at the system time on the DB Server.

3) Make sure you use always a GetUTCDate() rather than...

What is the code you are looking at?

i.e.,

what kind of update or inserts happening what is the sequence in which it is happening.

Please provide the information as descriptively as...

Try this it may be simple.

Select Stuff (

SELECT ','...

Hi,

Sorry for the late reply, I dont know if this helps you but just look at the logs produced by your appliction. and also the sql server logs if you...

Hai,

That looks great but it gives me all nulls if the column doesnot have alternative identifirer for the product.

how do i handle that.

Very good trick. but does that realy work...

i am sorry to bother but is there an way of cubing, MDX to resove it.

Its realy good stuff digging up Steve,

can you also say about the hotspots and how they have come over it in sql server 2005 from sqlserver 7.

what can we find...