Viewing 15 posts - 91 through 105 (of 1,479 total)
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 12, 2015 at 4:15 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 12, 2015 at 4:07 am
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'...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 7, 2015 at 6:10 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 7, 2015 at 2:16 am
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' +...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 27, 2014 at 3:51 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 26, 2014 at 10:09 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 26, 2014 at 9:50 am
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'...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 20, 2014 at 4:02 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 12, 2014 at 1:32 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 12, 2014 at 1:23 am
I think that it could also be that he tried to create a login with windows authentication.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 3, 2014 at 3:02 am
You can change the schema's ownership. Here is an example:
ALTER AUTHORIZATION ON SCHEMA::SchemaName TO NewOwnerUserName;
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 3, 2014 at 2:59 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 29, 2014 at 7:28 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 29, 2014 at 7:04 am
mcfarlandparkway (10/28/2014)
Hi ,how to check the object propert function?
http://msdn.microsoft.com/en-us/library/ms176105.aspx
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 28, 2014 at 9:41 am
Viewing 15 posts - 91 through 105 (of 1,479 total)