Viewing 15 posts - 22,651 through 22,665 (of 26,486 total)
Thinking about some more, you may also consider clustering the SQL Server systems that support your WSS/MOSS environment.
February 3, 2009 at 10:12 am
I'll third that comment, please read the article (I have a link to it below in my signature block also, 1st one).
February 3, 2009 at 10:09 am
LeeBear35 (2/3/2009)
DECLARE @Count INT
SELECT @Count=MIN(EID)...
February 3, 2009 at 10:07 am
Looks like you are still running SQL Server 2005 RTM. Database mirroring was enabled in SP 1. FYI, SP 3 was recently released.
As I stated in your other...
February 3, 2009 at 9:52 am
Instead of replication, you may want to look at database mirrioring. Personally, I don't think I'd want to go into a SharePoint database and start adding primary keys...
February 3, 2009 at 9:45 am
What you may want to read up on is Service Broker. Other than that, I can't provide much more assistance at this time.
February 3, 2009 at 9:40 am
Grant Fritchey (2/3/2009)
It was good for a giggle.I think a different theme next time. Any Babylon 5 fans?
Awesome show! I'd love to get it on DVD, just can't afford...
February 3, 2009 at 9:19 am
Yoda grammer used only when humor needed.
I would not try to get important points across using such grammer. It would easily get lost in translation.
February 3, 2009 at 9:08 am
Jeff Moden (2/2/2009)
charlesz (2/2/2009)
Second, NVarchar(MAX) and Varchar(MAX) can only hold up to 65535 bytes ( The number posted by Gail Shaw was wrong).
Any bets on that?
DECLARE @test-2 VARCHAR(MAX),
...
February 2, 2009 at 8:47 pm
Jeff Moden (2/2/2009)
February 2, 2009 at 7:36 pm
If you can separate the duties, developers have no access to production except maybe read rights so they can look at live data while diagnosing a problem.
February 2, 2009 at 7:21 pm
Jeff Moden (2/2/2009)
rich.ramos (2/2/2009)
February 2, 2009 at 7:10 pm
Third post was the only idea I could give you without the entire query.
February 2, 2009 at 6:59 pm
It would be, my hope, that the join between the two "tables" would occur on the linked server instead of the linking server.
February 2, 2009 at 6:37 pm
As I said earlier, don't be surprised if it is pulling the entire data set over to your server and then performing the join locally on the server with the...
February 2, 2009 at 6:28 pm
Viewing 15 posts - 22,651 through 22,665 (of 26,486 total)