When you pull up the properties, click on the Files page. You will see where your .mdf and .ldf files are located there.

😎

You have an alter table in your post, so I have to ask, what are you trying to do? Are you trying to reseed the identity field? What...

want_to_know (4/17/2008)

---

Hi

I need to select last two characters of a field like the field has codes

Ex:

abcDE

cccDE

bbbDE

and i want to get the codes that has the last...

I actually like Pepper Jack! :w00t:

I have to say this is ridiculous at this point. A lot of good people tried to give you good advice. In this field, integrity and honesty are...

I use either of these two: 'yyyymmdd hh:mm:ss.sss' or 'yyyy-mm-dd hh:mm:ss.sss'

The first should work regardless of regional settings.

😎

You provided some sample data, how about showing us what you would expect the output of the query based on that data? It would help us in developing possible...

-- Personal Opinion

By lying to get a job you have shown a lack of honesty and integrity. Not the character traits I want to see lacking in this career...

Except for a little reformating of code (I made NO changes to the actual logic) I received no errors. Here is all my test code:

create table dbo.CoursePar (

...

Post your query, maybe we will see what's wrong.

😎

Matt Miller (4/15/2008)

---

Lynn Pettis (4/15/2008)

---

#1 is really a "it depends". If the number of 0's and 1's is about even, then yes the selectivity is questionable. I used...

Matt Miller (4/15/2008)

---

gkruchten (4/15/2008)

---

I was asked to develop some data base recommendations for the development team to reference. One of my recommendations was:

"Consider using BIT data type columns for Boolean...

Also out of curiosity, did changing the index have an impact on performance of the query?

😎

We have a linked server setup to access a MySQL database. The view that queries the MySQL database accesses the data with the following format: FROM MySQLServer...MySQLTable.

Hope this...

Just a very simple example using just 12 rows of data. Look at the difference between how they are sorted (i.e. stored in the index).

The first data set is...