Thanks for the reply...

does the SQL developer edition supports clustering??

I have upgraded many SQL instance of 2008 (not R2) and didn't get any issues..

The main difference between 2008 and 2014 would be it's new In OLTP memory engine...

thanks all for the valuable information,,,

:-):-):-):-):-):-):-):-):-):-):-):-):-):-):-)

Thanks just wanted to confirm as the end users usually complain for slowness when the DB is in FULL mode.

:-):-):-)

Ofcourse, taking a log backup actually truncates the the .ldf and prevents it to grow physically, I would recommend you to create a maintenance plan for the log backup and...

You will have to enter the 'machinename.domain' address of the subscriber in the publisher's host file and then create a Alias of the subscriber under configuration manager (SQL...

The Simplest of all would be to create a link server between the two database servers and then execute the query using the linked servers.

Plz reply if you want to...

right click on the created publication - properties - snapshot - and change the folder from here.

:-):-):-):-):-):-):-)

Regards,

Ashif Shaikh

What type of replication you are going to set up? and is it across domain or both the servers are on the same domain..

Regards,

Ashif Shaikh

I found that it is due to 'Light weight pooling' is enabled, in OLTP memory engine it is asking me to disable.

Please let me know what will be the...

I would recommend to test SQL 2014 before implementing it. No doubt SQL 2014 gives a boost in performance through it's new In memory OLTP engine, however there are certain...

check the processes running in sys processses and the same using 'input buffer' and verify whether the query being run is fully optimized for eg indexes are missing and '*'...

Thanks for the reply, the issue was due to network authority login which we used for sql service and sql agent service during the installation.

we changed it to a...

yes, we already have four instance of sql 2008 enterprise on it and we were installing fifth one (sql 2014 enterprise) with the named instance not the default instance..

hope this...