Various comments:

1. I don't like the "NEVER use", "ALWAYS use", etc. that appears in these articles. For one thing, this was written before SQL Server 2005. What...

Per the above statement, you're going to be doing the same work as the DRI. It could also be...

I'll add a "plug" for Oracle that maybe the Microsoft SQL...

The database collation can remain the same. The N-prefixed datatypes are automatically UNICODE. See BOL.

So you will have to convert all CHAR and VARCHAR columns to NCHAR and...

Trailing blanks ARE significant in varying character columns in all of the...

Having worked extensively with Oracle, that feature, along with a lot of other features, does not exist in SQL Server.

Your only solution is to use a view. You can...

Your web application needs to honor the "Language" preference, which would include date, and currency settings, chosen by the user in their browser. E.g., for U.S. English it is...

jumarrr (4/25/2008)

---

Hi,

my problem is the following:

I need to get a textual representation of text data stored in binary file of type mostly MS Office, pdf, ...

Simply I want...

SQL Server's full-text CANNOT be used to search on punctuation characters ( , . - # ^ & ' " / + ? etc.). Additionally, single letters and single...

Shrinking the database files is one of the worst things that you can do!

Read the following article for the details:

http://www.sqlskills.com/blogs/paul/2007/11/13/AutoshrinkTurnItOFF.aspx

Paul Lach (5/21/2008)

---

Here is another way to strip-off the time and just return the date:

SELECT CAST(CAST(CAST(GETDATE() AS FLOAT) AS INT) AS DATETIME);

This is based on the fact that DATETIME values...

Why do all of...

A similar mess:

http://www.simple-talk.com/opinion/opinion-pieces/bad-carma/

I like the quote: RUN LIKE HELL!

Functionally they are the same.

I prefer the IN syntax as one of the risks with using OR is that if you have other WHERE clause predicates, which would probably be...

This sort of data-driven attribute-value pairs in a relational database quickly goes bad. I've seen too many attempts at this with disastrous results. In particular, when either querying...