Where? When? I don't know what you're talking about.... again

Alvin Ramard (7/15/2010)

---

Steve Jones - Editor (7/15/2010)

---

Grant Fritchey (7/15/2010)

---

We've talked about it a few times,...

We've talked about it a few times, but there hasn't been a lot of interest...

Does it hurt anything? Not really.

But what a total waste of space and time. Maintenance and long term readability is reduced, not enhanced. It's a throwback to the old days...

Paul Farnell (7/15/2010)

---

We have an application (developed for us) which relies heavily on nested views. So if the "main" (lets call it A) view looks at another view (B)...

Please don't post in duplicate locations. It just diffuses the conversation.

All replies to this thread please.

GilaMonster (7/14/2010)

---

Can happen any time there's parameterised queries.

And how can...

Jeff Moden (7/14/2010)

---

I'm on vacation in RI to see my parents. It just so happened that my vacation coincided with the local PASS user group meeting. The meeting...

Paul White NZ (7/15/2010)

---

Good. By the way, I think Grant was thinking of the system...

There are multiple ways you could do that. Personally, I'd go with using PowerShell from the 2008 server. You can issue file commands to copy the file and then issue...

SwedishOrr (7/14/2010)

---

Hey guys, thanks for the quick replies. The SQL Server 2005 instance is Standard Edition 64-bit. I do see the SQLPS utility in the C:\Program Files\Microsoft SQL...

Is the SQL Server 2005 a 64 bit install? If it's a 32 bit version, it'll be trying to load the 32 bit version of the commandlet. I've run into...

Whew! Standard deadlock. You've got INSERT & DELETE statements in there. So the deadlocks are not from the shared locks alone. There's more at work, a lot more.

So, standard questions...

Novicejatt (7/14/2010)

---

So there isn't any way to import say multiple tab or comma delimited text files (A.txt,B.txt,C.txt) using T-SQL query at one time? I'm not worrying about manipulation yet, just...

Novicejatt (7/14/2010)

---

If I use BULK INSERT as such, then it only imports one file into the table. I want that I should just drop in the text files(having random names...