No such function in SQL Server 2005. What are you trying to do?

weberharter (11/26/2012)

---

The point is, many of our foreign keys reference to columns that are the clustered index so many joins result in clustered index lookups or scans. And that's where...

Well if you selectively quote me, yes...

Try rebooting the machine, see if SQL will start then.

As I said...

High memory use by SQL is normal. Hence not a cause for concern.

SQL can and will use memory outside of the buffer pool (which is what is controlled...

weberharter (11/26/2012)

---

select top 1000 * from #TestIndexAccess

I still have a clustered index scan but it is NOT an ordered scan. Still the first query needs only 3 logical reads. I...

1) High memory use by SQL Server is normal

2) Max server memory specifies the size of the buffer pool. SQL can and will use memory outside of the buffer pool....

Typically a scan is a full scan (in the absence of TOP or other operators that give row goals). It's the seek that can be a single row or a...

What does the SQL error log say? The screenshots don't say anything useful (and I can tell that even though I don't speak French 🙂 )

Please read through this - Managing Transaction Logs[/url]

No, you do not need to shrink the log file, it's counter-productive. If the log needs to be that size it will just...

Those are for SQL 2000.

Google down?

http://www.google.com/search?q=SET+SHOWPLAN_ALL

http://www.google.com/search?q=SET+STATISTICS+PROFILE

I believe that one is known as 'complete...

Please read Opc's post.

Please don't post multiple questions for the same problem.

No replies here please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1388027-360-1.aspx