Viewing 15 posts - 1,051 through 1,065 (of 6,216 total)
Its a dirty hack!
Very similar to tricks I've seen done in Query Analyzer to generate statements. Worth knowing, maybe not the first thing I'd recommend.
July 11, 2004 at 2:40 pm
Lots of good responses. Without belaboring the point, Im not trying to stump anyone in an interview. I like questions that elicit questions, that show me how they think. Wow'd...
July 9, 2004 at 2:58 pm
Agree there is some info there, but dont know that it answers all of these. Let me see if I can find someone to answer.
July 5, 2004 at 9:10 am
We put views into the db's that reference the main db, that way it appears to be in one place, handy both for reporting and programming against. Haven't noticed any...
July 5, 2004 at 9:07 am
Nothing wrong with creating your own system of user permissions. Can't say if the multi db idea is good or not, I think really depends on your environment, plans, etc....
July 3, 2004 at 11:34 am
I've seen them as well, sometimes from jobs started under sql agent that got blocked - possibly maint plan steps, been a while since I noticed it.
July 1, 2004 at 5:01 pm
There is an add in called Ndoc that does much the same for VB. Havent looked to see if the behavior changes in VS.Net 2005, wouldnt be surprised.
June 29, 2004 at 5:11 pm
We debated this quite a bit before posting. What Steve posted was not meant to be political commentary, just recognition that someone who played a major role in our history...
June 8, 2004 at 6:13 am
The point about turning out lights, monitors, etc, is one I missed and is worth noting. Im also pleased to find I'm not the only one that has bad things...
June 7, 2004 at 6:30 pm
I default them to master db as well. Saves a lot of problems if you do a restore and the dbid changes. It's also just easier to admin. Apps should...
June 4, 2004 at 7:00 pm
I've got a follow up coming with some more research. Will check on the code that didn't work, maybe I goofed!
June 3, 2004 at 6:44 pm
We're working through this where I work as well. Right now for the most part developers have a local copy of SQL (dev edition) and do all their work there....
May 18, 2004 at 5:49 pm
Fair point - I'll see if I can find time to do a network capture to be sure of what is really going on. QA is probably right, but I...
May 18, 2004 at 5:45 pm
It's not open source, but its not expensive either. Any bugs you see are most likely caused by changes we made - for example, usually if you lose a post...
May 11, 2004 at 6:59 pm
Its the report format for Reporting Services. Havent heard of one yet, but have looked much either!
May 7, 2004 at 5:59 am
Viewing 15 posts - 1,051 through 1,065 (of 6,216 total)