If it’s in the record, you should accept it as it is. Isn’t it valid data in business terms?

For example, a csv or xls can have a memo / notes...

Just trying to help. Thanks for the appreciation...

As Paul already said, delete on source doesn’t...

This should be helpful...

Replicating Partitioned Tables and Indexes

http://msdn.microsoft.com/en-us/library/cc280940.aspx

I am trying to guess the reason for Jeff’s question. I received few csv files from customer couple of day’s back, that had similar structure. It was a result of...

Please read my post again.

Run the given query, you will find there are NULL values in productsubcategoryid.

Your query is grouping the data based on productsubcategoryid thus there is a group...

Please ask precise question. What is your SQL problem & what you tried & where are you stuck? With all due respect, your previous post is a candidate of SPAM...

select *

from production.product

where productsubcategoryid is null

ProductSubcategoryID has NULL values in Production.Product table.

Per BOL:

Null values are treated as the lowest possible values.

For More: http://msdn.microsoft.com/en-us/library/ms188385.aspx

I assume you want to dedicate 64GB only for SQL Server operations & even if OS / other application needs, it shouldn’t release. Am I guessing it right?

Per Lutz explanation,...

Nope. See the screenshot...

Apologies, I misread ‘DB for Monitoring’ as 'DB Mirroring'.

With the sample data & DDL that you shared with us, it’s difficult to come up with good solution. I agree with above recommendation & join them to suggest you...

Database Mirroring, 12 GB log files, Full Recovery Model, 6 hrs Log Backup & low disk space cannot go all together.

As everyone already pointed out, you must set up the...

I don’t find any issue in your script. It works fine on my system.

declare @columnlist nvarchar(max)

set @columnlist =''

select @columnlist = @columnlist + cast(column_name as varchar(128)) + ', '

from information_schema.columns

where table_name...

Gray screen on RDC indicate either server is heavily loaded or got hung. In either case it’s bad. If server downtime is acceptable for sometime, a restart might give you...