Viewing 15 posts - 931 through 945 (of 2,496 total)
You will love SQL Server 2011 when it is released. One of the new features is the ability to have multiple targets for your mirroring, and all of those...
February 2, 2011 at 2:50 am
I would go a bit beyond Steve's advice about growth.
Certainly you must add enough free space to your database to allow maintenance tasks to work. If you are doing...
February 1, 2011 at 3:49 am
I ask the individual answering where they are physically located, if not in the U.S.A .. where of course I am
This sort of assumes that if CS is done in...
January 31, 2011 at 4:41 am
I do not mind which parts of a business are outsourced. The key item is if they perform the function that is needed, both for the business and the...
January 31, 2011 at 4:09 am
The typical way of doing this is to use SQL Server as the data store, and have a separate layer of business code to do the calculations.
If the application is...
January 25, 2011 at 3:04 am
I had a developer uninstall\reinstall IIS and ASP.net on my production sql server.
Doing an uninstall and reinstall on a production server is a major step. I hope you did...
January 24, 2011 at 3:28 am
Database permissions are taken by combining all the permissions in all the groups the user is a member of. Explicit DENY permissions to a given object in a given...
January 18, 2011 at 4:58 am
I suppose it does mark the space as reclaimable to the OS so at some point it will be overwritten.
As GilaMonster says, if it is in the OS free space...
January 17, 2011 at 3:21 am
Run a secure deletion program to delete the database files securely.
You need to know how your disk subsystem works before using a program of this type. If your data...
January 17, 2011 at 3:15 am
Please be aware that stored procedure 'encryption' is just obfuscation. This feature was added to SQL Server way back when Microsoft could get away with mis-naming things far more...
January 12, 2011 at 3:05 am
Sounds like there could be more to this than I have checked...
January 11, 2011 at 9:29 am
If you are deploying to 32-bit then build and test on 32-bit.
If you build on 64-bit then test on 32-bit before you deploy.
If you build and test on 64-bit then...
January 11, 2011 at 4:54 am
I agree with Steve.
You can do the upgrades one by one (do you remember the line 'You can live on it' in Crocodile Dundee?), but I would ask...
January 11, 2011 at 4:48 am
You are right in what you say about separating the system data and user data, and many experts in SQL Server database design say this is a good idea.
However in...
January 11, 2011 at 4:37 am
The OP mentions SQL 2005, SQL 2008, Windows 2008 and Windows 2003. Although there are no differences in how xp_cmdshell works within SQL 2008 and SQL 2008, there are...
January 11, 2011 at 4:29 am
Viewing 15 posts - 931 through 945 (of 2,496 total)