On the PK:

Don't confuse the primary key and the clustered index. While the default is for the PK to be clustered, you don't have to make the clustered index on...

BLOB_EATER (9/29/2016)

---

so....I will be doing a presentation in front of 40 people soon, I was wondering if the vets here have any advice? Practice in front of a mirror? smile?...

drew.allen (9/28/2016)

---

mcfarlandparkway (9/28/2016)

---

TY for the response, In the recent code we are selecting data form temp table where DOC NOT IN (select DOC from table where code<> -1)

This is what...

ScottPletcher (9/28/2016)

---

Eric M Russell (9/28/2016)

---

ScottPletcher (9/28/2016)

---

You'd still need to keep at least the history from the previous check, because an index/table could be dropped, which would remove it from the...

mw112009 (9/28/2016)

---

Select name FROM ReportServer.dbo.Catalog where type = 2

--This gives you the list of all the SSRS reports in your Reporting Server. Agree ?

-- I am looking forqward to...

For production, first thing, everyone has a second login from their standard one. One that's for your machine, email, development, whatever. Another that's only for production. A lot fewer errors...

Anyone who has the capacity to overwrite the database in a restore from a security stand point is going to be able to undo your changes. DDL triggers don't have...

I don't completely understand what you're asking? Can you expand on what it is that you expect to return? What's the data structure you're pulling information from?

There's no way logically that can work because you would be joining all three columns on all three columns. The syntax doesn't support it and the language doesn't either.

Can you...

You would have to poll all the tables in the database, one-by-one, to determine if there are changes. That's a poor approach. You could read the log using DBCC LOG...

Going to a heap in the hopes that you get improved compression is not the way to tune queries. If that clustered index is in use, it needs to stay...

A view doesn't have statistics.

A materialized view does, because a materialized view is an index. You can't drop statistics from an index.

I think I'd add another table in there. Instead of having a direct link between ProductPropertyType and ProductPropertyValue, I would define the values, the properties, and then have a table...

Eric M Russell (9/27/2016)

---

Talib123 (9/27/2016)

---

Hi All,

I'm a production DBA and have been for a good while.

I can query, join filters but how do I get my T-sql skills to...

There has to be something else causing the issue. If you're seeing different execution plans, it's because the mechanisms used to generate those plans have different inputs.