Srinath Mohan (9/1/2010)

---

hi All,

I am trying to setup a SQL replication on single point of failure in cloud environment (Amazon EC2).

I need some good tips and multiple options to do...

Mark Harley (8/31/2010)

---

We have a single oracle database on our servers, and we want to bring it into sql server so we no longer need to support oracle. Is...

Cristian Maidana-360609 (9/2/2010)

---

Hi, i was trying filtering a query with an alias, but it doesn't work

select a,b, (select count(*) as Tot from table2) as Tot

From table1

where (Tot > 0).

but the...

shaun-744740 (9/1/2010)

---

Hey, thanks very much for the quick response!

Maybe this will explain things a little better-

The company initially had a list of 200 engineering components, easy to find...

No, it is not. Table Partitioning is an Enterprise Edition feature.

If really need it you can always resort to poor's...

shaun-744740 (9/1/2010)

---

Based on contents of a 'Description' field - Whats the best way?

They all have 'different' descriptions, but they have keywords, is there a quick way to find out what...

Stefan Krzywicki (9/1/2010)

---

PaulB-TheOneAndOnly (9/1/2010)

---

Stefan Krzywicki (9/1/2010)

---

I have tables partitioned by year, they are large tables. The filegroup they're on is large, but not inordinately so, around 60 gig. I'm trying...

Stefan Krzywicki (9/1/2010)

---

I have tables partitioned by year, they are large tables. The filegroup they're on is large, but not inordinately so, around 60 gig. I'm trying to create a...

ssandeepv (9/1/2010)

---

I want to lock a database and restrict access to all the users. Is there any sql query so that any user can run it and the database opens...

blondie (9/1/2010)

---

Hello, will having multiple inserts hitting a single table at once cause an issue? I think sql will lock the table during each insert statment...but as long as...

NEAL-464478 (8/30/2010)

---

well, i dont make rule, i am the slave of my master. So master wants me to make something like a table pick first 10 records from unknown...

mike-939611 (8/31/2010)

---

I get the feeling I am trying to get something to work in a certain way and that way isn't the way the the database is mean't to work;...

For starters,...

cpinky01 (8/28/2010)

---

I have sales type and under which i have

sales for diff products

and Calims under which i have different types of claims

like this:

1.Sales

a. ...

Nice. I...