Are we good or what? just by posting here you get the...

Can't you join both tables and filter by ActiveStatus = 1?

mister.magoo (7/1/2011)

---

That sounds like an amazing project - please tell us the name of your product so that we can keep an eye out for it. Not to avoid it...

sqlquest2575 (7/1/2011)

---

I need to delete a column from a table that has 30000 records and it should not effect the performance now would like to know your expert opinion on...

rgtft (7/1/2011)

---

That's what I thought; I was just wondering if there was some behind...

rgtft (7/1/2011)

---

Is there a way in SQL Server to get the number of records in a SELECT that has a TOP clause. That is the total number of records...

MuskaanGoyal (7/1/2011)

---

I agree on this but my senior is not understanding the same thing. He told me that same is possible in Oracle using TOAD. Meaning we can restrict DBA...

raistlinx (6/25/2011)

---

You sold me the rights to use your software. I can't resell it, but I'm damned well sure I'm not going to let it blindly thrash around in...

vinod.saraswat (7/1/2011)

---

I have db on developement server. If i check for the properties the collation is Case Insesitive. If I go into the tables and check the propery in SSMS...

In my opinion nothing beats official documentation by the vendor; here http://msdn.microsoft.com/en-us/library/bb522673.aspx

Just building on previous comments here is an example of how to use DMVs. The beauty of this particular example is that you may use the created applet for years...

sqlquest2575 (7/1/2011)

---

Hello Friends

I am migrating MS access Db to SQL 2008 and I am using SSMA to accomplish this task. But I’ve couple of questions.

1. When I run ssma...

Sachin4all (6/30/2011)

---

for a single product instead of updating a single field in a row its creating a new row for the same product.But here we are not keeping any...

Bruce W Cassidy (6/29/2011)

---

Bulk insert will work fine for getting the data into SQL Server; the trick is getting the data out of Oracle quickly.

The "Disconnected" Model

Look at using the...

That's not true. Ora11g credentials are case sensitive by default.