off track I am afraid.

1st one does it for partitioned tables

and the others dont answer it either.

the op wants to know which file in a multiple filegroup scenario contains which...

sethhersh (9/2/2009)

---

All -- I should add that the Contractor I am speaking of is publicly traded company, has 1,000+ employees ... so my thinking is that they would have the...

ok fair enough, Now I have to look into it, purely for my own curiosity now

Normally Intel processers are more expensive, if you have web farms and if you want to virtualise at any time, you might be better off sticking with one type of...

Steve Jones - Editor (9/2/2009)

---

Some developers are knowledgeable, I'd agree. But the majority focus on what they do well, build applications. And they forget that the db is more than...

sethhersh (9/2/2009)

---

I have just joined a company as their DBA to oversee a database and .net application currently being developed by an outside contractor. It will be a web-based application,...

not sure if it helps but i think that if you create a clustered index or recreate it on a different Filegroup. the data is moved as well

SQL ORACLE (9/1/2009)

---

Has anyone come across this error?

The OLE DB provider "ASEOLEDB" for linked server "XXXX" reported an error. The provider ran out of memory. [SQLSTATE 42000] (Error 7399) ...

I dont have a problem with helping you. But daily checklists apart from the usual server checks and checking for failed jobs, failed logins and performance issues, are very different...

thinknight (9/2/2009)

---

I could not establish mirroring with certificates,

I declared certificates to principle, mirror and witness

Then just defined certificates on mirroring endpoint

At last, I want to setup mirroring again but,

My principle...

Right OK...

All I am...

I see you have posted on the IBM sites as well 😛 with no replies....

I dont buy it either, we used tivoli at a previous client and that had email...

shanila_minnu (9/2/2009)

---

I tried restoring adifferential backup on a database.But at the final stage it throws an error like

"can't associate files with different database"

Again wen i tried it is keep on...

As CirquedeSQLeil has already said, if you know how to disable the trace flags and are confident enough to reapply them if you need to, then disable them. noone here...

Sourav (9/1/2009)

---

-- How to get the entire blocking details in the backend server..?

Using sp_who2 'active', may huge huge list of log-in credentials..but all of them actually are not creating the...