What is the collation setting for the column and then again for the database? If you explicitly define the proper collation in the where clause does it work in...

Unless you are on SQL Server 2005/2008, or you were tracing the server already for the last week, you can't look back in time. On SQL Server 2005/2008 if...

Jasper uses the webservice extensions for Reporting Services which are self documenting in the SOAP output.

As my coworker jbwillia pointed out, it doesn't support case insensitive collation databases like Adventure works, and it also fails for databases like the Sharepoint Admin databases which are installed...

Rudy,

If this is intended for SQL 2005/2008 why are you using legacy views like sysdatabases and sysfiles in the code. You also are not using the schema qualifiers in the...

I would have missed that @@datefirst part. Nice example Jack.

Have you looked at the Reporting Services Scripter by Jasper Smith:

http://www.sqldbatips.com/showarticle.asp?ID=62

Not trying to be funny, but you are kind of reinventing the wheel, you just probably don't realize it. ...

RBarryYoung (12/19/2008)

---

IMHO SQLCLR only outperforms T-SQL in two general cases:

1) In cases where the same activation path must be followed by both (Triggers, Service Broker activation procs) then CLR...

This is the kind of problem that a calendar table is good at solving, and not a function.

http://www.sqlservercentral.com/articles/Advanced+Querying/onthetrailoftheisoweek/1675/

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

On one of the car forums I am a member of for classic mustangs, they have this say "This post is worthless without pictures."

I guess I could morph that to...

It uses OLE Automation to call the CDOSys COM objects and can send it directly to the mail server. I believe that if you change the configuration in the...

When you partition the data, you partition it along set data boundaries and not by rows. For instance for E-commerce data, you could partition it on month boundaries, or...

This is a known issue on really small tables. In some cases the fragmentation will actually go up after a rebuild. I have a bookmark at home that...

Lynn,

I have installed it onto two x86 servers with no issues so far. I have a x64 QA server I can apply it to later today and let you...

I would write a .NET application that reads the SMO feed of a trace and watches for the thresholds to be passed, or upgrade to SQL Server 2008 and use...