Run this:

select name, log_reuse_wait_desc from sys.databases

What does the log_reuse_wait_desc say for this particular database?

SQL Learner-684602 (11/10/2009)

---

Hi

I am having an int column of length 8..

i have to convert it to Latitude/ longitude value bye using rule-

divide by 10 to the power 6..

but as...

From BOL:

6 = Replication

GilaMonster (11/10/2009)

---

Don't think so, but it's heavily weighted to the lower end.

There are 15 people...

I have found the "quirky update" useful when helping others who needed to capture and update intermediate results along with the final results of a calculation.

It helps break down the...

Hmmm, force is weak. See what you see I can't.

It would help if you provided us with more information. Based solely on your post, it is extremely difficult...

EK rook (11/10/2009)

---

Hey everbody,

I have(or better yet tried to) create a cursor which acquires data from a table created from the union of two other tables in the same database,...

Didn't even need to see the picture to know what it was ... 😛

Interesting image, pork chops wearing kilts ... 😛

Posted several questions that may be relevant to anyone thinking about bidding on the project (I might even bid on the project).

From what I saw in your pictures, the files...

And if it is decimal, how is it declared?

Jeff Moden (11/8/2009)

---

Lynn Pettis (11/6/2009)

---

Jeff Moden (11/6/2009)

---

Lynn Pettis (11/6/2009)

---

What? No comments on the sample code I provided? I really thought you'd have more to...

Jeff Moden (11/6/2009)

---

I'm not done...

What? No comments on the sample code I provided? I really thought you'd have more to add. 😉

lmeinke (11/6/2009)

---

Hello All,

I have a query that uses 6 joins to produce a results set. It is in the form of:

Select A.field1, B.field2, C.field3, etc....

From Table A

Inner Join Table...

Just because you have indexes on the tables doesn't mean they are the right indexes. Looking at the execution plan can help you determine if the indexes you have...