Viewing 5 posts - 1 through 5 (of 5 total)
We got a 20% improvement in an ETL process by creating the filegroup with 4 files all on the same drive. didn't believe it myself till I saw it.
March 18, 2011 at 12:37 am
The data is not in a testable or consumable format for us. You need to read that first link in my signature, it'll explain to you what we're looking for....
March 18, 2011 at 12:35 am
You'll have to join backupset.media_set_id with backupmediafamily.media_set_id for backupmediafamily.physical_device_name = 'YourFullBackupDirectoryAndBackupName'
March 17, 2011 at 1:43 am
Check if all the Services are running in sql server configuration manager
check the protocols if they are enabled.
March 16, 2011 at 1:16 am
The way I worked this was by creating a smaller version of your dataset, which I put in temp table #T. You have more columns, and I'm guessing they're "measures"...
March 7, 2011 at 6:39 pm
Viewing 5 posts - 1 through 5 (of 5 total)