There must be differences. No such thing as magic. Differing data sets leading to an error, maybe corruption on that database, something. Keep looking and look in and around settings...

If the same code doesn't work, then I'd start checking settings. First, default ANSI settings on the server. Collation on the server and the database. Also check collation on tempdb....

It's usually not a network problem, but it might be. It's usually an issue where the client code is doing row-by-row processing. There is no other wait occurring. It's literally...

UNION is an aggregate function that is basically going to give you unique values. If you want to eliminate them from the query any other way, it's probably through having...

And remember, those costs are just estimated values. They don't represent a literal real-world performance metric. It's just a measure of what the optimizer thinks a given operation will cost...

OK. Have you checked the error logs, both SQL Server and Windows? I can't really suggest a whole lot more than that without more details than that you have an...

KWymore (1/15/2014)

---

I have worked with many in the past who did just enough to get by and rarely pushed themselves to provide anything beyond the bare necessities. I was always...

below86 (1/15/2014)

---

I agree that I've looked at what I've done 2/5/10 years ago and think "what the 'H' was I thinking". And yes you would love to go back...

I agree on the number of students. Also, what's the difference between student_pk and student_id? Seems like one or the other isn't needed unless the ID is some sort of...

I'm actually a little shocked at some of the responses from the editorial. I thought the editorial was absolutely spot on.

For all those who think that you shouldn't be striving...

Alan.B (1/15/2014)

---

You are correct Grant. I did not mean to contradict anything you were saying. Frankly, I would not have posted anything if I had first seen that you or...

Very little to go on there. Usually these things are due to security settings. Does the account that you set SQL Server up to run under have the appropriate access?...

One more, we recorded a two-part webinar[/url] for Red Gate (who I now work for, didn't when I wrote that book) on deployments. Part two is primarily around Red Gate...

I wrote several chapters in a book called, SQL Server Team-Based Development[/url]. Now, some of the work is WAY out of date since the technology has moved on quite a...

katrina92886 (1/14/2014)

---

I am sysadmin -- I would certainly hope so, seeing as I am a free-lance developer (at this point) using my own laptop for everything.

"capturing query metrics using extended...