Viewing 15 posts - 2,611 through 2,625 (of 2,639 total)
Used sqlcompare and datacompare from redgate for some years now, relatively low cost tool that should be in every dba's toolkit - in terms of ROI it'll save you so...
February 28, 2004 at 11:36 am
If the database has lots of indexes and triggers it suggests that referential integrity is probably handled by the triggers. Not having clustered indexes is probably a bad idea as...
February 26, 2004 at 3:51 am
There are still times when obscuring the underlying code may be needed, for example on web facing sql servers.
encryption, limited permissions are one way, dll's probably the best -...
February 12, 2004 at 1:57 am
Any user can read the stored procedures, you need to remove the permissions to syscomments in the database which will stop viewing of the code. However, even with encryption your...
February 11, 2004 at 1:48 am
Rule 1 always have a backup !!!
These are the notes I have on suspect databases - in general terms don't expect too much, but these are the best known options...
February 10, 2004 at 1:43 am
It's possible to force a rebuild of a system table by changing the fillfactor on the clustered index - this then forces a rebuild. My msdb gets hit by around...
February 6, 2004 at 1:43 am
The type of business obviously has a significant role .. in my case I work within the mortgage lending industry and not being there means no business, e.g. customers just...
January 29, 2004 at 2:42 am
One other point about expectations is the that the business often tend to downplay theirs, especially when cost is involved, until something goes wrong .. then you find out about...
January 28, 2004 at 7:04 am
The main issue with Raid 5 is that it requires 4 i/o's per disk write, that effectively puts quite a brake on the throughput of your data array. ( i/o's...
January 26, 2004 at 7:43 am
DR is the process and planning of the recovery and continuation of the system/enterprise in the event of a disruption to service with the minimal loss of data and the...
January 26, 2004 at 6:31 am
Raid 5 is only suitable for a read only database.
In all the hiogh performaing oltp environments I've worked I've always used raid 10, right back from sql server 6.0 and...
January 26, 2004 at 5:42 am
I often wondered about that, if I read a series of non-contiguous 8k pages does sql server actually bring in the pages or use read ahead to bring in an extent .....
January 23, 2004 at 9:00 am
I've always set data to 8k for oltp database to match the page size for random reads etc. logs & backup drives I've always set to 64kb. Means most defrag...
January 23, 2004 at 2:33 am
You could place the commands to set msdb into a proc and run the proc at startup automatically.
January 23, 2004 at 2:27 am
One might ask what point there is in having a SQL Server that does not allow access ???? Well I guess it would be secure.
To be blunt it sounds like...
January 23, 2004 at 2:22 am
Viewing 15 posts - 2,611 through 2,625 (of 2,639 total)