I use the below approach in my company , its worked for me so far and is actually something carried over from my days as a BI developer

* How do...

What kind of replication , can you share the logs?

will need a lot more info before giving an answer , got any detailed error logs from event viewer? how many connections ? any changes made to the system?

just noticed most spam is in SQL Server 2008 - General forum , might help isolate the problem.

BUMPity BUMP BUMP , still no data from ?

For what its worth there has been a lot of positive feedback for the scripts and video posted on linkedin.

actually in the second case there will be an implicit conversion which can be demonstrated with the below code.

create table #tmp

( id int ,

data varchar(10)

)

insert into #tmp

select 1...

The approach of fetching data that might not be needed currently is very common almost to the point of being an industry standard. I personally followed this approach for almost...

EDIT :- BUMP UP three days on still no data from any other tests.

Report level permissions within SSRS are in the format domain\user unless you have implement custom authentication.

In this case the value in the table should match the same format or atleast...

Yeah , if the end user is willing to agree to the cost it shouldn't matter.

Cluster wont enable the trigger since the database in its exact state is being moved from active to passive. Also with regard to backups I am not sure if the...

This entire query uses just the snapshot isolation, The transaction would come into play only when there was any DML DDL in the query , since the query is performing...

Kirsten : not sure if the flexibility afforded by bringing in columns that one day might be useful offsets the storage and performance overhead of all the rows and columns...

Kirsten : not sure if the flexibility afforded by bringing in columns that one day might be useful offsets the storage and performance overhead of all the rows and columns...

I agree, people use what little they know to create convoluted solutions to simple everyday problem.

I just imagine that somewhere there is a dot net guy on a forum asking...