Viewing 15 posts - 241 through 255 (of 369 total)
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...
May 30, 2008 at 6:52 am
We are planning to check the referential integrity in the code.
Per the above statement, you're going to be doing the same work as the DRI. It could also be...
May 28, 2008 at 7:36 am
You will need to change all CHAR and VARCHAR parameters and variables in all stored procedures and functions as well.
I'll add a "plug" for Oracle that maybe the Microsoft SQL...
May 23, 2008 at 11:13 am
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...
May 23, 2008 at 9:33 am
I found this interesting because I had always assumed that SQL Server trimmed trailing whitespace when inserting/updateing varchar/nvarchar columns
Trailing blanks ARE significant in varying character columns in all of the...
May 23, 2008 at 8:24 am
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...
May 23, 2008 at 8:14 am
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...
May 23, 2008 at 8:04 am
jumarrr (4/25/2008)
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...
May 22, 2008 at 10:52 am
SQL Server's full-text CANNOT be used to search on punctuation characters ( , . - # ^ & ' " / + ? etc.). Additionally, single letters and single...
May 22, 2008 at 10:41 am
s43s (5/16/2008)
They do grow but we do shrink them.
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
May 22, 2008 at 10:20 am
Paul Lach (5/21/2008)
SELECT CAST(CAST(CAST(GETDATE() AS FLOAT) AS INT) AS DATETIME);
This is based on the fact that DATETIME values...
May 22, 2008 at 8:46 am
tony.sawyer (5/21/2008)
We've got a UDF called TruncDate that effective truncates the date by removing the time element from it. This mimics the TRUNC() command in Oracle.
Why do all of...
May 21, 2008 at 9:48 am
A similar mess:
http://www.simple-talk.com/opinion/opinion-pieces/bad-carma/
I like the quote: RUN LIKE HELL!
May 20, 2008 at 7:19 am
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...
May 20, 2008 at 7:07 am
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...
May 19, 2008 at 9:30 am
Viewing 15 posts - 241 through 255 (of 369 total)