Rich text, AFAIK, isn't unicode. It's markup inside the text that is interpreted by the editor. So if I make a set of bold text and a regular text like...

Code to show duplicate values, without constraint (SS2K8R2)

DROP TABLE dbo.MyTable

CREATE TABLE mytable

( id INT IDENTITY(1,1)

, mychar VARCHAR(10)

)

GO

INSERT mytable SELECT 'A'

INSERT mytable SELECT 'B'

INSERT mytable SELECT 'C'

SELECT * FROM dbo.MyTable

SET IDENTITY_INSERT...

No idea on relationships, but nvarchar(max) and varchar(max) for Latin data are the same. Only if you are storing data requiring Unicode does this matter.

This might help: http://geekswithblogs.net/pakistan/archive/2005/04/19/36884.aspx

You need to SELECT the data from the table, but the client has to deal with the stream.

bcp makes the most sense to me. Easy to use, upgradeable across versions.

http://en.wikipedia.org/wiki/Reentrant_%28computing%29

It means the same section of code can be executing from one user (or process) and a second user can then use that same code again and start executing it...

Stefan Krzywicki (5/24/2011)

---

Plus, if the person gets undercover help and succeeds, they're going to be asked to do more that they're going to need help with. It becomes a never-ending...

Gail is correct, the shrink is bad, and the reorganize will rebuild indexes. You can read here:

http://msdn.microsoft.com/en-us/library/ms188964.aspx

When that runs, it will require space in the database, and it will log...

dduensing (5/24/2011)

---

...

Agility without focus is fairly useless. Apps that are released to the world without a support plan, or a way to formally pipe the feedback in...

mpalecek (5/24/2011)

---

I have to agree with roger.plowman. I am in a small company with an equally small staff.

Projects routinely get started with a good plan and scope. After a short...

roger.plowman (5/24/2011)

---

Shudder.

Steve, that's a recipe for absolute disaster.

First, you're falling into the "get it out the door, we'll test it afterward" trap. Second, users will initially love it, and cause...

You need a dynamic properties task to alter the connection, or a scripting task.

This can help you rename the file in a script task: http://www.sqldts.com/292.aspx

http://www.sqldts.com/252.aspx

I have had a Kindle (gen 1) and an iPad. I think that reading online, AKA a browser, the iPad works better. Hadn't tried the Nook, but I'd consider that....

You could use this and read the DCM. That might be the most reliable

http://www.sqlservercentral.com/articles/Administration/differentialbackupprediction/2306/

PhilDaniels (5/23/2011)

---

To my point, 2%-5% is not a raise, it isn't even a cost-of-living adjustment. Let's say you are an $80K/year employee. Your take-home is about 65% of that ($52K),...