Viewing 15 posts - 226 through 240 (of 920 total)
If you're writing to a single backup file, you might see some improvement by writing to multiple files. At some point you may reach the max for your disks...
September 25, 2012 at 4:45 pm
If one of these tables is actually a view, please post the DDL for the view.
September 25, 2012 at 4:02 pm
When you set up a login, that user has a defined default database. When the user logs in, that database has to be available to the user of the...
September 21, 2012 at 1:04 pm
I'd go for backup to disk first also.
But the only backups you can trust are the one's you've test restored. All the others are instances of acts of faith.
September 21, 2012 at 12:31 pm
And you forget that moving from one release to the next of the same product is porting!
No, it's not. At least not in the case of tsql. ...
September 21, 2012 at 12:26 pm
What's the error message you get? Server does not exist or cannot log in? Are you using windows authentication (probably won't work if the workstations aren't authenticating to...
September 11, 2012 at 2:57 pm
Not in a place to test it right now, but does CDC in 2012 capture an update that doesn't change the updated column's value?
September 7, 2012 at 3:29 pm
Changing the settings would be great. My experience is that the AD sysadmins don't usually like to do that.
In my case, I used a filter on a column in...
September 5, 2012 at 10:18 am
They're 2 different things, really. Restoring a prod backup on a test machine, if the DB comes back online, will tell you that you have backed up the DB...
September 4, 2012 at 5:40 pm
I ran into a problem where the LDAP query would only return 1000 rows and then error out. There's an AD setting to increase that but I had to...
September 4, 2012 at 5:25 pm
Easily provable to be false. Run a large select from a view and examine the locks through SSMS or sp_lock while it's running. You'll see locks on the...
August 24, 2012 at 2:36 pm
Hard to tell, since I just did a cut and paste, but I'd expect the records in a fixed format file to end with the same length and the data...
August 23, 2012 at 3:55 pm
So, it looks like you have one date column and one time column. Are those the ones that are failing? Can you show us some samples of the...
August 22, 2012 at 4:58 pm
I agree, KISS until otherwise advised. The more complete solution you provided would be preferred.
August 22, 2012 at 4:27 pm
How was this format file generated? I'm making a guess here but I'd suspect that it doesn't really describe the data file. Does the data file have a...
August 22, 2012 at 4:23 pm
Viewing 15 posts - 226 through 240 (of 920 total)