MCA, in this case,...

Grant Fritchey (5/25/2010)

---

I haven't been posting here at the water cooler because, frankly, I was appalled at how many posts I had here. But I have to share this one...

There's a big, massive, huge difference between not using an int identity for a primary key and...

Hang on, is this a SQL 2000 server? I know you said 2008, but this is something that could happen on SQL 2000, but not more recent versions.

SELECT @@version

pobeda (5/24/2010)

---

3) Nothing in Event viewer or SQL Log at the time of error, however, I am getting this message in sql log 5-6 times a day

05/24/2010 04:00:04,spid15s,Unknown,SQL Server has...

Only the last...

A CTE can only be referenced in the query that immediately follows it. It doesn't have batch or procedure scoping. You can repeat the CTE definition before the second insert,...

Also doesn't stop people using...

Without seeing the code, it's very, very hard to give any useful advice.

Watch out for the lack of statistics on table variables. you're probably getting bad execution plans as a...

Oksana March (5/25/2010)

---

Or in other words, is it possible to see a list of ALL possible questions that may be in the exam?

I know memorizing the answers is not a...

What errors are there in the SQL error log?

Mornings and evenings are getting nippy up here too. Looks like it's going to cool down further over the weekend.

Duplicate post. No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic927206-146-1.aspx

Neither is true.

What you can get is a form of...

You cannot take a backup of a database on a SQL 2008 instance and restore it on SQL 2000. Once a database is attached to a SQL 2008 instance, it...