BlueIvy, that is a common problem when you have Performance monitor open and you are currently monitoring that instance. A restart of...

One idea could be to use a tmp table where you insert your result from your inner join and then delete the results you do not want...

Hello!

Yes, of course you can!

Example: bcp "SELECT * FROM Northwind.dbo.Products WHERE UnitsInStock <= 10 " queryout myOutFile.DAT -T -SmyDBServer -n

Happy computing!

Hanslindgren

Okay, then I see. But you say you have a production server 24/7 with bad development happening? What are the developers doing in the production DB in such an enviroment?...

Ciao tjaybelt.

Have I missed something? But why are you comparing the values to yesterdays values when you are checking the fragmentation level?

Where did you read this warning?

//Hanslindgren

Or just open up BOL, goto the DBCC SHOWCONTIG help and Copy and Paste the code under E. Use DBCC SHOWCONTIG and DBCC INDEXDEFRAG to defragment the indexes in a...

Hello!

I think we are not seeing the forest because of all the trees Why not ask your developers to NOT drop and recreate...

SQL Server 2000 does support partitioning, but not in the Oracle sense (yet).

In SQL Server partitioning consists of one table for every partition, a check constraint (OBS be sure to NOT create the constraint with...

Could it be a bug? I have heard about some deadlock issues with DISTRIBUTED partitioned views. That the underlying provider is doing something extra in a bad way.

//Hanslindgren 

I definitly agree with David, using a view would solve your problem in a fast and very simple way.

//Hanslindgren  

Why not partition it monthly?

I.e create one table per month, create a check constraint on the table that restricts the data and gives a HUGE performance gain, create a VIEW that...

If the table does not exist I would:

SELECT TOP 0 *

INTO NewTableName

FROM TableName

INSERT INTO NewTableName

SELECT *

FROM TableName

(There are annoying locks being held in tempdb (That blocks/hangs for example SQL Enterprise...

Hello!

There is a great tool the is called XSD (.exe) that comes with the .NET Framework...

Happy hunting! Hanslindgren

- Range Scans and Inserts

If your table contains a huge amout of columns your range scans can be very costly and in some cases Non Clustered indexes can be beneficial.

(Inserting into a...