Bk (9/22/2008)

---

Thanks for the great article, Carolyn!

Shouldn't it also be possible to use native Windows functions to compress and uncompress groups of files into .zip-compatible archives? NOT "compress" like...

Way to go guys. A well deserved award for two amazing contributing posters/authors. 🙂

This solution can easily be handled via a derived table, cte or the over clause. The below example already has the first set of counts in place, so you...

The problem is the import process takes a look at a small sample of the data in the column and makes a judgement as to what the data type is....

Can you post a sample and the solution you came up with? This will benifit others who may run into the same problem.

What does the date look like when it is imported?

Matt Miller (6/18/2008)

---

I usually end up handling that in the outer select. Meaning - once the PIVOT has been done.

Something like:

select locationname,

...

Did you forget to post the on clause of the trigger, or do you not have one?

For the trigger part why dont you peform a check before running the CTE?

CREATE...

You may want to make multiple data files and spread them accross different luns. Best practice suggest .25 files to every processor.

Also, I would put the tempdb on another...

A few things you can check. I know you said you rebuilt your indexes, but there are a few other things that you can try to resolve this issue....

This function may help you out. It will resolve all capitals in string that are not in the beginning and will capitalize

the first letter of every word passed in.

CREATE...

You need to add a begin and end to your while statement. This may or may not resolve the issue, but it should be addressed.

You have to use the code in the expression editor. You have to view the properties of the object you want to use the expression in. Click the...

You should make sure the service accounts have access to the directory. The service accounts are SQL Server and SQL Server Agent.

Windows does not have a command line utility to unzip files. You will...