Eugene Elutin (11/13/2012)

---

Looks like homework to me.

Have you tried using PIVOT. Where are you so far?

We can help you to learn and resolve issues instead of just providing...

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...