Viewing 15 posts - 32,161 through 32,175 (of 59,102 total)
dajonx (10/21/2011)
Right now on our 100 Mbps WAN connection, it takes about six hours to transfer the full SQL backup to the backup site....
...
...
Does anyone have any suggestions?
Yep......
--Jeff Moden
Change is inevitable... Change for the better is not.
October 25, 2011 at 7:55 pm
Sorry for the delay... there were a couple of posts ahead of you...
--Pretend that this is your dbo.ApplicationBldTypes table...
IF OBJECT_ID('TempDB..#ApplicationBldTypes','U') IS NOT NULL
...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 25, 2011 at 7:45 pm
I hope "RestOfData" isn't too wide for you to add an index to in both tables. Here's your original test data and a non-RBAR solution...
Declare @OriginalTable table(OT_ID int identity...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 25, 2011 at 7:19 pm
Gah! Sorry for my last, Elliott... I didn't scroll down far enough.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 25, 2011 at 6:42 pm
Elliott Whitlow (10/25/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
October 25, 2011 at 6:38 pm
Heh... then thank goodness CLR's weren't invented back then. 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
October 25, 2011 at 6:31 pm
Then you don't even need a Temp Table. I'll be back in a bit.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 25, 2011 at 6:27 pm
sanjay.patel 30254 (10/25/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
October 25, 2011 at 6:22 pm
Ummmm... none of this is going to work correctly unless the dbo.ApplicationBldTypes has either an IDENTITY column or a "DateCreated" column (of some sort) to preserve the order of the...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 25, 2011 at 5:51 pm
Evil Kraig F (10/25/2011)
aaaaaaaa93aaaaaa.
3 gets picked up first. You'd have to test for all possibilities and...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 25, 2011 at 4:50 pm
I added to your data (below) so you can see this actually works...
IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL
DROP TABLE #mytable
CREATE TABLE #mytable
( ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,
BARef VARCHAR(50),
BLDClass...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 25, 2011 at 4:43 pm
Wow! Really? Isn't there any function in SSIS that's similar to PATINDEX?
--Jeff Moden
Change is inevitable... Change for the better is not.
October 25, 2011 at 7:27 am
sqlfriends (10/24/2011)
Thanks, it's very helpful
You bet. Thank you for the feedback.
Shifting gears a bit, don't worry about Celko's rant. In most cases, his rant would be correct (although...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 25, 2011 at 7:19 am
CELKO (10/24/2011)
You do not understand that DATE is a temporal data type; there is no converting it....
--Jeff Moden
Change is inevitable... Change for the better is not.
October 25, 2011 at 7:14 am
patrickmcginnis59 (10/24/2011)
I think that giving xp_cmdshell out to everyone is a bad idea, but I also think its possible to use safely, or otherwise Microsoft wouldn't provide the functionality.
Agreed...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2011 at 6:46 pm
Viewing 15 posts - 32,161 through 32,175 (of 59,102 total)