brandon_ledbetter (7/13/2010)

---

I've had a similar problem that I have been unable to 100% identify. In my case, they are all parameterized quries that will be running subsecond in prod...

You're not using standard syntax for the...

You need to do three more things. First, you should also monitor the wait states and queues on the system so you know what is causing things to slow down....

shivanee.chikhalikar (7/13/2010)

---

Hello all,

I am adding the foreign key using the following query

ALTER TABLE RepairCategoryDetail

ADD CONSTRAINT FK_RepairCategoryDetail FOREIGN KEY (CategoryId)

REFERENCES RepairCategoryMaster(CategoryId);

But it is giving me an following error

There are...

It completely depends on what events and columns the trace is collecting. Most people are running very benign traces capturing RPC & Batch Completes with only 8-12 columns of data....

Jason Shadonix (7/13/2010)

---

Now, helpful bit out of the way, I'm not going to laugh at the network engineer getting stuck with the DBA job, that happens, but I will laugh...

phil.cooper.2 (7/12/2010)

---

Alcon:

I am a LAN/WAN/desktop network engineer. The company I presently work for seems to think that database work falls under that scope.

Go ahead- I'll wait for the jeering, laughing,...

ibzmiller (7/13/2010)

---

Hi,

Yes plenty of testing ahead. No I don't think there are any clustered indexes. It has just been a matter of, theres a table. No consideration on how...

Novicejatt (7/12/2010)

---

Hi

I do not want to use SSIS yet. I'm only working with SQL queries. Say I have a table with fixed no. of columns. I want to schedule a...

Novicejatt (7/12/2010)

---

Hi,

Since the file name and the columns changes everytime, So it will only run for one time. So how do I load multiple files each...

Yep, not a problem. SQL Agent is the built in scheduling tool for SQL Server. Create a job there, you can create one or more schedules for the job and...

ANSI_NULL and the rest are connection settings. If you want procedure properties you can look at the system view, sys.procedures.

Microsoft frequently will give you limited time access to a server online for training purposes. Go here and check it out.

Yeah, I was going to say, killl all the other connections so the...

shayy (7/12/2010)

---

From what i've understood so far, when using * the index doesn't matter but if i'll use exact

column, then an index on that column can help.

Thanks a lot for...