paul.knibbs (12/17/2010)

---

Ninja's_RGR'us (12/16/2010)

---

You can download sql express and install it on your pc. That's always a good start. If that's a no go because the DB is over 4...

skcadavre (12/16/2010)

---

Backups used to be made regularly, but due to disk space it was turned off (not by me).

In the end, the tape disk was there, so I was able...

LutzM (12/15/2010)

---

So you have a database in full recovery mode but no backups?

What is the backup strategy you use? If you never performed any backup (including transaction log) you must...

Ok,...

GSquared (12/15/2010)

---

evald (12/14/2010)

---

GilaMonster (12/14/2010)

This is clearly documented. From Books Online:

When ORDER BY is used in the definition of a view, inline function, derived table, or subquery, the clause is used...

I guess I misunderstood the question.

Did you first try a restore that failed after 30%? Or did you try a restore that failed instantly?

I was under the...

Unless you have a backup (of sql scripts to rebuild everything) of the db you started to overwrite you're done for it.

Paul White NZ (12/14/2010)

---

WayneS (12/14/2010)

---

Would there be any issues with building the staging table (dropping it first if it existed) in tempdb? This is a database that you can ensure...

Or is there any ways to run a reorganize daily so that is splits the load?

kill the index job and then restart on offline hours.

sp_who2 to see who's blocking you (your spid is visible if the query window of SSMS).

If you specifically only shrink the log files (not the data files),

and that your select is really a simple single step select and not a whole business process then no...

LutzM (12/13/2010)

---

Paul White NZ (12/13/2010)

---

Yes :laugh:

All...

Here's a version with the times format correct with jobs just barely past midnight

IF OBJECT_ID('tempdb..#enum_job') > 0

DROP TABLE #enum_job

DECLARE

@MxCnt INT

...

Here's a version that works on case sensitive servers. I've also refformated with SQL Refactor.

IF OBJECT_ID('tempdb..#enum_job') > 0

DROP TABLE #enum_job

declare

@MxCnt INT

...

That question is too large for a forum thread... read on all you need here :

http://msdn.microsoft.com/en-us/library/bb522489.aspx