You are joining using a LIKE with leading % so this is never going to perform well, also this will mean that the index on

masterdesc may not be...

it may be an issue with Nulls but to avoid guess work

can you post your table structure and some sample data?

Is that the size of the data file, log file or both?

You can try running a backup and compressing it , this may be smaller

Though having a database with...

AS pointed out SQL server only runs on windows, however it is possibly to use a virtual server on your Unix box to install windows and SQL server

If you really want to do this then;

Go into table designer click on where you want the columns to be displayed and then right-click and select insert column and cut-paste...

I would create a SSIS package and then schedule this package as a Job to pull all the data in.

You seem to have a perfectly good natural key in the Student Table of StudentNo, but you have added a column xId to act as the identity column. ...

You have to save the diagram using another application eg paint or excel

Right Click on the diagram pane, then select copy diagram to clipboard, then paste this into...

Okay I think part of the problem is that you are using AND which means that all the columns would have to contain 'Pakistan' where you may want to use...

Can you post some sample data and the expected result ? otherwise it is really just guess work from our part.

I think that skill of writing queries is always going to be important by hand, However for simple CRUD procedures (INSERTS, UPDATES, DELETES) we generate all our...

using variables

WHERE Title LIKE @SearchText + '%'

AND [Description] LIKE @SearchText+ '%'

AND link LIKE @SearchText + '%'

This quite a large and open-ended question that i dont think can be answered correctly in a forum post, but one aspect that in database design that you should get...

Merge replication needs to be able to uniquely identify all rows in the database this is why a GUID is added.

The GUID column that is created has a default value...

What account are you running sql server under? as you will have issues if you are using a LocalSystem account