I wouldn't mind an illustration why tables with surrogate keys can't be subjected...

I have created a project in visuall C ++ version 2008 of clr type called calculat and I have a text box and a button in the form. When...

treat it like an sql query. Find whats supported in windows EXCEPT the list you provided.

Thats a really good question. I think the answer is that unless specified otherwise, the copyright is owned by the publisher and you should refrain from using it. On the...

Having a constant lack of faith that things can improve, doesn't seem to be helpful for me.

Actually it can be pretty helpful in dealing with things that we think have...

edit: Hey Steve, I started on this reply before yours, if you'd like I'd not be upset if you removed my post. I really want to encourage practical approaches to...

• This reply was modified 3 years, 11 months ago by  x. Reason: remark for Steve and invitation to delete my post if needed

SSRS: I have seen many SSRS reports.  Every user will export to Excel.  At which point either:

1. All the data cells are merged.  Which makes the table unusable.
2. The...

>SSC-Insane, No-one like me queries any OLTP live servers. That's not what we are talking about.

>As you know, the business guru is given read access to a daily snapshot server....

I just think it would be tough for someone drilling down in data without some sort of database support. Pointing adhoc tools like VBA or Excel at OLTP servers really...

As Yogi Berra is quoted as saying, "When you come to a fork in the road, take it".  There is absolutely no reason why you can't build "the art"...

If this case statement is in the same query as the criteria, the alias won't be available. I would put the entire query into a cte, then treat the cte...

I'm not sure of the entirety of restrictions of running remote stored procedures. If a boatload of programming depends on functionality that I'm not sure of, I just go ahead...

If you're going to use linked servers to transfer between tables, keep in mind that depending on which server runs the SQL to transfer rows, the performance difference can vary...

Allowing failure: Steve and others use children learning as an analogy for this. That works very well because this is childish. When I am a member of your team,...

There are still a lot of tools out there that demand SA login. Some even have checks to make sure they have such elevated privilege. Bowen if you...