Nice question, thanks.

Thanks for the question Tom, nice reminder of the basics.

Very interesting question, thanks!

My guess is that the collation SQL_Latin1_General_CP1_CI_AS doesn't support those characters.

There is a Turkish collation: TURKISH_CI_AS, but it can still have some issues:

Introduce the Turkish I issue

This one for the basics:

Microsoft® SQL Server® 2008 Analysis Services Step by Step

and this one for the more advanced stuff:

Expert Cube Development with Microsoft SQL Server 2008 Analysis Services

This is used to convert the column value to an integer, also called "integer division".

Table of operators

Since you are dividing by 1, this is basically a shorthand to convert the...

SSAS should always display all data, regardless of edition.

Perry Whittle (2/1/2013)

That's not entirely true.

If you have separate data and log drives and no backups and...

This thread has several solutions:

http://stackoverflow.com/questions/7243751/how-replace-all-spaces-in-a-text-file-with-one-character

Please do not crosspost, it wastes people's time and fragments replies.

Original thread can be found here:

http://www.sqlservercentral.com/Forums/Topic1414381-1291-1.aspx

If you put those on the same disk, there can be read/write I/O contention. If you seperate them, you remove this I/O bottleneck and performance will go up.

Also, if one...

OK, who used the word barcode in The Thread? Now we're being spammed!

Anyway, a hilarious blog post on how to create a file with SQL Server:

Umm....No...that is not how you...

Try assigning a datatype to your variables, you would get less issues like this.

Datepart returns an integer value, so tmm is of type Integer. In your concatenation, fileDate is implicitly...

Easy one (thanks Itzik! :-)) to end the week. Thanks!

You use a CREATE TABLE statement in an Execute SQL Task:

Creating Excel Worksheets Dynamically in SSIS

@dwain: you can use a script task to get the metadata from an existing sheet....