Kristy Lanter (10/27/2009)

---

Yeah, but what I was wondering was if it was really needed. Back a few years ago I read someplace it wasn't necessary to set it up...

Enterprise Edition has always had the ability to lock pages in memory.

Yes I would think so too - I just haven't been able to make it behave the way we would expect yet.

It's currently sat in my interesting-but-useless pile. The...

Good luck, and you're welcome of course.

edit: posting that, it's just occurred to me to ask you to check that your code doesn't switch context away from the target database...

I do agree with Mr Guru there about the ORDER BY thing, but as a matter of curiosity, I think the following also guarantees a repeatable order:

WITH TS AS (SELECT...

Interesting - and no, ALTER DATABASE is not allowed within a transaction.

Are you sure you're not just encountering an error of some kind between the SINGLE_USER and MULTI_USER changes?

An error...

Ok, but in which database is the stored procedure defined? AttendaDW? My guess would be not ;c)

The stored procedure needs to running in the context of the database...

Activity Monitor connections are a favourite.

If you need exclusive access to a database (for some reason...?) the traditional approach is to change context to that database (with the USE [database_name]...

Apparently, in the next release, all data will be stored compressed in the column names - there won't...

ranjitrjha (10/22/2009)

---

GSquared,

Your explanation makes sense but when i am running

select top 10 * from table1

select top 10 * from table1

then for both queries, result set is same.

It's only when I...

I've come across what I believe to be both ends of the spectrum on this one.

First up, an old application built to be compatible with any back-end database (restrain yourself...

coboljobs2003 (10/20/2009)

---

I am new to SQL server 2005 and I am trying to work on a project to invoke an existing webservice from SQL server 2005.

(This webservice which is...

Alvin Ramard (10/21/2009)

---

Before the XML data type, all data could be stored in tables with a no more than 4 columns. Now...

...what's the ID column for? :laugh:

Fair enough! It was the two guys saying...