Sounds like a classic "double hop" problem. Read this and see if it helps:

http://www.sqlservercentral.com/articles/Double+Hop/76743/

They do recommend that you have a few years of experience but it certainly does not have to be SQL 2005. In fact if I remember correctly they want...

L' Eomot Inversé (10/22/2012)

---

crussell-931424 (10/22/2012)

---

The effective result is different for a table that has had records from a table that has never had any records. Don't know why. It just...

john.arnott (10/21/2012)

---

Good topic for a follow-up QOD (hope I don't steal any thunder here):

If the code presented had one more statement amnd asked for the max(Ident)...

CREATE TABLE IdentTest

( Ident...

Ok, I apologize for being lazy. My only excuse is that I was busy and being stupid. :hehe:

Plan Explorer?

Please read the explanation and the previous 79 posts. ...

The Dynamic Port is set to blank for all IPs including IPAll on both instances.

The default instance is using port 1433 on all IPs. The named is using 4322...

Thanks! I saw several of those type questions in the flash cards and didn't really figure they would show up in the exam. Of course I did see...

Has anyone used Transcender exams? I tried the sample exam and was fairly impressed. Has anyone tried them then taken the exam? Does the question difficulty/style match...

So should this work? Or are there any exceptions I should take into account?

SELECT database_id, COUNT(1) AS page_in_use FROM sys.dm_os_buffer_descriptors GROUP BY database_id

Thanks. That's pretty much what I thought. Now I just need to convince my boss.

+1

I have you followed but for whatever reason didn't get an email about the new post. ...

sknox (9/26/2012)

---

For a deeper understanding of what's going on, try this code:

CREATE TABLE #TABLE1

(

Col1 INTEGER

,Desc1 char(3)

)

CREATE TABLE #TABLE2

(

Col2 INTEGER

,Desc2 char(3)

)

INSERT INTO #TABLE1...

Yes. In full recovery mode you MUST run log backups in order to clear the log. This won't shrink the log, but it will clear it so that...