timfle (1/22/2010)

---

does anyone read MS documentation? Do you people even have the fainest idea what the "MODEL" database is used?

Obviously vk kirov doesn't (although I have worked with...

One more log for the fire.

I ran a simple CREATE DATABASE mydb using SQL Query Analyzer against my 2005 Developer edition, and the size came out to 1.68 compared to...

Policies are not an item that I have worked with yet, but I do have to pass the #70-432 this year, and I'm sure knowing this is helpful.

Thanks.

Learnt sump'n. Thanks, BitBucket!

I never gave a thought to 64 bit Windows/SQL Servers having different built in memory allocation settings than the 32 bit versions.

In fact, I figured that Windows Server 2008 wouldn't...

Following an interesting thread can be worthwhile and yet take some time to do when it is many pages. I would feel kind of let-down to follow a notification back...

Maybe you should check it again...

robert_edis (1/6/2010)

---

I am a little confused.

If the UPDATE statement has a WHERE clause of CategoryID = 7 but no records have been previously loaded then it cannot write any data...

Just because the question references a (the) Northwind db doesn't mean that you have to have one to answer the question. You have to figure that the question did fit...

:-)Ah yes... The old CTRL + ALT + D immediate reboot command.:-)

😉

Unsecure apps are always a problem, but what makes an app Insecure? Do they come from broken homes? I don't think I would trust them either.

If you install 32 bit ODBC client applications on the server, or any 64 bit machine, you must use the 32 bit ODBC Administrator (%SystemRoot%\SysWOW64\odbcad32.exe) to setup your DSN. You...

I think I prefer to have more smaller tools. The article made me ask myself why I still use SQL Server 2000 QA for most of my work. I think...

peter.house (11/30/2009)

---

While looking at the answer choices, my brain kept saying "Yesterday Midnight + 100ms"

For me, Midnight today is tonight and the SQL answer is this morning at 100ms after...

Ya got me.

:crying: