Also check the server settings, especially default connection settings. If one is using ANSI standard and the other is not, again, you might get different execution plans.

This is just because recruiters and HR departments only have a list of requirements, not actual knowledge. If you don't meet the list, you don't meet the list. The only...

It might be statistics that are out of date, but from the sounds of it, I'd want to be sure that the structures are identical, that the code in both...

Your statistics look to be off. You've got implicit data conversions on all your predicates, possibly causing all the scans, and it looks like you may have a multi-statement table...

It's absolutely a problematic approach to a JOIN. Functions like that means you can only ever scan the table.

The reason it might be erroring out so quickly is because...

That's a weak question. I'd want to know what the interviewer meant by that, whether they were looking for error levels or what? They must have something particular in mind.

GilaMonster (4/18/2012)

---

DataAnalyst110 (4/18/2012)

---

/****** Object: Login GalacticReporting Script Date: 5/23/2004 11:18:21 AM ******/

if not exists (select * from master.dbo.syslogins where loginname = N'GalacticReporting')

BEGIN

declare @logindb nvarchar(132), @loginlang nvarchar(132)...

Basically, but it was largely that the benefits were so small at various data ranges (he...

george sibbald (4/18/2012)

---

Grant Fritchey (4/18/2012)

---

I would be very careful about using reorganize as a mechanism for performance enhancements. I've seen tests run by Brad McGehee and it's only of marginal...

I don't think those are standard terms. I suspect they are either in-house terms or terms for a specific product.

I would be very careful about using reorganize as a mechanism for performance enhancements. I've seen tests run by Brad McGehee and it's only of marginal use within a very...

Informational, bad ones, and really bad ones.

Can you narrow down what it is that you're looking for? There are all sorts of possible errors, so knowing more about what it...

Your best bet is write a script that will do all the databases. You can use sp_foreachdb, which is just a cursor, to run a command on all databases.

Alternatively, you...

I'd get a look at the execution plan. If the query is against millions of rows without an index, likely it's creating a hash table in order to do the...

WayneS (4/16/2012)

---

Brandie Tarvin (4/16/2012)

---

If any would-be employee claims to be a Threadzian, we have two questions that we can now ask them during the interview.

1) What does sp_kleenex do and...