Thanks for the post! I set up a search on all the data in my modest sized database and found that LEN also ignores CRLF characters. I found...

I disagree with the answer and believe it should be nvarchar. The documentation at http://technet.microsoft.com/en-us/library/gg492084.aspx shows that the path_locator is hierarchyid, but the name, which is defined...

I did ctl+m and still got no error messages. Everything worked fine.

Laws have to cover a lot of ground. Here is some congressional testimony from Mark Twain on copyright law:

http://www.thecapitol.net/Publications/testifyingbeforecongress_Twain.html

In brief, his arguemnt is that ideas are property...

I got the right answer for the wrong reason. Since you did not say you added the first server to the group, I figured it would not run there....

I think you are doing the right thing to admit a mistake and provide some benefit to the plagerized. I did not write following from scratch but modified from...

Koen Verbeeck (11/18/2013)

---

Please read the entire MSDN page you linked to.

The following SQL Server Database Engine features are supported in the next version of SQL Server, but will be removed...

I have used pivot to make managing permissions much easier for me. Here is a short example of five tables, three grantees and assemblages of SELECT, INSERT, UPDATE and...

I am not sure what the point of the pivot was. The result was the same as select distinct a from #temp. The ordering logic does not appear...

Thank you for the question and all the discussion. I am not a DBA. The T-SQL training I got barely mentioned that there was a BEGIN TRAN statement...

New to this so I added NOT NULL to the end of the ALTER statement and found that the previously inserted rows has isDeleted set to 0. I wanted...

I believe the following statement in the article is misleading:

You don’t need to do the SELECT first, but it is nice to see what you’ll be deleting.

It is required...

I believe the problem is a difference in how distinct gets used in different contexts. For the following queries

select count(distinct id) from #temp_test;

select distinct id from #temp_test;

select count(*) from...

I run on 2005 and the format of the insert statement with multiple values sections does not work for me. I had to recode it as separate insert statements...

Thank you for this post! I found a small problem in the first block of code. PRINT 'ANSI_WARNINGS is OFF'

is not executed because SELECT @userOptions = @@OPTIONS; is...