rmechaber (10/3/2012)

---

Please double-check the link before you contradict someone or call them "careless" or tell them what they "should be" doing: that page was from SQL Server 2005, which happens...

Nice and easy question.

I wonder when (if ever) it'll become possible to define our own stemmers for use in FTS.

Typically customer codes occur in order records more often...

Sean Lange (10/3/2012)

---

NO LIKE is not SARGable so you will get scans. It has to examine every row to determine if...

ChrisM@Work (10/3/2012)

---

Nonsense. The OP has explained that (s)he is a novice, Joe, and is willing to learn or...

CELKO (10/2/2012)

---

NO! We hate UDFs; they are not declarative, do not optimize and stink of 1950's FORTRAN. SQL is declarative and uses tables! This is a huge change in...

K. Brian Kelley (10/3/2012)

---

Also, I would add that it's relately simple to audit for Windows group changes. This is even easier in 2008 AD and above with event forwarding. An...

rmechaber (10/3/2012)

---

Per BOL:

length

Is an optional parameter of nchar, nvarchar, char, varchar, binary, or varbinary data types. For CONVERT, if length is not specified, the default...

GilaMonster (10/3/2012)

---

HowardW (10/2/2012)

---

Have to say, getting increasingly irate about e-book pricing. Why do I have to pay 50p more, given all the costs of printing, distributing and shipping a physical...

From Google translate:

When ruigeas you country gheallaidh, if you were not him t'aire, coinnichidh Sasunnach riut,

These plìon him, day dh'innseadh you gun God gave, father, brother, just two anns...

Yes, I change the avatar every few months; and switch languages (and messages) in the signature message quite often too. Avoids...

On top of the ambiguity (I regard Steve's protestations about "the real world" as just so much waffle obfuscating the poor quality of the question) this question doesn't say whether...

James Lean (4/26/2005)

---

I thought this was a rather ambiguous question. The question asked how you would exclude JUST the oldest error log from the report. The correct answer...

Miles Neale (5/2/2005)

---

If you look at the following link there is some clear information about this.

<A href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_customizing_v1_4hys.asp">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_customizing_v1_4hys.asp</A&gt;

Config will add it to the farm. But it still can not function. To...

Nice question. Made me think.