You owe me 5.95$ :hehe:

Check out those 2 links :

http://technet.microsoft.com/en-us/library/ms190772.aspx

Which I found here :

http://sqlserver-qa.net/blogs/perftune/archive/2007/10/23/2212.aspx

I'm not a member either... but for 5.95$, it doesn't seem like a huge barrier to entry.

P.S. Have you considered using plan guides?

You need to shine in your interview...

Maybe you can offer a free day or 2 to work with your direct future supervisor and give HIM a chance to see you...

Let me try another variation of the same problem.

Are you trying to match all people that speak ALL those languages : French, Spanish, English?

g.graetz (12/21/2010)

---

hello

i wrote a similar constellation ( nav 4 sp3, sql-server2005 ).

it is the time if you kill a process forever or not forever,

under 10 min. ok, over 10...

Sean Lange (12/20/2010)

---

Ugh! Navision aka No Vision. Just went through a lengthy migration away from that product for one of our companies. Interesting that their licensing is based on the...

In case I'm missing the obvious here ---

Is there any way you could use row_number at SELECT time for this column?

if not, I don't see any better way than a...

You can't do it in the middle of a statement, however you can do it between statements in a batch with this code :

WAITFOR DELAY '00:00:03'

WAITFOR TIME '12:34:56'

It's pretty easy to figure out.

Try building a new db with 11 gb of datafile.

If you can do it, then you know the limit is on the real used space...

Hey I just googled it for you. If you don't like the work then don't do the certs.

My db happens to have 3 files, you'll most likely only have 2.

RESTORE DATABASE [PROD-FORDIA_demo]

FROM DISK = N'Z:\PROD-FORDIA-FULL 2010-12-20 05H00.bak'

WITH FILE = 1, MOVE N'PROD-FORDIA_Data'...

http://www.microsoft.com/learning/en/us/certification/mcdba.aspx#tab2

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