Solomon Rutzky (2/26/2011)

---

...You don't need to worry about the SELECT of the new value getting something updated from another session if you use the OUTPUT clause in the UPDATE as...

Very nicely presented article, but the content is not quite right in places.

The set intersection is useful so long as your are clear that you are talking about sets of...

When I create a database, I get two active VLFs according to DBCC LOGINFO.

CREATE TABLE

dbo.Summary

(

PK ...

I'll post an example in a second.

DECLARE @XML XML

;

SET @XML =

N'<?xml version="1.0" encoding="utf-16"?>

<Report

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

...

Well that sort of thing happens from time to time 😉

You should still be able to understand...

e90fleet (2/24/2011)

---

Is there a way to bulk insert multiple files from a shared folder into a table without using xp_cmdshell? Using SSIS and turning xp_cmdshell on is not an...

That's not the first five bits, it's the first 2.5...

Are you using OPENROWSET BULK SINGLE_CLOB to load the initial table from a file? If so, best performance...

Thanks for that, but no, I'm...

Naturally, there...

There's an article on this site about APPLY, and I know the author:

http://www.sqlservercentral.com/articles/APPLY/69953/ << Part...

SQL Dude-467553 (2/24/2011)

---

Here is a text file I used as an example with the code that fails upon BULK INSERT. I tried it with the code that Lowell left...

Brandie Tarvin (2/24/2011)

---

Wow. Am I really the only person on The Thread that not only took the course, but enjoyed it? Turbo Pascal and Assembly were, IMHO, the two easiest...