Do you do the index rebuild/reorganize after the full backup? If you do, then this can explain it. Also do you get the 400GB backup on Monday or...

Assuming that I understood what you want, Just add 12 – before the count key word:

SELECT 12 - COUNT(dbo.tblAppointments.PatientID) AS NumberOfPatientsCurrentlyEnrolled, dbo.tblAppointments.CourseID, dbo.tblLkup_Location.LocationDesc,

dbo.tblCourses.CourseDate

FROM dbo.tblCourses INNER JOIN

dbo.tblLkup_Location ON dbo.tblCourses.Location_ID...

This is one of the few times that cursor is helpful. You can create cursor for this SQL statement:

select 'kill ' + cast(session_id as varchar(20))

from sys.dm_exec_sessions

where host_name = 'MyHost'...

You can get all the sessions that came from a specific host by querying sys.dm_exec_sessions and get the value of session_id according to the value of column host_name. When...

Here is one way of doing it:

With MyCTE as(

select RT1.*, RT2.TimeStamp as EndTimeStamp,datediff(second,RT1.TimeStamp,RT2.TimeStamp) as DiffInSeconds

from RunningTime RT1 LEFT JOIN RunningTime RT2 ON RT1.Id = RT2.Id - 1)

select *,

right ('000' +...

Here is one way:

declare @t table (i int, c char(1))

insert into @t (i,c) values (1,'a'),(1,'b'),(1,'c'),(2,'a'),(2,'b')

select * from @t;

With MyCTE as (

select distinct i, (select t2.c + ',' from @t as...

I'm sorry, but I have to ask it – why would you want to do something like that? I don't see any advantage of using a value that is...

The best thing to do is to write the code with exec instead of GO, but you can also modify your replace statement so it will replace ENTER + 'GO'...

This is not how it works. You use password to authenticate the login. After the login was authenticated, it can use the permissions that he got. If...

When it comes to a query that is only using inner joins, most chances are that you will get the exact same query plan for all the queries which means...

I think that it could also be that he tried to create a login with windows authentication.

Adi

You can change the schema's ownership. Here is an example:

ALTER AUTHORIZATION ON SCHEMA::SchemaName TO NewOwnerUserName;

Adi

I don't think that the table's size is important as other factors. For example If I have a huge table with clustered index that is based on an identity...

When you work with filtered index or indexed view, there are some set options setting that every session that works with the table that is the base for those indexes...

http://msdn.microsoft.com/en-us/library/ms176105.aspx

Adi