ok fair enough, data warehouse. what exactly is a data warehouse and even if we were to do this, we need to get data from live to the warehouse in...

sjimmo

just wondered, did you also replicate DDL as well, as OLTP requirements are different from reporting requirements, so things like indexing, how would you go about doing this ?

Hi gift,

Just wondered how this would be done when you have loads of tables on the database.

How would you track the following:

Inserts

Deletes

Updates

Its fine when the changes coming from the billing...

Are there any gotchas when using this replication model and how about the need to optimise code i.e having indexes on the code, and the index on the publisher might...

Hi,

I see your point in this matter, the situation here is that I cant have reporting users querying the billing database at thesame time, as the reports are not monitored...

Hi

Hardware is pretty beefed up, in terms of storage. there are options local or SAN.

Can you give me options for the 2 types of storage, then it would be far...

true talk here

but sometimes, the Query can look long winded and kind of long, and hence the reason why its been put into a temp table.

So what are the alternatives to usinga temp tables, or is it just to always writing the possible complex query off the tables on the flay all the time.

Thanks Guys

Here is the situation, a temp table is created

data is inserted into the temp table

Sp's are called which use this temp table (sometimes)

On other occasions, data is simply selcted...

Hi Guys,

Here is the problem in simple terms, I cant Bulk insert with windows authentication:

I get the error below:

Msg 4861, Level 16, State 1, Line 1

Cannot bulk load because the...

Ok Guys

I got it, on the options i can get it to show the crow feet etc

Thanks guys

I have used viaio to do it, and what i get is entity boxes with pointer arrows linking one Entity to the other , nothing saying whether its a...

Krishna Potlakayala (4/6/2009)

Dean Jones (4/6/2009)

Krishna Potlakayala (4/6/2009)

Dean Jones (4/6/2009)

You...

Krishna Potlakayala (4/6/2009)

Dean Jones (4/6/2009)

Just to give you guys an update, we are still experiencing other deadlocking problems, I have read that try/catch blocks can help resolve deadlocking problems, is...

Hi

Just to give you guys an update, we are still experiencing other deadlocking problems, I have read that try/catch blocks can help resolve deadlocking problems, is this true.

Also, what else...