Unless there is some magical way to make SQL Server look for the tempdb in a new location, you are down until you repair/replace the drive.  SQL Server is looking for the...

Are you in a Domain?  If you can login to SQL Server using your Domain Windows account, there is not a problem with your login.  But if you've already deleted...

I would first check and make sure you did not lose a disk.  Then look in the folder where you would normally keep your TempDB and make sure it is...

It would help if you could post the DDL for any table listed in your example as well as some sample data.

Your challenge here is that you must aggregate the date since you are using a GROUP BY clause.  Take a look at your first query,

Select Class, vDate 'Date of...

DECLARE @market as varchar(30)

SET @market = 'Test'

IF @market = '-1'

    SELECT * FROM VarianceReportTable

ELSE

    SELECT * FROM VarianceReportTable

    WHERE Market = @market

Or you could use a case statement,...

I don't believe you can, in fact, odds are you don't need a cursor.  If you post your cursor definition (which you apparently put in up_OMS_getBudgetResults) and a description of...

Add the Performance>>Execution Plan event.  Then scan the trace file for table scans in the textual execution plan. 

When you say MAX, are you looking to find out the maximum number of transactions your SQL Server handled per second over a given period of time, or are you looking for...

I’m not trying to sound redundant here, but I get the impression that there is still some confusion here.  There is an important distinction between...

By default, the Windows Administrators group has DBO access to SQL Server via the SQL Server System Administrators server role.  This means that by adding a Windows user to the...

OK, now I'm with you.  The Computer Management tool is a Windows component used for managing Windows level access and is completely separate from SQL Server access/security.  The local users...

I'm not clear on what you mean by administrator folder in computer management?  Are you referring to EM?  Anyway, there is a difference between roles and logins no matter...

Once your users have access to a database, they will need object level permissions.  This can be done by granting the permissions to the user or by creating a Role...

Adding a user to a SQL Server database is a two step process.  First, you must create the login.  This is an instance level login.  All valid logins for a...