stephane3d (9/27/2008)

---

Hi,

I have a log table that saves web visits. And I have this query which is pretty slow :

select top 500 count(1) as nbCount, currentPage as item,

dateadd(dd, DATEDIFF(dd,...

As a side bar, I strongly question the value of assigning the NCHAR datatype to a column, like the amount column, that will obviously hold a numeric value.;) I...

There is one lightning quick method to do this in a set based fashion that depends on a clustered index. The method is discussed at some great length in...

For starters, you could try adding the "WITH RECOMPILE" option to the sprocs just to test the water. A better way would be to actually assume that parameter sniffing...

Thanks... I hate it when that happens... just splits resources and makes it difficult for others to search for a correct answer.

Since the other post has more activity, I'll continue...

peter (9/25/2008)

---

In my testing of using the shown tally function on the test input the estimated sub-tree cost of my whole query wend from 0.0131634 to 0.0071212 which is an...

You could...

Heh... yep... I understand all of that. But the obvious intention of generating the dynamic SQL is to make it possible to protect the user from accidental overwrites when...

If you want one that's ready made and pretty handy, lookup DBCC SHOWCONTIG and take a look at "Example E"... It even has a place to set a "Max Frag"...

Because they clear cache... not just for the proc running, but for everybody. Depending on what's being done, cache is very important for performance by repetative and other code.

... and, yes... that "feeling" goes towards delete triggers, as well.

ZIP is obviously a reference table. Someday, you may want to delete a ZIP with no impact on other tables. Cascading deletes is a pretty bad idea to...

The basic table naming convention I try to follow is... what does one row contain? Does it contain a Customer or Customers (answer should be obvious, there)? Same...

Hmmm... alright, Neela... thanks. I've got this. I'm on my way to work... I'll bang it out tonight.

Barry and Cath, that did the trick. Setting "Include IF NOT EXISTS clause" to false, got rid of all the dynamic SQL.

Matt, yeah, I'd already tried ALTER and that,...