Search Results

Partitioned View Performance Problem

Thread by: Negative, Aug 25, 2004, 1 replies, in forum: T-SQL Performance Tuning for Developers

I have a partitioned view for a group of 10 tables. The partitioning works for the most part. I can update the view, when I run a static query the...

SQL Compare... with DLL?

Thread by: Negative, Jun 7, 2004, 2 replies, in forum: Third Party Tools

I have been testing RedGate's SQL Compare Toolkit, and like the ability to develop my own interface for the product, and integrate it in to a single...

Website articles

Thread by: Negative, Nov 4, 2003, 2 replies, in forum: Please Tell Us What You Think

Is it possible to display the date that articles on the website were published? It may not be a big deal now, but as time goes on it may be be...

Partitioning Column

Thread by: Negative, Oct 14, 2003, 4 replies, in forum: General Developer Questions

I have a very large table that I want to break out into a partitioned view. The table has a surrogate, non-clustered primary key, and a clustered...

Internal SQL Server error... Any ideas?

Thread by: Negative, Sep 18, 2003, 8 replies, in forum: General Developer Questions

I have a query that I have been running on a regular basis for several weeks now, and just tonight I got a page that the process that calls it had...

Weird problem involving nulls and counts

Thread by: Negative, Apr 1, 2003, 6 replies, in forum: General DBA Questions

I have a fairly large database that is currently sitting around 200GB. Most of the space is used by 1 larger table, including it's indexes, that...