There is an "unclassified" program that does it with source code included.

http://earth-info.nga.mil/GandG/geotrans/

jg

The message you got back is a general syntax error.  '@user' is not a valid user name, so the parser rejected your batch.  You must specify the user in...

Adding RAM will definitely improve the PLE, as long as SQL server can address it.  Depending on the OS and SQL version, you may face certain hard limits.  Now the...

Adam,

If you used the standard showcontig/indexdefrag substantially similar to the one from Microsoft's site.  (I forget where exactly) then you probably don't have an index org problem.  You might be...

I believe that when you use Trusted_Connection=yes, you are not using SQL server authentication.  Try removing that from the connection string.  Also use 'UID=' instead of 'User ID=' and 'PWD='...

Send everyone to anger management classes.  That would be a good first step.

If you are talking about GPS, let me know. I am developing a mobile application that uses real-time GPS data, and I have all of the data capture stuff up...

Hello,

I'm not sure if the instructions that you have for the system databases are correct, but they look right.  If they came from a trusted source, then I would believe that...

These should be posted in "General Complaints".

I've run into that kind of problem before.  Sometimes, the answer is to break up the query into smaller parts, storing intermediate results into a #Table or @Table variable.

There is...

I think some more and I think this....

Try getting the rowcount estimate from this select:

Select * from Person where

[Person].[lastname]='JONES'

AND [Person].[firstname] >= 'WALTEQþ'

AND [Person].[firstname] < 'WALTES'

That will tell you...

I have a guess.  It would appear that the second query is planned to have a predicate (see the 'WHERE'?) on the seek, which makes it seem more selective to the...

Don't take bad advice from strangers.

I got bored, so I'm showing a C# example.  This changes the password for the first connection object in a DTS package called DumbTestPackage.

static...

The very first step is to sign up on sqlservercentral.com, which you already did.

jg