We need a lot more information to help you out here. Do you have traceflags enabled? Traceflag 1222 will output deadlock information into the error log. With that you can...

Uninstall would be through your control panel. You should be able to do that if you have adequate privileges on the machine.

the only way to understand what could happen is to test it. I've set up tests where I ran a set of procs against a database at 1x, 10x, 100x...

You're also only going to be able to shrink as far as you have space available. Unless you created an 800gb database and only put 400gb of data in it,...

I'm fairly certain that would have stopped execution of the maintenance plan. But the best thing to do is check. Have you run the maintenance plan before? How long did...

Ramón Ontiveros (1/11/2011)

---

By the way, I did work around this problem replacing the ITVF with store procedures, I don't know exactly way, but talking about performance, it's better a sp....

Is the slow down because of the INSERT itself?

If not, I'd say check the execution plan. If it's the same as the one you get when you run the function...

Darryll Petrancuri (1/11/2011)

---

I'm seeing a related issue in that when I try to use an ITVF as the source data for an INSERT INTO a table (using minimally logged operations),...

No. Not really. This is psuedo-code to describe the situation:

WITH MyCTE(...)

INSERT INTO MyTable

SELECT * FROM MyCTE AS x

JOIN MyCTE as y

ON x.ID = Y.ID

and x.Type=1

JOIN MyCTE AS z

ON x.ID =...

Yep. A CTE can be referenced multiple times inside...

JEFFREY SCHELL (1/11/2011)

---

I have a somewhat simple example with some followup questions on best practices:

- Let's say we have a Thing table which has two columns ThingID and ThingTypeID. ThingID...

I would not pick a varchar as my first choice for a clustered index... or my second. SSN's are not like GUID's because there is a structure to SSN. It's...

You can take a look at sys.dm_db_session_space_usage or sys.dm_db_task_space_usage. They might give you indications.

Ah, I'll bet postcode has...

WayneS (1/11/2011)

---

Jorge,

Might I suggest two things:

1. First, do not add things to master. Instead, create a database (named something like "Common"), and put all your special stuff there. Yes, you...