Sergiy (3/9/2016)

---

Is the described behaviour version dependent?

I replicated the tables, enforced and checked the FK, and I still have Clustered Index Scan on Projects, Clustered Index Seek on Departments and...

Please post a repro script (that is a script that includes CREATE TABLE statements for all tables involved, with all constraints and indexes; INSERT statements with sample data; and in...

I didn't test it, but I guess you could try to see if this works:

GROUP BY MonthKey, CASE WHEN @Parm1 = 2 THEN CorporateName END

I do not expect this to...

In addition to what Phil writes...

1. Double-click the job name in the Job Activity Monitor window, switch to the Steps tab, and click Edit (if there are more steps, do...

Did you already try the approach with column-level permissions? Have you...

Music

Thanks for all the feedback and compliments, people!

And sorry for being off the radar just when this article was published.

@gabriel: I see that John already replied to your question. Thanks,...

Short answer to a long question:

If the salaries are paid on a weekly basis, and they are not guaranteed always the same every week, and they need to be stored,...

If you want to do partition switching, then all indexes MUST be partitioned. There's no way around that. (Well, unless you are prepared to drop the index before the switch...

Try this modification instead. Same idea (stopping when a loop is detected) implemented differently:

WITH cteHierarchy

AS (-- Anchor query: root level with all its children

SELECT ...

Yes, you can. But that will also prevent updating those columns from the insert...

Siberian Khatru (3/8/2016)

---

spaghettidba (3/8/2016)

---

Not with SSMS. You can cange the connection of a query window, but the new connection will always be to a single server.

If you want to do...

I could write a lengthy reply, but I'll save some time and simply post a link to a very excellent and very detailed writeup on various ways of passing long...

Ncage (3/9/2016)

---

Back in the day we were working with informix. He stated that in a clustered index there would be 1 row in a clustered index for each unique value...

The T-SQL declaration of the function includes a column FilePath that is missing in the code of the assembly.