Me too. The computed column will have some overhead to maintain the index and such so Lynn's way could be faster, I've no idea as I don't have a...

The original syntax didn't work? What error did it give? Have a look at Jeff's excellent article on fixing updates here. http://www.sqlservercentral.com/articles/Performance+Tuning/62278/

Sure, that could be a good starting point. You will just need to keep an eye on it. Once it gets to a place where it doesn't seem...

So you were able to log in via QA and now you can't? No changes since you were last able to log in? Anything in the Security or...

netstat can be useful when looking at the ports. Start|Run|cmd Enter. netstat -a Look for your SQL Server port to be listening.

You can check to see if the...

sorry I didn't mean calculated column, I meant Computed column... But basiocally that's the gist of it. Technet can go through it a lot more thoroughly than I.

You...

Is your server set to only integrated or mixed mode auth? If it's not Mixed Mode the SA won't help, although you can go into the registry and change...

Any chance the bad guys changed your password and aren't letting you in or worse?

IS the service running

Is the port open?

What does SQL Configuration Manager show?

If you didn't change it from the default then your tempdb recovery model is set to simple. If this is the case then there really is no reason to...

In a word YES. Anytime you are using functions such as that on one side of the join it will most likely disallow index usage on that side. ...

You might be better off talking to someone in your local area who you can bring in asw a consultant to make sure you're not violating any HIPPA rules or...

Did you review the link I posted? Some times things take more space than autogrow will allow. The db won't autogrow twice for the same transaction. It...

Yes it doesn't look like an inner join to me either. Looks more like a cross join, or mayhap I'm just reading it wrong.

what do you think it's supposed...

yes it can be changed without restarting your SQL service.

Look up the Alter Database Command in Books Online.

Just select your top 5 percent rows and order by NEWID()