On the contrary. CMD.exe is DOS. It will execute any well behaved DOS executable, so it provides complete DOC environment. At least 32bit version, 64bit version refuses to run any...

BCP outputs data to a file, SQLCMD to a file or console, so you can redirect console to a file with > or >>:

rem create output.txt

sqlcmd commands > Output.txt

rem append...

It depends.

I'd put variations (like color, shape,...) into detail table. So, on the site you can display products and on the product page let the user choose variations or display...

Just in case it helps.

The query select * from vw_detail where detail_id=const does not use foreign key index, but if i add master_id=const, id does select * from vw_detail where...

For ideas see Normalizing-Denormalized Tables http://www.sqlservercentral.com/articles/Normalization/64428/ and the discussion.

My suggestion:

You can expand on this. What you got is backward compatibility for select queries. Additionally, you can create "instead...

I could post it, but it's huge and wouldn't do much good without the whole model.

The problem is reduced to this:

1. foreign key field in where and it properly uses...

Nothing? You write software to earn something, so why not pay for software that you need, like and makes you more productive?

Well, I got the impression that you have and...

Maybe you should share what's your problem with Refactor and/or why do you search for alternatives.

It is exactly what the error says, instance can't access the file, it could be in use by another instance (of sqlserver) or another process (like backup), or it could...

DBA_Rob (11/10/2008)

---

I agree that triggers tend to have a very limited practical use for many of the reasons already specified. I have seen too many performance issues caused by...

Legacy? No way. Without triggers some features in our software would not be possible. I like and use triggers a lot. Where necessary, of course.

Otherwise users must not have...

vasaharshit (11/4/2008)

---

hi,

i want some recursive function or stored procedure for the following purpose.

...

An amusing set of options. Would be a useful interview first question. Would you even consider one that chooses last answer?

Nice article. There are some mistakes in examples which indicates lack of attention to details, but the intent for sharing ideas is most important.

You can expand on this. What...

Michael, I agree with you. Events on earth affect climate changes a lot more than anything else. 1940-70 anomalies were cause by extreme emissions of particles, aerosols and gases from...