Hi
is this a good practice if I shrink the database files and
its log files after each day's full backup? Is this a
good practice for data warehouse databases?
many thanks.
JJ...
more >>
Does anyone know how SQL Server Reporting Services will be
delivered? Recently released white papers indicate it is
a component of SQL Server. Wondering if I should delay my
SQL Server purchase until it is available or if I'll be
able to get a download later...
...
more >>
How can I export in one other server my local packages?(and scheduled job)
DTS go only for the objects in a database?
...
more >>
Anyone know if exist an excel-addin for an "what-if" analysis type.
My client need something like that, but i don't know what exactly is it.
In the sql server documentation is mentioned, but i don't find more than 3
lines of explanation.
Help
Thanks in advance
Carlos Ortiz.
...
more >>
Let's say all of my report queries use READ_UNCOMMITTED in order to avoid
deadlocking with load processes. The queries select from views which have
indexes.
Now suppose a query is running while a nightly load operation is running.
The nightly load operation inserts additional records into the...
more >>