I usually, almost without thinking anymore, use forward declarations so that I won't have to include headers. Something along this example: //----------------------- // foo.h //----------------------- class foo { foo(); ~foo(); }; //----------------------- // bar.h //----------------------- class foo; // forward declaration cl...
Hi folks, I'm creating a new DB and have a bunch of static data that won't change. If it does, it will be a manual process AND it will happen very rarely. This data is a mix of varchars and Geographies. I'm guessing it could be around 100K or so in total, over 4 or so tables. Questions Should I put these on a READ ONLY filegroup Ca...
I've been successfully using bitmap indexes for years in Oracle environment. Now I'm working on a data warehouse project which will be hosted on SQL Server 2005. So far, I was unable to find an answer for bitmap like indexes in SQL Server. Any Ideas? ...
I just want to create the model once, and then use it in any kind of database, without the need to modify the model. What I should do with the data type ? I found there is numeric and other kind of data types. What does that correspond to in mysql or access ? ...
When I hack around, some code tend to get much bigger than originally planned. As this happens I usually introduce/collapse/merge namespaces, move files between them, move folders etc etc. Sometimes, if I don't have a clear picture of the end result, this is a real pain and really easy to just "skip". This leads the project deteriorate w...
Hello, I did not find a place holder for asking questions related to Digital design - Frontend / Backend(Physical) on stackexchange. So i proposed one there on area51. So for time being asking my question here - 1]I am looking for a book on Physical Design/Backend design for beginners. I am basically a software developer,having overvie...
How does the PRIMARY KEY keyword relate to clustered indexes in SQL Server? (Some people seem to want to answer this question instead of a different question I asked, so I am giving them a better place to do so.) ...