Just be aware that this approach - also known as poor's man partitioning - is not as efficient as real partitioning is.

This approach allows to simulate table partitioning handling "partitioning"...

I would start by researching varbinary datatype.

Glad to help.

On the other hand, nothing is more scary that knowing neither the root cause of a problem nor why the problem went away 🙂

:blink: "because of the default...

paul.ingham (7/2/2010)

---

...am wondering if i can have a Policy Transaction fact who's granularity is an individual policy line from the policy table and also have a policy dimension from the...

So ... what would you do with a FACT table that has 48 FKs? location is inmaterial/

To test client please...

1- Ping target host - if you can ping it you can access the box.

2- Edit tnsnames.ora file located in ORACLE_HOME/network/admin adding an entry for target database.

3-...

You may want to consider hiring a temp DBA, work with him/her in this project and take advantage of...

Arie Jones-435881 (6/29/2010)

---

Not exactly true. There is a little translation going from Oracle to SQL Server. It does depend on wether you are comfortable with the current setup. So if...

I would start by comparing SS2K5 and SS2K8 features, plenty of documentation on such matter like in http://www.extremeexperts.com/SQL/SQL2008/SQL2005Vs2008.aspx

I cannot see a "Final" row for 101...

Have you already built a home lab? - installed SQL Server at home?

In the affirmative case check Books On Line a.k.a. BOL - it comes with the software.

If I remember it right IDENTIFIER_CASE property refers to names of Tables, Columns and Procedures therefore SQL Server is doing what is expected to do erroring out when a query...

Steve...

sudhakara (6/30/2010)

---

Can you suggest me the best way to send a alert message when sql server has been stopped for log time ? example by using the another sql server...