Viewing 15 posts - 41,266 through 41,280 (of 49,571 total)
Derek Dongray (2/3/2009)
I'm not aware of any way to do deletions without any transaction logging at all.
All data modifications in SQL are logged, one way or another. It's not...
February 3, 2009 at 7:25 am
obarahmeh (2/3/2009)
I have a table that has a huge number of data, this table has no primary key.
I need to create a replication that replicate this table and any...
February 3, 2009 at 7:22 am
Arun (2/3/2009)
I am able to take full backup in my production server using the WITH COPY_ONLY option now. Also the log shipping is working fine.
The only time the COPY_ONLY...
February 3, 2009 at 7:18 am
Depends. Are we talking 4 or 5 files, or 4 or 5 hundred files?
February 3, 2009 at 7:11 am
Matt Miller (2/2/2009) That doesn't mean you get to put down our little tournament:)
Oh, I'm not trying to put your 'little' tournament down. I just don't know what it's...
February 2, 2009 at 10:27 pm
Lynn Pettis (2/2/2009)
GilaMonster (2/2/2009)
Matt Miller (2/2/2009)
I'd laugh at that - but I was coding SQL while watching the superbowl yesterday....:)Super what?
Oh, right, the World Cup is the only TRUE World...
February 2, 2009 at 10:16 pm
Do you have any object named 'sysnsobjs' in your table? Do you have a user named 'sys'?
Did the upgrade adviser find any problems?
February 2, 2009 at 10:04 pm
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).
Really? What makes you right and Books Online wrong?
Or is...
February 2, 2009 at 9:58 pm
TheSQLGuru (2/2/2009)
2) is the join column a primary key or unique index value? Looks like cartesian product if not.
Agreed. That's one reason I want see the actual exec plan,...
February 2, 2009 at 12:50 pm
Please post the code you're using and the exact error message that you're getting.
February 2, 2009 at 12:49 pm
Matt Miller (2/2/2009)
I'd laugh at that - but I was coding SQL while watching the superbowl yesterday....:)
Super what?
February 2, 2009 at 12:44 pm
To add to what Terry posted try this article here (blatant self-promotion)
February 2, 2009 at 12:40 pm
DavidB (2/2/2009)
I'm sure all that have posted to this thread would be happy to provide some suggestions on what you have in place currently.
Oh, absolutely! The comment about prices...
February 2, 2009 at 12:31 pm
Nicholas Cain (2/2/2009)
ARCServe (and most backup solutions) have an open file agent which allows you to backup files that are in use by the OS or other programs.
That should...
February 2, 2009 at 12:30 pm
john (2/2/2009)
I need to add this records quickly and I don't have time to add the UI right now.
Use a query window and write insert statements?
What's the definition...
February 2, 2009 at 10:57 am
Viewing 15 posts - 41,266 through 41,280 (of 49,571 total)