Viewing 15 posts - 1 through 15 (of 79 total)
Thanks for the reply
-e command worked for the question#1, however for question 1 if the update statement takes more than a min to run, it does not log the number...
June 3, 2011 at 1:01 pm
David there is a direct correlation i.e checkpoint pages is high when cpu is high.
December 21, 2010 at 7:55 am
David,
Back in November when we had the issue with "Resource Monitor" upon investigation it was indicated that it is a know issue and SP2 would take care of it (Pls...
December 21, 2010 at 7:47 am
Thanks for the response David
I look at perfmon and gathered the process which consumes most CPU, subsequently from that process I grabbed the corresponding thread and plugged it in the...
December 21, 2010 at 7:30 am
1) change the database back to operation mode
2) restore the latest log with recovery.
3) once your primary up, then if you wish you cna put secondary back to read only.
After...
September 7, 2010 at 9:38 am
Master database is the default database for this login.
November 16, 2009 at 8:49 pm
My bad the second query is
SELECT S.STATENAME, H.SCHOOLNAME, D.DEPARTMENTNAME, E.EMPLOYEENAME
FROM EMPLOYEE E INNER JOIN DEPARTMENT D ON E.EMPLOYEE_ID = D.EMPLOYEE_ID
INNER JOIN SCHOOL H ON H.SCHOOL_ID = D.SCHOOL_ID
INNER JOIN STATE...
May 22, 2009 at 11:46 am
It is a SAN disk, is it advisable to have all the data files for the 4 databases on single disk and log files. Should tempdb be always on seperate...
February 19, 2009 at 7:42 am
this statement will error out since you cannot pass function in the update statement. Is there anyway to accomplish this.
January 2, 2009 at 8:56 pm
The start date should always start from next month based on the specific day of the month provided. Regarding my code I am still trying to figure out how do...
November 24, 2008 at 2:37 pm
That is the correct output of TableB
Below is the SQL that I used
SELECT A.AGENCYCD, A.AGENCYCOSTCD, A.EFFDATE, A.ENDDATE, A.PYMNTVALUE
FROM TABLEA A INNER JOIN TABLEB B ON
A.AGENCYCD = B.AGENCYCD AND A.AGENCYCOSTCD =...
November 24, 2008 at 1:22 pm
ALZDBA (11/6/2008)
Is this a migrated database from sql2000 ?if so:
- rebuild all indexes
- sp_updatestatistics
- dbcc updateusage(0) with count_rows
and if you can ... dblevel to 90 !
can you please elaborate...
November 6, 2008 at 2:18 pm
Lynn - Also the index on the column that we are interested is not updated, when the row gets inserted the column gets set to todays date getdate() as part...
November 6, 2008 at 1:07 pm
Lynn - Thanks for your response.
In my scenario after I updated the statistics on Employee table the query performance improved by 300% and hence I am wondering should the auto...
November 6, 2008 at 1:01 pm
Viewing 15 posts - 1 through 15 (of 79 total)