zlika's

Very frequently we need to use the data type UTF-8 to store a data in different languages. As described in the MSDN page the UTF-8 data type is stored in the ‘Samples’ folder in SQL Server (Server\100\Samples\Engine\Programmability\CLR\UTF8String). You just need to activate it.

I’m starting a project for management of a small store, using C# and SQL Server Express.
Félicitations

Yesterday I was asked about the way a table is stored in several files in a filegroup.

As we can read in Books Online in SQL Server
Ranking functions return a ranking value for each row in a partition. Depending on the function that is used, some rows might receive the same value as other rows. Ranking functions are nondeterministic.
I have created simple example for usage of the Ranking function DENSE_RANK().

If you use Outlook 2010 and you prefer to have your data files on external hard drive, you have to point your file location as you add your account manually :-)

I’ve passed the Exam 70-431: Microsoft® SQL Server™ 2005 – Implementation and Maintenance (Transcript ID: 907652, Access Code: 38959BBD) on May 25, 2010 at Prometric Testing Center in Montreal. What’s next? Microsoft® SQL Server™ + .NET :-)
Félicitations

I was interested of the different SQL “accents”. According to Microsoft SQL Server learning books, we query like this:

SELECT
*

FROM
table1 INNER JOIN table2
ON table1.PK = table2.FK
GO