Viewing 15 posts - 4,636 through 4,650 (of 7,502 total)
It is not considered a good practice to have sqlserver and analysis server on the same physical box.
Exactly for the reasons you see.
They are different by nature and will compete...
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 28, 2008 at 9:54 am
muralikrishna37 (8/27/2008)
Hi ALZi didnt guess how to check my original that
can u give the suggestion
thanks
murali
check the url in my previous reply.
it has the info.
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 27, 2008 at 3:34 am
You should first check your original column for "non convertable" content.
check http://www.sqlservercentral.com/Forums/Topic533291-5-1.aspx#bm533528
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 27, 2008 at 2:49 am
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
Viewing 15 posts - 4,636 through 4,650 (of 7,502 total)