Viewing 15 posts - 5,071 through 5,085 (of 7,191 total)
Jeff, I agree with you. Although I mentioned Mr Celko's name, in doing so I didn't intend to imply that I was taking his strict "ANSI good, proprietary bad"...
September 27, 2011 at 6:30 am
No, if there is corruption on your live database, that corruption will be copied when you restore on to a different server. Restoring and running DBCC CHECKDB in this...
September 27, 2011 at 6:03 am
As Jeff hinted, you need to be very careful when you don't have one-to-one relationships between your tables. The UPDATE ... FROM syntax can cause unreported cardinality errors. ...
September 27, 2011 at 2:55 am
It's not something I've ever done, I'm afraid. You'll probably need to do some good old-fashioned research... unless anyone else can point you in the right direction.
John
September 26, 2011 at 8:24 am
SSIS is probably the best way to go, although linked servers might be better, depending on your exact requirements.
John
September 26, 2011 at 7:31 am
sullyf50 (9/23/2011)
all i wanyt is to export all table from a database...
September 23, 2011 at 2:50 am
Not really. SSIS is a big subject. There are tutorials for getting yourself started in writing SSIS on the Microsoft website - I recommend you take a couple...
September 21, 2011 at 3:41 am
If you're doing this in T-SQL, you can use xp_cmdshell (if it's enabled) to run a DOS or PowerShell script. However, this is the kind of thing SSIS is...
September 21, 2011 at 3:35 am
This is how I do it. See code below.
This will only work if you insert or update one row at a time, will it not?
John
September 15, 2011 at 9:52 am
I take it that the share is on one of the cluster nodes and not somewhere on the shared disk? If so, what has happened is that the cluster...
September 15, 2011 at 9:41 am
How is the security of the linked server set up? Does it connect as a specified user, or as the currently authenticated user?
John
September 15, 2011 at 8:42 am
I take it the name of the user isn't dbo? If not, is there a trigger somewhere that's undoing the change?
John
September 15, 2011 at 8:29 am
You can set a CPU idle threshold and schedule a reindex job to run when that threshold is crossed. Of course, by the time the indexing is complete, the...
September 13, 2011 at 9:53 am
As others have said, it's best to make each backup to a separate file. If you have more than one backup in any file, however, you can use RESTORE...
September 13, 2011 at 9:44 am
What is the autogrowth set to? In other words, how many MB or how many percent?
John
September 12, 2011 at 9:53 am
Viewing 15 posts - 5,071 through 5,085 (of 7,191 total)