Has anyone else ever heard that it is a best practice to have enough server memory to hold your entire database in memory?

Adam Bean (1/21/2014)

---

Hey Lynn, it's not the act...

Can you post the links you have that relate to reindexing causing duplicate records? I have never experienced this issue.

Welsh Corgi (1/18/2014)

---

Lynn Pettis (1/18/2014)

---

Welsh Corgi (1/18/2014)

---

Lynn,

I had to drop the database and restore. Basic syntax.

I think the problem was that they did not stop the SQL Server Services before...

Welsh Corgi (1/18/2014)

---

Lynn,

I had to drop the database and restore. Basic syntax.

I think the problem was that they did not stop the SQL Server Services before they started the Windows...

rabih_karam (1/18/2014)

---

I think we need more clarification about your case

But i have a solution for you as i understand from your question

Declare a table and then select your column...

Post what you have tried so far to solve your problem.

Could you post the full restore command you used?

Restoring or Recovery? Just want to be sure.

Can you provide more information regarding the database? Is it the target of log shipping or mirroring?

Not sure what you are asking here.

Actually depends what you are attempting to accomplish....

SQL33 (1/17/2014)

---

Your ingenious method returns the dataset I need.. but doesn't allow me to update any data in the resulting dataset. What info can I provide to help...

Sean Lange (1/17/2014)

---

No idea what your table name is called or what you are really trying to do here but maybe something like this? (Assuming your table name is #Something)

Select...

Sounds like the code could use tuning. Unfortunately you have provided nothing with which to work with in this regard.

Please read the following article and follow the steps in...

Actually, that is what you want.

You will need to analyze the data to see if there are dates that...