Jeff Moden (4/28/2014)

---

Just a thought...

The looping is going to cause a full table scan of a 100 Million row table for each and every loop. That's a shedload of...

I would also check out SQLSaturday.com and View All Events there. Open each event's Schedule Page and anything you see with an Orange download button is FREE content for...

Then you are discounting one of the best tools for dealing...

Sorry MarbryHardin, but your solution is totally awful from a query optimization standpoint and you are guaranteed to get suboptimal performance. Read Gail's blog posts. Also, scale...

Good observations Jeff. I believe a lot of it is in the masses thinking that Google/Twitter/Facebook/EBay/Amazon et al storing kajigabytes of information and retrieving it nearly instantaneously make developers...

Yes, but it isn't cheap (at least some years back when I evaluated it for a client).

http://www.whitesands.com

They have some really cool and useful capabilities.

That's a very diplomatic way to phrase that question. Very well done! 😀

That is a VERY low-end machine, esp. the one 7200 rpm disk issue. And there are SOOO many things in SQL Server that need to be changed to get...

See Books Online for details about sp_executesql. You need to be using the fully parameterized capabilities:

EXEC sp_executesql [ @statement = ] statement

[

{ , [...

mattmc (4/15/2014)

---

Hi all,

I am currently investigating aa high avg write time ms issue (145ms) which seems to be only occuring on the tempdb data files.

Please note that I...

vkundar (4/14/2014)

---

Thanks Kevin.

Yes I agree I do see many transacations ( data loading runs for a long time with open_tran value euther 1 or 2)

I have asked the team...

could be any number of things causing full tempdb: improper Cartesian products blowing up rowcounts, version store (possibly bloated due to suboptimal design/coding practices), massive sorts, massive hashes (often...

I don't click links like that, sorry. But a) what are you trying to accomplish and b) what error are you getting exactly?

Riddle me this: what integer do you expect from this value: 'cht6p575l7ry61k1npt'??

any non-integer values need to be discarded. Unfortunately that is really not that easy BEFORE SQL 2012....

Try out Grant Fritchey's free ebook on execution plans: https://www.simple-talk.com/books/sql-books/sql-server-execution-plans,-second-edition,-by-grant-fritchey/