Firewall rules open and correct?

Named instance or default instance?

Static ports or dynamic ports?

SQL Browser Service running?

Can you telnet to the server over the correct port?

Can you connect via IP instead...

yes I saw the execution plan, should upload them as SQLPLAN files as we can then open then in SSMS and naviagte the objects and see the stats, but as...

Thats the whole point.

%...% will cause a table scan no matter what indexes you have on it

FTS will do the seek and then a match on the FTI

Well the full text is faster on time, yes it reads more pages from memory than the like, but doesnt do a scan which the like does, so full text...

Well the second one will use a scan as its not SARG-able due to it being '%...%'

What is the output with statistics time switched on and also what do the...

Again to your previous post. Dumps are classed as cheating, please detail the email address you have used to register with Prometric so that we can email your details...

SELECT * FROM table WHERE info IS NULL

A NULL value can not be used in an equals operation as SQL doesnt know if NULL is < > or = to...

Yeah its the smaller sibling of AX but based on the same principles so yes the two do go hand in hand.

GilaMonster

---

Braindumps are cheating. They are actual questions taken from the exams in violation of the NDA that all exam takers must accept. Using or distributing braindumps can result in your...

http://www.microsoft.com/en-gb/download/details.aspx?id=13647

Troubleshooting Dynamics

Two links I have used in the past on configuring the DB server for Dynamics, and also trouble shooting Dynamics.

What is the application which the database serves? Going to go out on a wild guess and say Dynamics?

A...

So you have already installed SQL?

You want to add a new instance of SQL called SQLEXPRESS or do you want your existing install to be called a named instance of...

Add in the CHAR(39) keyword...

The cost threshold must have breached the value which you have it set at. Typically this is set to 5 by default, so top 8000 must have a cost...