Mike Dougherty-384281 (12/21/2010)

---

ronmoses (12/21/2010)

---

For educational purposes, I would genuinely appreciate it if one of the folks who take issue with the "most of the time" factor could illustrate a scenario...

Make sure you don't have linked server (or direct access) to excel files on the 32 bit. They won't work on the 64 bit server. There is apparently...

Sean Lange (12/21/2010)

---

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

---

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

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