You will need to use BCP with a format file. That way you can specify which columns are quoted and which are not. The format file has a way to...

Brandie Tarvin (9/26/2013)

---

Do not, under any circumstances, put them on the same DBs / same instance regardless of what services you are providing. It will be a maintenance nightmare, not...

the row size appears to have increased commensurate with the size of the three nullable columns you added so that sounds consistent. Do me a favor and run DBCC...

well if you are getting 23 rows per page and you were getting 60, the reason has to be a combination of fill factor and adding more columns. Post...

What was you fill factor for the clustered and non-clustered indexes?

Yeah, you need to determine:

1) how much memory is available on your server (or VM)

2) what other processes or programs are running on that server

3) max (and min) amount of...

We do month end processing all the time (banking). So what I usually do is this:

declare @LastMonth datetime

declare @thisMonth datetime

set @ThisMonth = convert(datetime,convert(char(6),getdate(),112) +'01')

set @LastMonth = dateadd(month,-1,@ThisMonth)

then all my data...

Okay, now I understand what you mean. Well for one thing there could be a different query plan being used in the import wizard implementation because the query is running...

I'm shocked... shocked to find out government has been spying on us!

I'm not...

I basically do the same thing except multiple times per day. I have a .net program that pulls the data via a stored procedure and builds the pipe delimited data...

you could either use:

select top(0) * from TABLE

or you could use a where clause that would never return any rows:

select * from TABLE where 0 = 1

My bad... your count()'s should be sum()'s (I missed that the first time):

select coll,

sum(case when coll is not null and value is not null then...

it is actually pretty straightforward :

update table set varcharcol = ltrim(rtrim(varcharcol))

Try it like this:

select coll,

count(case when coll is not null and value is not null then 1 else 0 end) CntCol,

count(case when coll is not null...