Are these stored in one field or multiple fields?

separate fields, use the + to contatinate values

select year + month + '01'

you don't include the column in the UPDATE, only the SET.

UPDATE dbo.ResourceOwner

SET dbo.ResourceOwner.UserID = dbo.Testupdate.userid

FROM dbo.ResourceOwner INNER JOIN

dbo.TestUpdate ON dbo.ResourceOwner.RESOURCEID = dbo.TestUpdate.EquipId

WHERE (dbo.TestUpdate.EquipName <> 'NULL')

the logic is

SELECT xxx

from EMP

will return a row for every row in the EMP table. If xxx is a column, it returns the values from that column. In your...

Again, it's not you, or the account you use in SSMS. It's the SERVICE account that SQL Server uses that executes things, not any of your accounts.

Anything that makes use of tempdb, especially large transactions that have sorts, index rebuilds set to use tempdb, etc. will cause transactions in tempdb. It is the same as what...

Actually based on this thread I think the most often used words are "urgent" or "start your tests"

😛

Mr Denny and Jeff have given you a good explanation. When you run something in SQL Server, using SSMS or your client, it doesn't run under your windows account, or...

third vote for George here.

If it grows every day, and you shrink it every day to have it grow again, does that not seem silly? What's the point?

Since you are getting started, in addition to some reading, here are some videos: http://www.sqlshare.com/channel.aspx?cat=4a00c49a-6207-4ba8-952c-807481629761

A deadlock needs two sessions, and it needs multiple objects being accessed. AFAIK, if each person ran a single query you could not have a deadlock. It requires each person...

Deadlocks don't occur within a query, they are within a transaction when you are updating two objects.

I agree with Barry that you haven't really presented your thoughts in an organized manner and it's hard to follow.

My guess is that you would have an DrugOperations table that...

If this is homework/exam/interview question, it's not our intent to do the work for you. As mentioned by Jeff, you should try it. If you can't try it, then perhaps...

thanks, the servers have been acting up a little under load. We have emails sent from another server that connects to the database to send, but if that sender gets...

I'd agree with George that sp_help_revlogin is a better choice.