Yep. I use bad slang on occassion, sorry. I'll try to stop doing it in...

Sorry, stayed home sick today, just catching up with SSC. So your primary costs are definately in the executables. Hm, I'd definately look into the drive builds. ...

Danky,

This should work, depending on datatypes:

SELECT ISNULL( col1, 'NULL'), ISNULL( col2, 'NULL),....

FROM Table

WHERE x > y

FOR XML RAW('Movement'), ELEMENTS, ROOT('SPEI')

pavan_srirangam (11/17/2010)

---

Yes exactly its a contention on my datafile SGAM pages

But not in tempdb its on user db.

How I do this in prod.

Dividing into equal no of files and into...

Steve Jones - SSC Editor (11/17/2010)

---

I go away for a day as my daughter's sick and we're now throwing pies instead of pork chops? What is up with you kids?!?!?!...

Grasshopper, just FYI, this does a LOT more than gapcheck. Also this doesn't seem that horribly painful, cursor optimization techniques shouldn't be necessary here.

Any chance we can see the...

:ermm: Yeah, you caaaannnn.... but why would you want an additional 4 .ndf files with no other purpose to them? Just splitting the files without a purpose for...

Of some interest to your results may be that a Cold Buffer is not necessarily an unused buffer.

See this article:

http://blogs.msdn.com/b/psssql/archive/2009/03/17/sql-server-what-is-a-cold-dirty-or-clean-buffer.aspx

In particular:

SQL Server understands the time of last access to buffers...

Jason Miller-476791 (11/17/2010)

---

I think that'll fail because you will be tempted to remedy this by putting in sets where/join clauses within each inner select, but this just does one more...

Welcome back, Jordan. You've come a long way since your last discussion. Glad to see your interest hasn't waned when you saw the size of the hill you've...

C'mon Joe. Not only is the table an obvious example instead of true DDL (there is no way someone could use THAT many reserved keywords at once... just... no...),...

Alright, another business logic question, then.

The way you're approaching it, with this dataset:

( 1, 2, 3 ),

( 4, 1, 6),

( 1, 7, 8),

( 9, 2, 10),

(11,12,...

EDIT: Whoops, cross posted by accident, had two windows going at once and punched this into the wrong one. Correct response below:

You want a splitter function. Check this...

Support? We get paid for this? *scratches head* Hey, Steeeeeeeve..... where's my check dood?!

A few things in this make me question the proc in general.

Jason Miller-476791 (11/17/2010)

---

CREATE UNIQUE INDEX ix1 on #t1 ( c1 ) ;

CREATE UNIQUE INDEX ix2 on #t1 ( c2...