GilaMonster (8/10/2009)

---

rja.carnegie (8/10/2009)

---

... because it's no longer the case that your use of the command has to be considered as possibly "SELECT column FROM gregory.table" and mine is "SELECT column...

TheSQLGuru (8/10/2009)

---

Clearly if your logic REQUIRES complex data access/processing PER ROW of output then a UDF is quite possibly the correct tool for the job. You are definitely correct...

Seems so:

-- 0x3600 3700 3400

SELECT (CONVERT(VARBINARY, N'674'));

SELECT CONVERT(BINARY(2), UNICODE(N'6')) -- 0x0036

SELECT CONVERT(BINARY(2), UNICODE(N'7')) ...

For that configuration, try:

EXECUTE sp_configure 'show advanced options', 1;

RECONFIGURE;

EXECUTE sp_configure 'min server memory (MB)', 512

RECONFIGURE;

EXECUTE sp_configure 'max server memory (MB)', 1536

RECONFIGURE;

EXECUTE sp_configure 'awe enabled', 1;

RECONFIGURE;

EXECUTE sp_configure 'show advanced options', 0;

RECONFIGURE;

I...

jacroberts (8/10/2009)

---

Why should '>' be much further up the performance list to '! is twice as efficient as !< since it uses just one character :laugh:

ta.bu.shi.da.yu (8/10/2009)

---

I'm curious... would the selectivity of an index influence the execution plan when an inequality predicate is used? I ask because, tucked in the recesses of my mind, I...

I clearly need to work on my 'being abrupt' skills :blink:

I tried quite hard...

GilaMonster (8/10/2009)

---

I've seen SQL convert a predicate WHERE SomeColumn != 0 into WHERE (SomeColumn > 0 OR SomeColumn < 0) and seek on an appropriate index. It's still two partial...

oli (8/10/2009)

---

I find that the nice highlighting in SSMS more than adequate and a lot easier on the eyes...

ronmoses (8/10/2009)

---

ta.bu.shi.da.yu (8/10/2009)

---

vetri (8/10/2009)

---

Hi,

I tried with these two statements but the second one is not get executing and it says "Incorrect syntax near the keyword 'exists'." What...

Yes, absolutely! Sorry Jeff, I...

The things that leap out are (just as Grant predicted) that the memory per instance has not been configured correctly.

You don't say how much memory is on the physical server,...

GilaMonster (8/10/2009)

---

Woot. My muse has returned. Sat down over the weekend and hammered out 3 pages of an article that I've been staring blankly at for the last couple months....

I deeply begrudge the minimum one star.

Gail's first post expresses it best, and in milder language terms than I might have used. I would encourage everyone who reads the...

Yes, this turned out to be another great discussion - as so often happens on SSC, an article prompts conversation which is just as interesting as the article itself, in...