Select signal_wait_time_ms=sum(signal_wait_time_ms)

,'%signal (cpu) waits' = cast(100.0 * sum(signal_wait_time_ms) / sum (wait_time_ms) as numeric(20,2))

...

http://sqlism.blogspot.com/

Help Please

Thanks for the reply!

Can you please explain this in more details, i use Execution utility for running this packages. so how can i differentiate 2012 and 2008R2 SSIS.

So you conclude...

Help Please!

Thanks for the reply

I mean to say any other driver other than C drive. I specified E drive as example. sorry for the confusion. So can someone conclude that it...

Thanks for the reply, so u suggest to seperate sql

Binaries from

OS binaries ?

My question is , is this is the best practice to change root directory from default location in...

My Reporting databases dont have any reports, initially they are just installed for future purpose. But they are accidentally deleted. So, i guess now there are no issues in...

Got it.. Thanks a lot for your time..

Thanks for the reply, can you please let me know the path for these config files. I am not sure abt encryption keys here, also, what are the procedures i...

http://sqlism.blogspot.com/2012/08/ssis-package-in-sql-server-agent-job.html

Got the solution.

Take backup and restore on second node only after creating publication in first node. Actually i restored the database before creating the publication on first node.

http://sqlism.blogspot.com/2013/01/peer-to-peer-transactional-replication.html

Thanks everyone for...

Thanks Steve,

This helped me 🙂

The reason for chnging the port number is security best practices, for connecting to the instance thru SSMS to the server we should reveal port number to all the...

Sean,

Thanks for the reply,

R u sure that we can allocate diiferent port number to default instance. please let me know. This is something urgent.

Thanks a ton!