GSquared (2/12/2009)

---

Unless the tool creates an actual security issue, or in some other way harms productivity, or is expensive enough to have a negative ROI, I don't have a problem...

Roy Ernest (2/11/2009)

---

One thing I have seen is that Unix (Linux or Sco or what ever) has a better File system. This made Oracle much faster when the DB is...

[font="Verdana"]It's a hard, hard issue. What makes it complicated are names forms like:

Xxx Vvv Yyy

Xxx vvv Yyy

Xxx VvYyy

Xxx vvYyy

Xxx V'Yyy

Xxx v'Yyy

I can remember finding valid names matching all of...

[font="Verdana"]Good luck! The performance views between the two systems reflect very different architectures. You may be better thinking about what you specifically want to see from SQL Server,...

[font="Verdana"]I would use the first form, because then your declaritive referential integrity will work.

If you are particularly worried about NULLs in key fields, you can create mapping tables if you...

[font="Verdana"]Check out SQL Server Integration Services (SSIS). You can use this to export the data into files from Oracle, and then load the data into SQL Server from the...

[font="Verdana"]Actually, this is a good example of what I most commonly use check constraints for. Some sort of dependency between the columns in the table. The other common...

[font="Verdana"]I go with the separate Address entity (table, dimension).

One advantage is that you can make sure the address complies with any necessary mailing rules (for example, Zip codes in the...

[font="Verdana"]Agreed. I'm not fond of using if statements this way. However, I remember that in SQL Server 7 and 2000, it was the best performing option. Then...

[font="Verdana"]Actually, I think if you look at table-valued functions, they would do the trick.

CREATE FUNCTION [ schema_name. ] function_name

( [ { @parameter_name [ AS ] [ type_schema_name. ] parameter_data_type...

[font="Verdana"]

Okay, I could spend more time on this and reference Books Online, but I'm just going to give it a quick once over and list anything I have queries about.

Are...

[font="Verdana"]I think you might be better switching to SSIS to create your output. You have a lot more options on how you format the results.

To get you started, in...

[font="Verdana"]That Tally table (or Numbers table, same concept) is so useful! You can do this without the XML, by the way, but I think the XML makes for a...

[font="Verdana"]Even worse, the way you had that written allowed for SQL injection. If you must pass parameters into dynamic SQL, either check the content of the parameter or pass...

[font="Verdana"]There are some issues with performance that dynamic SQL can solve. I'd try the solution without dynamic SQL first, and if it becomes a performance issue, revisit.

Another option is...