DavidL (12/5/2012)

---

...According to Myers-Briggs, INTJ and their ilk are relatively uncommon, something like about 5% of the population. It strikes me as significant that quite a number of posters...

ryetimothy (12/5/2012)

---

We're using Windows authentication...user listed (with permissions to our databases) labeled as tulip\CTAP_Professionals. There's no separate user for tulip\ctap. I was assuming the having membership in the...

talinkio (12/4/2012)

---

Is it possible to have a SQL Server instance, say SQLProd01, span multiple windows servers? Let's go with 3 servers each having 2 DBs but all linking back to...

ODBC settings are on each client computer. Go to Control Panel / Administrative Tools, and there should be an option called Data Sources (ODBC). From there, you should...

kaplan71 (12/4/2012)

---

...If I do a manual increase in size right now, and keep the auto resize turned on a failsafe option, that would provide the time

needed for the database,...

The two operators can't really be combined. Your best bet would be to use OR conditions instead of an IN function. so you would have:

WHERE ...

Are you saying that you are updating 1 record using the results of a subquery which is returning 3 records? In that case it really isn't definded which of...

What does the structure of the imported table and the view look like? I'm thinking depending on their definition, you could do your set based inserts either by using...

zeycus (12/4/2012)

---

...first I find the highest key with a

SELECT max(id) FROM TASKS

After that, given I captured that result in a variable id, I execute a

INSERT INTO TASKS

VALUES (id+1,...

another method, which is the one I use in a couple of production OLTP type systems utilizes Service Broker. The advantage with this is you can set the threshold...

david.williams 50026 (12/4/2012)

---

OK I have created a new Agent Job... and the 1st step calls the SQl Query "Blocked processes" which consist of:

SELECTCOUNT(*)

FROMsys.dm_exec_requests AS der

WHEREder.blocking_session_id > 0

What do...

Management Studio Express is the client-side tool that you can use to create, setup, and administer a database that is local or on a server. If you're asking if...

:hehe: I like that much better than Author in the comment header!

in looking at this, the complex root node Systems of the XML seems to be confusing SQL Server. If I make the root node just <Systems> instead of <Systems...

There my not be enough information here for people to help you. You say the CPU spikes at 50%, that doesn't seem too bad, as long as it isn't...