Viewing 15 posts - 44,716 through 44,730 (of 49,571 total)
Full backups don't truncate the log and hence don't break the log chain. In your example, it's possible to take the previous day's full backup and restore all the logs...
September 3, 2008 at 12:42 pm
You can, but you'll have to check every single input box and every query string. It's probably better to look at the code of the app and see how it's...
September 3, 2008 at 12:36 pm
The problem with this is that the repeated (Column = Variable or variable = constant) expressions confuse the optimiser's estimations of rows affected (on 2005 definitly, not sure about 2008)
It's...
September 3, 2008 at 12:35 pm
Table variables are always added to the TempDB system tables and are allocated space within TempDB. They won't actually be written to disk unless there's memory pressure, but the framework...
September 3, 2008 at 9:34 am
Rem (9/3/2008)
By setting Processors Affinity & I/O Affinity, Am I OK, or I should totally disable HT?
You should disable it completely, if you can. If not, then a workaround is...
September 3, 2008 at 9:16 am
ALZDBA (9/3/2008)
Gail,Do you have a kb ref for the min = max memory config problem ?
How about books online:
Optimizing Server Performance Using Memory Configuration Options
September 3, 2008 at 9:13 am
This may be useful:
http://blogs.technet.com/askperf/archive/2008/03/25/lock-pages-in-memory-do-you-really-need-it.aspx
September 3, 2008 at 9:01 am
rbarryyoung (9/3/2008)
To the best of my knowledge, Hyperthreading is not recommended for SQL Server.
It's not. SQL 2005 handles it better than SQL 2000 did, but still... Can lead to random,...
September 3, 2008 at 8:47 am
Get a bigger drive.
If you're putting data into the database it is going to grow. You can look at archiving or deleting data that's no longer necessary, but that's...
September 3, 2008 at 7:26 am
Is you coworker asking for separate servers or separate virtual servers?
September 3, 2008 at 7:24 am
Don't shrink your database at all. It causes very bad index fragmentation and the DB will just grow again next time some data is added or those fragmented indexes are...
September 3, 2008 at 7:13 am
You can. If you haven't made changes to the model database, it's not necessary.
September 3, 2008 at 6:54 am
I don't. It was mentioned in a presentation. I'll see if I can find a ref for you.
September 3, 2008 at 6:31 am
Keyword filters aren't a very good way of defending against SQL injection.
1) Use only procedures (preferably) or parameterised queries from your front end apps.
2) Ensure that the app user has...
September 3, 2008 at 3:18 am
What was the error when the service didn't start? There would have been something in the SQL error log.
Install
Patch
Ensure that the user DB files are in the same location as...
September 3, 2008 at 1:11 am
Viewing 15 posts - 44,716 through 44,730 (of 49,571 total)