Right. You will notice by looking at the top of this page that this is a SQL Server 2005 forum.

The irony of course is that Report Generators are supposed to isolate the end-user from technical issues like this so that they do not have to know about them. ...

Exactly right, Tony. Using statistics like these as diagnostic metrics or even as change indicators is fine within the context of knowing what is normal and/or expected. But...

Overall, I think that I would have to agree that Bitwise aggregates really would be a useful extension to SQL Server, especially if the bitwise operations would fully support binary...

Just out of curiosity, I tested both of these methods across a million rows:

--====== Stats Off

SET STATISTICS TIME Off

SET STATISTICS IO Off

GO

DROP TABLE #SomeTable

GO

--===== Create the test data

...

OK, here is the Set-Based solution, using Jeff's data setup (I also stole Jeff's other two tricks for compactness):

--===== Create the test data

-- (NOT PART...

JohnG (12/24/2008)

---

The solution implemented (pseudo-cursor) is working quite well in our application. But I always had this thought in the back of my mind that there was some algorithm...

Yes, like Seth, I suspect the transmission time. It's either your network or your Client that is too slow for that much data, not your SQL Server.

This highlights a...

It would be interesting to hear Microsoft's take on this error message though. I have some theories as to how Serializable Isolation + Logon Triggers could lead to this...

Ah, I see, I misunderstood the...

samsqlserver (12/22/2008)

---

I am wondering how you can write a trigger that would be fired before inserting/updating rows into a table.

If i am not wrong a trigger will fire either after...

Honestly? I felt a disturbance in the Force.

Are we talking about UDF's or builtin functions? as far as I know, the only overhead that the builtin functions have is the CPU cost of their actual calculations.

Ah, I see.

They were probably talking about query hints to force the use of a particular index.