Viewing 15 posts - 4,636 through 4,650 (of 7,499 total)
I've tested DB-mirroring using 2 dev-editions (primary / mirror) and an express edition for witness.
Just make sure the service accounts can connect to one another !
What I did was using...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
August 26, 2008 at 10:35 am
strange, now it finds 5999 rows where newcol is null.
So the update statement should have target rows to modify.
update yourtable
set newcol = oldcol
where newcol is null
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
August 26, 2008 at 10:31 am
As Steve replied, it will work on insert and update.
One little remark:
You only perform the extra update if the column is updated, meaning it is mentioned in the insert or...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
August 26, 2008 at 10:24 am
Did you test the exact example code I posted ?
Can you post the results of this query ?
select count(*) as newcol_NULL_count
from yourtable
where newcol is null ;
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
August 26, 2008 at 6:46 am
Inspect your data !
Your example works perfect as shown next.
create table #mytb1 (col1 nvarchar(50) not null);
insert into #mytb1
Select '500910000000000000'
union all Select '500903000000000000'
union all Select '500909000000000000'
union all Select '500903000000000000'
union all...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
August 26, 2008 at 1:52 am
nvarchar to bigint requires your nvarchar content to be convertable to numbers !
check your nvarchar columns content for non numeric content or special characters, ...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
August 25, 2008 at 11:52 pm
- Did you design your unit of work for each operation ?
- try to keep your transactions aligned to a single unit of work and commit or rollback as soon...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
August 25, 2008 at 7:59 am
bodhilove (8/24/2008)
hi guys,If you have multiple databases on an instance that you want mirrored do you need to have separate endpoint for each one?
No. They use the a single...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
August 25, 2008 at 7:56 am
Maxer (8/22/2008)
Rights to view all data tables for reporting purposes.
So they can't change anything, but they sure as heck could open up Access or Excel or whatever,...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
August 22, 2008 at 11:27 am
hengert (8/20/2008)
I want to add two columns, VARCHAR and DATETIME, to an existing table with data, that are NOT NULL columns.
ALTER TABLE ADDRESS
ADD DATE_LAST_UPDATED DATETIME DEFAULT ??? NOT NULL,
USER_LAST_UPDATED VARCHAR(8)...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
August 22, 2008 at 11:16 am
"hard coded with week password ... " sounds familiar :sick:
Most of the time, the installers just don't know it is stored in an ini-file or a reg.key.
Search "program files" and...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
August 22, 2008 at 8:19 am
You can still go multiple instance, but in that case, you may want to have a look at Windows System Resource Manager (WSRM) to avoid one instance starving you server.
For...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
August 22, 2008 at 5:53 am
I just came across this post which might put some light in the darkness...
http://www.mssqltips.com/tip.asp?tip=1567
http://www.mssqltips.com/tip.asp?tip=1557
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
August 21, 2008 at 3:18 pm
just my 2 ct.
I've read somewhere (cannot recall where, but I guess it was in one of Jeff Modens replies) that sqlserver may also experience problems when using between with...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
August 21, 2008 at 8:18 am
- apparentley you are using SSMS to try to restore the dbs.
It will use the connected instances service account authority to query the backup locations.
With sql2005 that access is restricted...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
August 21, 2008 at 8:08 am
Viewing 15 posts - 4,636 through 4,650 (of 7,499 total)