You will find it the cause of this if you look at the Execution plan. The SQL optimizer uses a table scan to get "ch" from the first row since...

MarkusB (4/16/2009)

---

You can use the 2005 dashboard, but there are a few problems.

I had a couple of times that a report gave an error the first time I used...

Have you tried it your self?

I installed it in my development environment and as i can see there are some defects in the setup script that creates the functions used...

It is not a bug, its a conversion error, due to the fact that the number 11 is an int and SQL tries to convert the result to the nearest...

Thank you for pointing out this bug in SQL server, i was pretty sure that answer no 1 would be the correct one, but i was wrong. It surely is...

I think this is an Incorrect question! How do you update the FILESTREAM column without updating the row?

Håkan Winther

For your information, the NWlink protocol is not supported any more according to books online

Microsoft SQL Server does not support the Banyan VINES Sequenced Packet Protocol (SPP), Multiprotocol, AppleTalk, or...

Someone may think this is a feature, but i think it is sad that SQL doesnt handle this as an error due to the fact that it is to easy...

The question is correct as far as i am concerned, because DBCC...

I totally agree, it is frustrating that there is no correct answer.

/Håkan...

Thanks for your tip! 🙂

I found a lot of samples by...

This is what SQL Server books online say about encryption:

ENCRYPTION

Indicates that SQL Server will convert the original text of the CREATE PROCEDURE statement to an obfuscated format. The output...

ansar.vma (3/5/2009)

---

Hi all,

I have just installed SQl Server 2008 in my machine. The problem i am not able to find the Acitivty monitor (in SQL Server 2005 which was show...

I am sorry, to use the link you need to have books online for SQL Server 2008.

Use this link:

http://msdn.microsoft.com/en-us/library/ms189852.aspx

or

http://msdn.microsoft.com/en-us/library/bb895393.aspx

or

http://msdn.microsoft.com/en-us/library/ms190202(SQL.90).aspx

You have to open books online for SQL server an paste the link in the address bar.

/Håkan