Absolutly massive topic. Are you maintaning a solution or creating one?

What type of replication are you going to be working with, transactional \ merge \ snapshot etc etc.

The more...

Are you doing the conversion on the machine you captured the bblg on? If not I have had this error because the perfmon counter did not exist on the...

You can but not natively. You would need to install virtualisation software, something like VMWARE. Then create a virtual windows host server and install SQL on it.

Be carefull using the example above which usese the "detailed" option. As this looks at each leaf node perfromance can be incredibly slow. Changing this to simple whilst...

Not possible as far as I'm aware, you could custom code a log shipping setup to have a read only copy available else where, but this would not be real...

GSquared, I hadn't really considered that as an option, but will have a look thanks for the info

Would rather not say but falls into the general category of Online advertising space.

As mention above use with caution.

It all depends on what your database is used for. The organisation I currently work for read performance is paramount and every attention gets...

This may give you some help the where constraints filters for running, you might not need the jon for categories I had this into filter out replication jobs in another...

Thanks All this gives me a good starting point, I'll need to look into this app further as at a glance it looks like it mainly focuses on the Disk...

+1 for the Itzik books, the are very good, infact I have several. Like most technical books that are not exactly exciting but the examples are well explained and...

Also have a look at the Standard reports in SSMS, right click on your database and select Reports > Standard Reports > Disk Usage.

Its not perfect but will show you...

Do you mean once the CU has completed you need to either start the services manually or reboot the server after completion for the services to start. Or they...

Have a look at APEX SQL and Lumigen. They do offer change tracking but not sure if they capture the actual command. The other option is server side...

Looking at your query I am a little confused why you are joining the fulltext search (CONTAINSTABLE) back onto the source table.

Why not just do

SELECT [MashupMetaInfo_Id], MashupMetaInfo_Title, MashupMetaInfo_Tag,...