Viewing 15 posts - 34,456 through 34,470 (of 39,726 total)
Data Compare from Red Gate. Cheap, easy and works well.
October 19, 2004 at 12:09 pm
Are you bulk inserting? If not, you can get teh value first and then include it in the insert statement.
October 19, 2004 at 12:09 pm
Server side traces use less resources, but you have to worry about file or table contention on the disks. You can always transfer the data to a remote server on...
October 19, 2004 at 12:04 pm
Since they log OR the data are required to restore, I don't worry about this. dbcc will check this.
October 19, 2004 at 12:01 pm
Haven't seen anything like that.
October 19, 2004 at 11:56 am
If you move the clustered index to another filegroup, it moves the table.
October 19, 2004 at 11:55 am
Yep, forgot about that one. Definitely be sure you script everything out in case you forget somthing and need to find out what it was. Permission is the main one...
October 19, 2004 at 11:52 am
No way to do it now, no plans, but we'll consider it.
October 19, 2004 at 11:38 am
http://www.sqlservercentral.com/columnists/SBoriotti/exchangefromsqlserver.asp
Not quite what you want, but they have a product to help with that.
October 18, 2004 at 9:00 am
getdate() will get you the exact minute. If you need everything from today, you'd need to calculate the current day minus the time,
select datepart(mm,getdate() + '/' + datepart(d, getdate())...
October 18, 2004 at 7:27 am
MS_foreachtable will run a command against all tables. Might be a way to script it for all indexes.
October 18, 2004 at 7:22 am
b&r - your SLA will depend on the tape SLA to get data from tape. I'd set this at some xx minutes per GB. Test in your environment.
User Access -...
October 18, 2004 at 7:21 am
Couple things.
Rename - be sure you rename the SQL Server as well as the computer.
The copy objects wizard has been flaky for me (and the task). I'd back and restore...
October 18, 2004 at 7:20 am
Scan for all servers.
Check versions/patches
Check security config
Check service accounts
Check for pwds on all accounts
Check for use of roles
Check who has any fixed roles
October 18, 2004 at 7:15 am
Be sure you check this againts software that they are using. It's possible there are reasons for downlevels. Not that they shouldn't be patched, but be sure that you know...
October 18, 2004 at 7:14 am
Viewing 15 posts - 34,456 through 34,470 (of 39,726 total)