GilaMonster (11/10/2011)

---

If you haven't monitored, then you have no grounds for a decision either way. These kind of things shouldn't be guesses, they should be informed decisions based on solid...

I have not personally monitored this, it was something...

What do you guys and gals think about this statement from my boss:

"We gets tons of new data quickly, statistics became obsolete quickly; when that happens, query optimizer is waiting...

gksharmaajmer (11/9/2011)

---

Hi,

I am working with my friend on his vb project regarding schedule task assignment. Managers will assign some different types of scheduled task to different team members, so...

Dev @ +91 973 913 6683 (11/9/2011)

---

Joy Smith San (11/8/2011)

---

Windows task manager you mean....

Joy Smith San (11/4/2011)

---

Hi All,

Below was an interview question 🙂

Suppose there are 4 instances in a server.

How can we find a particular process id belong to which instance ?.

Thanks...

1. Did you check to make sure there was not another named instance?

2. Did you try attaching the mdf files to the new instance? EDIT: I guess you can't do...

Think of it this way, as a Microsoft rep once told me... If a user or a machine directly or indirectly touches SQL Server, it needs a CAL. A great...

Jeff Moden (11/4/2011)

---

A lot of these problems can be resolved by importing into a staging table using BULK INSERT with OPTION (MAXDOP 1) set. You shouldn't import directly to...

Attopeu (11/4/2011)

---

Hi All,

Thanks for all your reponses. I know for sure OLAP Cube is not the solution here because we are making changes on existing reports. My very concern now...

Glad to get to a solution 🙂

Jared

Great, now go back to the same link I gave earlier and look at days 6, 7, and 8 in the series. Focus on day 8 first. You...

I can't understand exactly what you are doing, but I know for a fact if you physically map the drive you should not have issues. As I have done this...

Lynn Pettis (11/3/2011)

---

Remember, TempDB is used by all the databases, not just for temporary tables and table variables, but also for queries that require sorting (ORDER BY, DISTINCT, GROUP BY)....

We were all noobs once. 🙂

Jared