Viewing 15 posts - 301 through 315 (of 341 total)
Designers of document storage and mgmt apps (with large document objects) had to decide where to store the objects. These included document management systems like LiveLink, and more recentlySharepointt....
The more you are prepared, the less you need it.
September 25, 2008 at 6:16 am
A covering index just means that the query does not have to go to the table for any attribute values. The attributes can either be part of the index, or...
The more you are prepared, the less you need it.
September 11, 2008 at 7:23 pm
yea, the string functions in T-SQL are not vast, but if you work them, they can do the trick.
The more you are prepared, the less you need it.
September 11, 2008 at 7:19 pm
Agree with Steve, there is almost no reason not to have a witness. You can use the express version, so cost is not an issue. There should be...
The more you are prepared, the less you need it.
September 11, 2008 at 7:17 pm
It sounds like you have total freedom to explore all roads to meet your needs, but if your company has paid for Crystal, you may want to take some time...
The more you are prepared, the less you need it.
September 11, 2008 at 7:02 pm
Like all aspects of a database, or development for that matter, views have +/-'s . learn all aspects of the database so you can use them wisely
The more you are prepared, the less you need it.
September 11, 2008 at 6:52 pm
The amazing thing is that normalization is really simple and straight forward. 4th normal form can get a bit much, but other than that, it all makes sense. ...
The more you are prepared, the less you need it.
September 9, 2008 at 1:07 pm
And don't forget to test the backups
The more you are prepared, the less you need it.
September 7, 2008 at 7:44 pm
Unfortunately, this is not a topic that can be quickly addressed in a forum. But if you use SSIS (its part of SQL Server) you can automate the process to...
The more you are prepared, the less you need it.
September 7, 2008 at 7:35 pm
Use SSIS. Then you can automate the process to move a copy of your database backup from prod to where ever. If the backup is zipped, or if you...
The more you are prepared, the less you need it.
September 4, 2008 at 7:07 am
Interesting. So is filepath a declared user variable?
I'm dynamically building the Filespec via expression, since I already know what the file name should be, if it exists. I...
The more you are prepared, the less you need it.
September 3, 2008 at 12:27 pm
They Do Not have to be similar.
Mirroring is totally independent of the physical setup.
The load on the mirror is only about 20% or less as the load on...
The more you are prepared, the less you need it.
September 2, 2008 at 9:12 pm
A quick way to remember Boyce-Codd normal form, which is the typical end point (its a little past 3nF) is with this saying:
An attribute should be dependent on the key,...
The more you are prepared, the less you need it.
September 1, 2008 at 7:11 pm
Reveiwing a database schema absent any business requirements is difficult, perhaps impossible. Start with the business requirements.
The more you are prepared, the less you need it.
September 1, 2008 at 7:02 pm
With the progression of the database/object abstration tools like MyGeneration/DooDads/EntitySpace/Hibernate, views offer the DBA/SQL developer the ability to pre-design application queries that can then be used easily by the development...
The more you are prepared, the less you need it.
September 1, 2008 at 7:00 pm
Viewing 15 posts - 301 through 315 (of 341 total)