Viewing 15 posts - 751 through 765 (of 1,166 total)
December 29, 2006 at 4:51 pm
Looks like it is possible.. see the following thread replied by Hilary who is one of the sql server MVP AND coauthor of one of the replication books...
December 29, 2006 at 4:47 pm
Truncate is minimally logged operation and it will not break LSN...
December 29, 2006 at 4:32 pm
That is correct as long you give the access to the db through application but I have seen the cases sometimes clients want to generate custom reports which requires db...
December 29, 2006 at 8:58 am
Are you doing local backup or network backups?
Check for disk error and disk queuing during backups operation...
If your backup is network backup then check Network adaptor for any errors or configuration...
December 29, 2006 at 8:49 am
When you have 16 GB memory do not use /3gb...MS recommends not use /3gb if you have 16+ memory...but some gurus advise not to use /3gb when you have 12+...
December 29, 2006 at 8:40 am
What is the execution time difference?
Bookmark lookups are not always bad...
December 29, 2006 at 8:28 am
There is no command to get this other than DBCC showfilestats ...
Use DBCC showfilestats to get the total and used extents for a database and then calculate the space.
December 29, 2006 at 8:22 am
Security might be another concern... when you have one db for all clients ... what happens if one client deleted another client's data?
In this case you may endup with...
December 29, 2006 at 8:08 am
I think MS follows some algorithm to determine the virtual log size based on the tlog size...and you can't change the size of it..
Read the following articles for details...
http://msdn2.microsoft.com/en-us/library/aa933049(SQL.80).aspx
December 29, 2006 at 7:57 am
Install IIS and retry...
If it is already install, just uninstall and reinstall ISS AND install RS.
December 28, 2006 at 9:45 pm
Is snapshot isolation level or mirroring is enabled?
December 28, 2006 at 9:29 pm
Keep in mind the performane and security issues with dynamic sql...
The Curse and Blessings of Dynamic SQL
http://www.sommarskog.se/dynamic_sql.html
December 28, 2006 at 3:54 pm
Check http://www.sqlis.com ?
December 28, 2006 at 3:46 pm
I never been in this situation but I will go with multiple dbs to reduce the down time and management can handled through scripts....
December 28, 2006 at 3:39 pm
Viewing 15 posts - 751 through 765 (of 1,166 total)