opc.three (7/2/2011)

---

Lynn Pettis (7/2/2011)

---

As far as when the compatibility views will go away, Microsoft doesn't always tell you. I haven't load Denali, so I can't say if they exist...

PS This is fresh in my mind due to another spirited thread but here is your query to look at execution use counts rewritten to use the current set of...

I am not an expert but figured I would kick off the conversation.

I want to know the root cause too but I will still say that SQL Server is not...

The only justification I could see for avoiding cross-database calls is to leave the option open to scale out at some point down the line by moving the Staging or...

I don't have anything concrete in mind as to why it could be happening but I am curious, which statement fails with "table not found", the INSERT INTO or the...

Any error messages?

Why do you need to create it with UNSAFE? What is it doing that is causing you to require that setting?

Also, just because its created with UNSAFE does not mean...

Direct replies here: http://www.sqlservercentral.com/Forums/Topic1135468-391-1.aspx

You could attack this using basic string replacement but I would not recommend it.

The proper way IMO is to do...

See section "Data mining by using transportable shadow copies" here:

http://technet.microsoft.com/en-us/library/ee923636(WS.10).aspx

Using CDO for mailing is from the SQL 2000 days. Please consider the Database Mail subsystem to send email...

Shamshad Ali (7/2/2011)

---

...

Following is the no. of records in each table./

select count(*) from users -- 306940

select COUNT(*) FROM UserProfile -- 173958

I am running following simple query which is...

as2higpark (7/2/2011)

---

Also wanted to add that we are seeing the CPUs (average of all 24) spike to around 50 - 70% sporatically throughout the work day. The spikes generally last...

GilaMonster (7/2/2011)

---

opc.three (7/2/2011)

---

Bummer. The article is still relevant. Please see the section titled "Recompile". Adding the option to your query will cause it to be more expensive than would otherwise...

Lynn Pettis (7/2/2011)

---

As far as when the compatibility views will go away, Microsoft doesn't always tell you. I haven't load Denali, so I can't say if they exist there,...