Thanks for the feedback.

The dba referenced the cited MSDN blog and correctly points out that ALTER INDEX ALL REBUILD does not update column stats. My counterpoint is...

If you anticipate high volume row operations on the table (e.g.: modifying or adding 1,000s of rows in one statement), then a trigger is better.

Check constraints are fired...

trying...

quickdraw (2/28/2011)

---

#1 This will be faster than full text search for large loads (hundreds of queries per minute) on a db with millions of records/documents to search.

...

Full text search was...

Querying for an attribute that is not available in the document will indeed make value() return NULL, just like when an element is not specified. However, not specifying the attribute...

ab.sqlservercentral (8/18/2010)

---

Guys,

those pagefile discussion drives me crazy. First, most of the posts are off-topic. The discussion is about MEMORY DUMPS, not about paging file calculation. Second, most people don't...

this is probably the best write-up of table variables i've seen and one of the best articles on SSC. kudos.

:w00t:

P.S.: if you've got hundreds of thousands of entries and the table is growing regularly, then an explicit colum to store the derived value should be added to the table...

We've had this debate before and the delimiting function's performance can practically always be improved by a hand-written piece of SQL. But the delimiting function's flexibility and simplicity makes...

NathanB (5/29/2009)

---

Hey guys, been struggling with this one for a bit and about to head home, but does anyone know how I'd get "18669911.96" out of this Text field?

"FFX Buy...

suggestion:

alter function dbo.fParameterMatrix(

@parm1 varchar(64), @parm2 varchar(64), @parm3 varchar(64), @parm4 varchar(64)

)

returns @matrix table

(

firstName varchar(64),

lastName varchar(64),

accountNumber varchar(64),

otherField varchar(64),

numFields as isnull(sign(len(lastName)),0)+

isnull(sign(len(firstName)),0)+

isnull(sign(len(accountNumber)),0)+

isnull(sign(len(otherField)),0),

duplicateFields as case when lastName in (firstName,accountNumber,otherField)

or firstName in (accountNumber,otherField)

or accountNumber...

Tara (5/27/2009)

---

I think my question was is not clear, let me explain it.

I have 3 parameters for my store proc and i would like an IF or CASE statements to...

what is your desired result? you're grouping by

OP.Specialty_Code,OP_Procedure_Tariff.Tariff

but also seem to want to sum and/or max of .Tariff. if so, .Tarriff shouldn't be...

eseosaoregie (2/17/2009)

---

I am currently going through some of my predecesors code and came across something that does not make sense. I have included the code below:

SELECT ...

aaa (2/17/2009)

---

This is good. Closer to what I require.

The point that I need to make clear is that this table will contain object information for each day, (sometimes more than...