I'm not sure what your trying to find by saying "Which one are we using the most."

Which application using which db is being used the most?

You can, and probably should...

How can you tell your string is getting cut off?

is sql returning an error when you execute.

Please post your code, and someone can point out the error in 2 seconds...

I do not believe there is.

But in general I do not format data out of the database.

Formatting should be the job of the presentation layer.

If you were to format the...

what data type are you using in the table?

and sometimes when using EM the dates show funny,

use Query analyzer to validate your dates

Can you elaborate on sync'd?

Is it the same table definition, with most the same data, just few rows are different?

Each table at each location holds completely different rows? Will you...

Yes there is a reason you canNOT do this.

When log shipping a database is in recovery mode.

When in recoverymode connections can be established for read only purposes, but if...

Err wait, Nevermind. Cant Read

Edit:

If you want to do something like this you are adding a ton of overhead onto the sql server. and if you allow client side sorting...

It looks like your application may be a little more complex than you can explain in a post.

Hence it will be difficult for us to provide you with an answer.

It...

Creating an application role enables you to set security context at 1 point for an application and not for each individual user using the app.

From Books Online

"The security system in...

Is your log full because you are out of disk space, or because your log file is not set to autogrow?

If it is not set to autogrow, then just increase...

That is something you'll have to deal with when you get a large string back from sql.

SqlServer outputs data in 8k chunks. So a new chunk is starting after the...

If you are using T-SQL then your query is not valid.

iif(isEmpty(fieldName), 0, fieldName)

IsEmpty is not a valid function, and IIF is not valid for an if statement

What are you trying...

Here's a link from books online that discusses partitioning

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/optimsql/cm_fedserv_27eb.asp

I don't think that partitioning a table with 1.3 million rows is worth it.

If the table is going to continue to...

You should not connect directly between the mobile devices and the sql server over the internet.

If you did that it would expose sql server to the internet, which is not...

Other than following Remi's normalization advice,

This is how you would do it as is.

Create table #dataTable (caseNo int, Stage1Status int, Stage2Status int, Stage3Status int)

insert into #datatable(CaseNo, Stage1Status, Stage2Status, Stage3Status)

values(1, 2,...