Can you give a little more detail as far as what you want your result set to look like and which columns do you want min, max, avg?  Also, if you've...

Look at sp_changedbowner in BOL.

What is the datatype of tableX.Quantity?  If it is a numeric datatype, a negative number will not cause a cast error.  Bad data, in this case, may be bad design. ...

The absolute best way to improve your performance is to nix the cursor and come up with a set based solution for your problem.  If you post your code, you...

In addition to Pankaj's response, the more memory you have on a server, the more space SQL Server can use for the different memory pools (cache).  The reason SQL Server...

Well, that is kind of a broad question.  There are many factors that can add to blocking.  For starters, keep your transactions as short as possible and make sure your...

Try querying msdb..sysjobs and msdb..sysjobsteps.  Look at both of these tables in BOL for more info.

This is not a problem.  SQL Server is designed to use up all of the memory available to it.  It will not release the memory that it has claimed by...

“This person tried to create 2 differrent StoredProc and each had a #temptable with the same name. Eg #Results. and had the same name for...

Backing up the log does not change the physical size of the log, it only removes inactive entries.  In order to physically shrink the file, you must run DBCC Shrinkfile. ...

What is the datatype of your column?  If your raw data looks like you've posted 'DD-MM-YYYY' , then your column has to be a char/varchar column correct??  If so, none...

The real question here is why, if your data represents a date, are you not storing the value in a datetime column?

Also, you said "I cannot put 'DBA' in my resume and so I can never apply for DBA job".  Never is a strong word.  Even if you could not put...

Lock timeouts are usually the result of blocking processes.  Object ID of zero is the database object so if you are getting lock timeouts on your tempDB object 0, it...

Or use an ANSI OUTER JOIN:

SELECT A.*

FROM CUSTOMERBRANCH  A

    LEFT JOIN [SERVER].[DATABASE].DBO.TBCUSTBRANCH B

    ON A.ACCPACCODE = B.ACCPACCODE

WHERE B.ACCPACCODE IS NULL