Network resources? No effect at all.

Narizz28 (4/11/2008)

---

I agree with Ignacio A. Salom Rangel. The question was can you start it, not can you run it simultaneously. You can start it alright, it will just queue...

It should reduce lock times. Since each batch is run as a set, breaking up the batches with "go" should let each one complete without holding more resources. ...

Depends on what you're doing and on how many cores the CPUs have.

If they both have the same number of cores, then the 3Ghz CPU will probably be faster than...

Have you tried running the sub-query in the Exists function all by itself?

Just, "SELECT id FROM func1(2,2) WHERE id = blah1", in Management Studio, in that database.

That might give you...

Max size of XML data type is 2 Gigabytes.

Michael Earl (4/10/2008)

---

I'm sure I'll get yelled at by someone for this post...

Don't be too bound on the "Stored Procedures are the only way" approach.

They are not necessarily the fastest...

You can either use the char() function, or you can use the characters you want directly.

For example:

replace('abc', 'b', '1')

Will result in the "b" being replaced by a "1", which would...

You'd have to modify the function to deal with decimals. Probably split the integer portion from the decimal portion and the function separately on the integer, then run it...

There's a UDF for converting to any base from base 10 at:

http://www.intersoftdevelopment.com/IDI-ASPNET/Free-Source-Code.aspx?CodeID=5&Code=SQL+Server+Convert+Decimal+Number+to+Hex+Binary+Any+Base

It's not the most efficient code ever, and it's RBAR (inline scalar UDF), but it does work.

It depends on how you're generating the 1-million rows of data.

If what you're doing is importing large files, then BCP/Bulk Import/SSIS is going to be much faster than calling a...

The char() function (not to be confused with the char() datatype) returns whatever character is assigned to the number in the parentheses.

Examples:

select char(33), char(34), char(35)

returns:

!"#

char(32) happens to be the space...

Pivot can be used that way, you just have to trick it.

Max(ID) = ID

If you aggregate on the column you group by, you end up with the column exactly as...

Derek:

I understand your point. I was agreeing with you. SQL has enough consistency problems already without even more being added, was my point.

Per Books Online:

"Transactional replication typically starts with a snapshot of the publication database objects and data. As soon as the initial snapshot is taken, subsequent data changes and schema modifications...