declare @CurrentSchoolYear int,

@dtBeginDateIA3 datetime,

@dtEndDateIA3 datetime,

@dtBeginDateIA2 datetime,

@dtEndDateIA2 datetime,

@dtBeginDateIA1 datetime,

@dtEndDateIA1 datetime,

@dtBeginDateIA datetime,

@dtEndDateIA...

Lynn Pettis (8/16/2012)

---

Here is the problem we face, we can't see what you see. You are using a temporary table, great. Are you exporting directly from the table...

anthony.green (8/16/2012)

---

You can use the wizard to run a query to export to a flat file.

You can also run the query to file, but to save it as CSV, you...

No, because i am exporting my results from query

tim_harkin (8/15/2012)

---

What is the actual value for the /SERVER parameter, where you have "SERVERNAME"? Are you using Local, or "."? Or is it possibly on a clustered instance...

Cadavre (8/8/2012)

---

dwain.c (8/8/2012)

---

Thanks Lynn! Apparently if I could read, I would've come up with this version instead:

;WITH Unpivoted AS (

SELECT SchoolCode, RaceCode, Code, Value

...

No i Dont have sufficeint space on other drive.

Yes, i have...

MyDoggieJessie (8/6/2012)

---

i check in that table, that table is basically contains records for all log entries for the database, right now it contains 25 million records. so i need to...

Thanks a lot for your help, greatly appreciate.

My Transcriptional log will running every 15 mins.

MyDoggieJessie (8/6/2012)

---

Okay, so your larger index is about 45GB (math could be wrong on that but I think that's right)

Is the DB in simple or full mode?

Recommended changes: Remove the...

MyDoggieJessie (8/6/2012)

---

Something like this (you need to run per DB)

SELECT

i.name ...

Log file is also enable for Autogrowth

File growth 500MB and Restricted file growth 20Gb and Log file size is...

Jamie Johnson-406551 (10/2/2008)

---

Thanks for that

The database is first backed up by Maintenance Plan to a physical file, and then by Backup Exec SQL Server agent. Just had to look...

Yes the Maintainance Plan is good at running 3:00 am everyday

and its physical device name is the disk address what i am pointing...

PaulB-TheOneAndOnly (8/2/2012)

---

surma.sql (8/2/2012)

---

PaulB-TheOneAndOnly (8/2/2012)

---

surma.sql (8/2/2012)

---

hello

I have very wired problem

I schedule my back up at 3:00 AM everyday.and it store backup to different server.

now last 7-10 days I notice, there...