In which files does actually SQL Server store data?

Question

In which files does actually SQL Server store data?

sudhirrsingh.parmar

SSC Enthusiast

Points: 130
More actions
November 26, 2008 at 10:43 pm

#215887

In which files does actually SQL Server store data?Can we have a different collation for database and table? Thanx in advance.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

brainy SSCrazy Points: 2445 More actions · Answer 1

It will store the data in a mdf file, you can find the path the file by right click on the database -> properties -> Files .. there you can find the path of the mdf file as well as log file.

For your second question ... YES I think.

regards

Kolivad

Cath Trimble SSCarpal Tunnel Points: 4201 More actions · Answer 2

Hi,

Yes, you can have a column with a different collation from the table, but it can be problematic, especially round tempdb in my experience (though not my database). Look up 'Collation' in BOL. Kimberly Tripp has blogged on 'Collation Woes' too.

Cath

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 3

Heh... looks like homework questions answered without the OP even trying. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)