Viewing 15 posts - 16,801 through 16,815 (of 39,902 total)
I'm not sure what you mean with user column. You add a user to your database. You can then assign this user rights, or map them. In SQL 2000, you...
February 21, 2011 at 9:14 pm
The buffer pool is managed separately for each instance, so if you have separate instances (check your licensing before you decide on this), you can assign xx memory to each...
February 21, 2011 at 2:21 pm
I would like to get back to the Columbus SQL Saturday, but it will depend on my schedule over the next month. Already life is busy, and not sure I...
February 21, 2011 at 2:19 pm
As Craig mentioned, everything goes through the transaction log. That's how database consistency and ACID is enforced. There are tricks to minimize the impact, but depending on what you are...
February 21, 2011 at 2:18 pm
You should be able to remove the db_owner role from the user. Is this just a "change permissions" thing?
Does this user own the database? You can use T-SQL to change...
February 21, 2011 at 11:33 am
Good advice from Grant, but I might argue that the code and work being done in development is important and it's a "kind of production" level of stuff that you...
February 21, 2011 at 10:55 am
Haven't seen much written on RAId 50. I suspect it suffers the same write penalty that Raid 5 has.
Raid 5 worked well for me for years, and continues to do...
February 21, 2011 at 10:52 am
In addition to what Craig said, you pay for bandwidth, so factor in the cost of doing a backup, deploying code, testing on Azure, etc.
The "savings" might not be anywhere...
February 21, 2011 at 10:50 am
Congrats, Grant, and thanks for all the help over the years.
February 21, 2011 at 10:47 am
rmaw-1095848 (2/16/2011)
February 21, 2011 at 10:23 am
WayneS (2/13/2011)
I'd love to...
February 21, 2011 at 9:17 am
On my list. This is a pet peeve of mine and I'm trying to slip it into the development schedule.
February 21, 2011 at 9:00 am
You need to run checkdb periodically. It is the only way you will detect corruption and the sooner you can detect it, the better.
If it's a burden on the primary...
February 21, 2011 at 9:00 am
It used to be to ensure traffic on the site. However the short answer is that it's how the forum software is configured. Most forum software (we bought this)...
February 21, 2011 at 8:58 am
SQL Sentry's Performance Advisor is really a performance tuning tool, not really a monitoring tool. They perform separate functions.
February 21, 2011 at 8:55 am
Viewing 15 posts - 16,801 through 16,815 (of 39,902 total)