JQAllen (2/29/2012)

---

Have you experienced the need for analyzing data temporally in your business? Do your existing information management systems allow you to view historical data? Typically, when you update or...

It all depends on data volatility and business requirements.

Two examples.

#1 - If you have a production database that gets updates once a day then setting that database to...

You are correct, question is a bit generic and exposes very little backgroud on the specifications therefore is a bit hard to guess.

Either way, is this an OLTP system?

In the...

marly (3/12/2012)

---

ColdCoffee (3/12/2012)

---

Bro, when u see a empty string in the Frist Name text box (or wherever the value for @FirstName comes from) , handle it. Tell the user that...

sufiyan.sarguroh (3/12/2012)

---

Say i have db1 and db2 .

I want the tables uder db1 to be availaible in db2. Import/Export is one option. Can restore db also be used in...

Did you increase the datafile size or did you allow SQL Server to extend datafile up to...

I agree with Jared. Partitioning is not intended to be a solution for query performance but for data administration, like helping during archiving and purging processes.

mupparaju78 (3/6/2012)

---

I have Simple Oraclae query..

its take long time while run the query if we Don't have any data in table beetween date.

if we have data between dates.. got...

robert.baird 2778 (2/28/2012)

---

I am in the process of migrating from oracle 8.1.0.6 to sql server. I am trying to use the SSMA (version 2, I tried 4 and 5 and...

Make and unique index in such a column then handle the exception properly so to return a more polite message to the user - an alternative would be to do...

Not sure if I got the specs right but, try this:

(ISNULL(DT_I4) ? "" : DT_I4) + (ISNULL(DepartmentID) ? "Unknown" : DepartmentID)

Research Point-in-Time recovery which includes having the target database in Full Backup Model, taking both Full and Transaction Log backups.

Also check tail-log backup.

loki1049 (2/24/2012)

---

I also thought maybe it was not using the index. Is there a way to force a view to use an index? I remember something about a HINT keyword...

GilaMonster (2/24/2012)

---

PaulB-TheOneAndOnly (2/24/2012)

---

Opus (2/24/2012)

---

That's what I was thinking should work but it didn't. I just come to find out some of the teacher names were entered with spaces. ...

Check execution plan ... is it taking advantage of index on SamplingDate column?

Are your performance statistics on base table up-to-date? if performance is decreasing as time goes by chances are...