Perry Whittle (10/16/2012)

---

Really need to get an idea of the current file sizes, post the results of this please run against your database

USE YourDB

GO

selectname

, size / 128 AS FileSize

, case...

Ok, so that means

if i set up Initial size to 119.644 MB. then Restricted...

george sibbald (10/16/2012)

---

If autogrow is enabled for the database the file will grow automatically when it fills anyway, but best practice is to pre-empt thipreemptng manually. Make sure any autogrowth...

Hi Sean

There is slight difference in requirement

so the table and data as follows

CREATE TABLE #TestDates

(

iSchoolYearCode int NOT NULL,

dtStartDate DATETIME NOT NULL

)

insert into #TestDates values (2011,'2011-08-22 00:00:00.000')

insert into #TestDates...

Sean Lange (10/10/2012)

---

yogi123 (10/10/2012)

---

Sean Lange (10/10/2012)

---

This looks a lot like homework. We don't typically provide answers for homework because we want you to learn.

However, it seems you want the most...

Sean Lange (10/10/2012)

---

This looks a lot like homework. We don't typically provide answers for homework because we want you to learn.

However, it seems you want the most recent date prior...

I got it

DELETE temp

FROM (

SELECT

ROW_NUMBER() OVER(PARTITION BY x.cStudentId,x.dtEnrollmentDate ORDER BY dtEnrollmentDate asc ) AS DSeq,

x.*

FROM...

so far, i did

SELECT

*

FROM (

SELECT

ROW_NUMBER() OVER(PARTITION BY x.cStudentId,x.dtEnrollmentDate ORDER BY dtEnrollmentDate asc ) AS...

Ray M (10/3/2012)

---

Something like

SELECT

temp.cStudentId,

temp.iSchoolCode,

temp.cGradeCode,

COUNT(1) AS iMemb,

SUM(CASE WHEN temp.cAbsenceCode IN ('E','U') THEN 1 ELSE 0 END) AS Absences

FROM (

SELECT

ROW_NUMBER() OVER(PARTITION BY x.cStudentId ORDER BY dtEnrollmentDate Desc ) AS DaySeq,

x.*

FROM...

I Think

command is fine

/SQL "Maintenance Plans\MaintenancePlan"

/SERVER "SERVERNAME"

/CHECKPOINTING OFF

/SET "\Package\Subplan_1.Disable";false

/REPORTING...

yogi123 (8/2/2012)

---

SQLRNNR (8/2/2012)

---

If it runs successfully outside of the job, then we will need more info from the error output of the job. Output all job step history to...

Lowell (8/2/2012)

---

the reindexing can be a huge operation; 1.5x the size of the indexes being rebuilt, as i seem to remember it. so the reindexing of a bunch of...

Log backup successfully executed every 15 min everyday.

so i guess log backup...

yogi123 (8/2/2012)

---

SQLRNNR (8/2/2012)

---

If it runs successfully outside of the job, then we will need more info from the error output of the job. Output all job step history to...

SQLRNNR (8/2/2012)

---

If it runs successfully outside of the job, then we will need more info from the error output of the job. Output all job step history to a...