dwain.c (4/7/2014)

---

In truth, I haven't gotten around to running a test with a filtered index. While I intend to before I do anything about the Prod system this is...

Just noticed, you have the NOT NULL directly in the WHERE clause in your blog post.

Hi,

thanks for the post and only a few comments.

You do not need to write CTE to get index seek in your case (where you have a lot of sparse data)....

I've also made a comparison of the CLR methods when using parallel vs forced serial plan. I run it on my Core2 Quad 2.5 GHz. and the CLR beneffits a...

Jeff Moden (10/7/2010)

---

Zounds... not sure what just changed but I used your script exactly and I'm coming up on 10 minutes on my 2k Box. I've got the Actual...

I'm running 2008

Jeff Moden (10/5/2010)

---

If you want (don't worry about the CLR side... we know that's good), post all of the code YOU are using to setup the test, the function, and...

Jeff,

my default collation is Czech_CI_AS, but I've tested...

Jeff,

you are right about the data types, so I've modified the nvarchar to varchar in the test data generator and make a comparison of the Split8KTallyM vs. CLR RegEx....

Jeff,

I've done some testing about this also on my machine, but instead of the XML version I've tested the CLR RegEx solution.

Here is the source for the RegEx CLR Function

public...

For such scenario is the best choice the SQL Server Auditing, but this is available only in SQL server 2008. (you can see description here http://msdn.microsoft.com/en-us/library/cc280386.aspx

For SQL server 2005 or...

Hi,

Aron Bertrang may have something you may be interested in on his sql blog http://sqlblog.com/blogs/aaron_bertrand/archive/2008/05/06/when-was-my-database-table-last-accessed.aspx

The script could be compatible. Depends whether or not you use syntax available only in SQL Server 2005.

If yes, then it will not be compatible with SQL Server 2002....

Hi,

the packages are stored in the [msdb].[dbo].[sysdtspackages90] table. The source xml of the package is stored in the [packagedata] column as image.

If you want to see the source XML of...

On what version of SQL Server you are running the query? It...