Yep, that is exactly what I mean. This will help with performance. Especially if your table has a lot of records.

I want to create a backup and then restore the database again (under another dbname), and I want to split the file into two or more:

1) abc.MDF

2) ABC1.NDF

3) ABC2.NDF

(and...

The role you are speaking of is the replmonitor database role. This role is found in the distribution database.

More info:

http://technet.microsoft.com/en-us/library/ms151221.aspx

Alright, i'm gonna use a split function, it works for me because I only have to split a few values, and also thanks To adam, i hope to start using...

Well it seems like you have a lot of flexibility. I would stick with mirroring, transactional replication, or log shipping. All of these options would satisfy your base...

This is a method that works much like the one Matt posted, but does not use exists.

Select O.OrderID, O.OrderName

FROM @Order O

INNER JOIN

(

SELECT OL.OrderId

FROM @OrderLine OL

LEFT JOIN...

If you want these queries to be columns of a result set then you will have to use the cross apply join. You can save the results into a...

NP 😉 Thanks for the feedback.

Can you please provide table ddl, sample data, and the desired results? It clarifies the problem and makes it easier on everyone trying to help.

Thanks.

There is an end of file marker embedded in there somewhere. You should not have to check for it, unless you have something outside the norm, like a delimiter...

For some reason the \ n was stripped from my post. This is the new line character.

Well typically you use \r for carriage return/line feed. I would start...

Try using the new line terminater. It may not have carriage returns but it should have a new line.

= new line

\r = carriage return\line feed

Additional documentation on terminators

http://msdn2.microsoft.com/en-us/library/ms191485.aspx

Wow. This question has been coming up alot. I tend to lean on xml, in situations such as this. It give the ability to parse data really...

I tried that on sQL 2005 SP2.

Msg 8120, Level 16, State 1, Line 6

Column 'a.a2' is invalid in the select list because it is not contained in either an aggregate...

Well this depends on your business requirements. Do you need automatic failover or is a manual failover okay? How much data loss is acceptable?

Usually for DR or high...