BU69 (11/29/2010)

---

A quick question:

Would anyone ever use platespin as a DR solution for SQL?

Is it better to use SQL mirroring or would anyone use a different technology?

example of setup:

2 servers,...

d.qureshi (11/29/2010)

---

I have a SQL Server 2008 running on Windows 2008.

The main database is located on the D: drive and the total capacity of the disk drive is 435GB....

Joseph Fallon (11/29/2010)

---

I've come up against a REAL head scratcher when trying to get a simple expression working as an SSIS variable.

Here's the expression for the variable

datepart("dw",getdate())

On my dev...

...and probably had to substantially rewrite them, don't you?

Devil is in...

soundlogic (11/25/2010)

---

... I created a little bit of a "LINQ to ORACLE" language via lambda expressions which meant that I really didn't have to do much more than swapping the...

soundlogic (11/24/2010)

---

I just want to make sure nobody misinterprets this as equally applicable to database developers. I've developed with ODP.NET and making sure to use the dependency inversion principle should...

pradeepniitdln (11/16/2010)

---

plz give me good suggestion for create a databse design for social networking site like orkut.. howmuch the table, what's type of relationship beetween tables....

I...

May I ask why why? 😀

... not...

Matthew Lang (11/16/2010)

---

Maybe you could shed some light and add your opinions here.

(Background)

We have a production database instance, hosting the databases for our booking engine (tourism). OLTP 24/7 availability

Now altogether...

Different instances, different binaries - no issues per-se.

As far as I remember OPENQUERY relies on OLEDB provider.

OLEDB provider can be setup to transfer data in two formats which are: compressed and uncompressed.

Since compressed is the default value...

OracleWho (11/12/2010)

---

In Oracle, when you declare a variable or parameter in a procedure, you can set the datatype to be the same as a specific column (or even a row)...

bickling77 (11/12/2010)

---

Prove it ...

CrazyMan (11/12/2010)

---

I am trying to create a partition table, we have a table with a column ID and a column for datetime, before Partition the table has got a clustered...

Deepthy (11/12/2010)

---

create table GEO

(supplied_Adrressline nvarchar(100),

Clean_country nvarchar(100),

Clean_city nvarchar(100),

clean_region nvarchar(100),

clean_postcode nvarchar(100),

clean_addressline nvarchar(100)

);

insert into geo(supplied_addressline,clean_country,clean_city,clean_region,clean_postcode)

values ( '17 churchstreet 7000','Australia','Melbourne','ME','7000')

('10 Downing London HA2 9DR Street','United Kingdom','London','COF','HA2 9DR')

...