OCTom (2/13/2014)

---

I'd like to add my nickle's worth from my perspective as a developer.

FKs make my job so much easier. I don't have to write the code that prevents orphaned...

Idera's product works. But it will cause hits to i/o and you will have to have storage available for it, although not initially.

Cool question and kind of fun. I tested it out this way:

IF (SELECT OBJECT_ID('Test1')

) IS NOT NULL

DROP TABLE dbo.Test1;

GO

CREATE TABLE...

For just queries... I'd suggest going with Solarwindows (formerly Confio) Ignite. That's one of the best third party tools for just going after query performance. It's not so good with...

Also, check the cost threshold for parallelism on the server. The default value is 5 and that is radically low for most systems. Changing that to an appropriate value (say...

A little piling on in this case is good.

I've worked on systems that let the code handle all referential constraints. It failed. Every time. I'm sure it's possible to do,...

You can open the properties of the first operator of the plan when looking at the graphical plan. That will contain the information about which plan guides have been used,...

GilaMonster (2/13/2014)

---

Grant Fritchey (2/13/2014)

---

The fact that you have four clustered index scans and a heap scan should be a bigger concern than sorting cost. And, what the heck, that's a...

There are lots of blog posts on DBA interview questions. Just do a search for them.

The fact that you have four clustered index scans and a heap scan should be a bigger concern than sorting cost. And, what the heck, that's a completely different execution...

GilaMonster (2/12/2014)

---

Benki Chendu (2/12/2014)

---

GilaMonster (2/12/2014)

---

Benki Chendu (2/12/2014)

---

Gila - I would need help in showing my client a document which says 5000 is an agreed value. I can then convince them...

Assuming there's more to this query than in the plan you posted, to get improved sort performance, the best mechanism is eliminating the sort entirely from the plan. This is...

Personally, if it's on the forums, I skip it. If I can't understand what's being asked, even to guess at it, I'm not about to go through the pain of...

Here's an article[/url] I wrote on doing backups that includes new material from SQL Server 2014. It covers all the basics. This is an older article[/url] I wrote on the...

Personally I wouldn't sweat the hot spot aspects of identity columns. That used to be a pretty major problem back in the day (say, SQL Server 7 and earlier), but...