Viewing 15 posts - 451 through 465 (of 1,315 total)
How often does the table get reindexed? Fill factor only applies when indexes are built or rebuilt, if there's no maintenance plan then it has no effect.
I agree that 10%...
September 14, 2007 at 1:59 pm
I agree that option 4 is the best choice, with a 64K stripe size. Don't solicit any more advice from whoever it was that said 8K.
If I was absolutely determined to...
September 14, 2007 at 1:45 pm
I use up to 4 directories for backups, based on database size. Each directory is on a separate drive that doesn't have any of the SQL data or log files...
September 14, 2007 at 1:22 pm
You should create 1 tempdb data file per actual CPU core (not counting hyperthreading), even if they are on the same drive. If you have the luxury of using separate...
September 14, 2007 at 12:53 pm
LiteSpeed Pro's object level recovery feature can restore an individual table to a different table, database, and/or server. It can even export a table from a backup to a CSV...
August 13, 2007 at 7:18 am
My experience with a 200+GB database has been:
Backup to network share: Over 4 hours, double that if anything else is tying up the database.
SQL Backup to four local drives: Backup finished...
August 10, 2007 at 10:37 am
Variables are more complex than they appear. The design-time value is saved in the dtsx file that defines the package. No run-time action will rewrite the package file to change...
July 30, 2007 at 4:01 pm
There are some gotchas with app roles, but I think the major pro of letting users perform actions through an application without giving them any rights to the data or...
July 20, 2007 at 9:40 am
The question was "When using the Fuzzy Grouping transformation, how can you determine how closely two different columns match each other?"
The reference in the answer says "_score, a value...
July 17, 2007 at 8:40 am
The given answer is wrong. The _score field "indicates the similarity of the input row to the canonical row", it doesn't say anything about any particular pair of columns unless...
July 16, 2007 at 6:54 am
The easiest way to get the one most recent record from some group of records is simply SELECT TOP 1
SELECT
TOP 1 id
July 10, 2007 at 3:49 pm
You need to add custom properties to your component that allow you to enter the expression and replacement strings, then add a boolean custom column property that lets you flag which...
June 25, 2007 at 9:36 am
I agree that it might be easier to query the backup history tables to verify that all the backups that should have been written, were written successfully.
But this script will...
June 25, 2007 at 8:55 am
The original query returns one row for each store, then does subqueries returning a totals column for each store in every row. Surely that can't be what you want. Also,...
June 13, 2007 at 11:23 am
Viewing 15 posts - 451 through 465 (of 1,315 total)