Viewing 15 posts - 121 through 135 (of 1,065 total)
I'm no expert on mirroring, but the issues you describe sound as though there is an issue with communications to the failover mirrored server.
I don't know for a fact that...
May 16, 2011 at 1:49 am
I can't comment on the syntax, and I haven't tried to do this using xp_cmdshell, but I can't figure out how this would work.
It looks as though you will be...
May 13, 2011 at 1:54 am
I'm a bit confused where you swap between talking about an INSERT and then an UPDATE.
Can you post your exact requirements here, because, as the Cursor Police on this forum...
May 13, 2011 at 1:30 am
harsha.bhagat1 (5/12/2011)
By the way I am not HE I am SHE... 😀
:blush:
May 12, 2011 at 8:44 am
I'm reading the OPs problem differently here.
I think the OP did a full backup, then a differential (call it diff1) and another differential later (call it diff2).
He then restored...
May 12, 2011 at 6:32 am
Michael.D (5/11/2011)
I am not even referencing the column Pri_Org_Code4 in the query.
You've almost answered your own question there. You haven't referenced the column, so when you insert a row into...
May 12, 2011 at 3:08 am
But query is created dynamically.
Is the dynamic part so long that it wouldn't fit in 4000 characters?
Couldn't you put the first part in one variable, the dynamic part in the...
May 11, 2011 at 8:13 am
In SQL2000 you could get over any limit for the size of the variable containing your SQL by declaring and executing the SQL from multiple concatenated variables. These weren't realised...
May 11, 2011 at 7:52 am
You could always use SP_OACreate.
Look at this thread for a possible script:-
May 11, 2011 at 6:26 am
IMHO your table structures and size/number of indexes are nowhere near sufficient to cause a 2 hour drop/create time for 3 million rows.
Break out that detective hat 🙂
May 10, 2011 at 5:50 am
Something doesn't sound right here
Your said your environment was
Environment: SQL2k5 , 8 cpus, 16 gb ram, Win 2003 server
Yet you also said
Dropping and recreating indexes for 3 million...
May 10, 2011 at 2:22 am
Syed Jahanzaib Bin hassan (5/9/2011)
May 9, 2011 at 3:21 am
Ray Mond (5/6/2011)
6 hours does look like an extremely long time to create the undo file, even if the entire 5.5 GB contains uncommitted transactions.
I agree it does seem an...
May 6, 2011 at 2:06 am
This is one case where I think a bit of potential duplication may be OK.
Your other suggestion... have a table of customer names then link to that for billing, shipping...
May 5, 2011 at 7:20 am
sachnam (4/27/2011)
April 28, 2011 at 1:22 am
Viewing 15 posts - 121 through 135 (of 1,065 total)