Viewing 15 posts - 6,886 through 6,900 (of 7,506 total)
Same player shoots again ...
![]()
Test this : ![]()
'T_ParentMC' =...
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
November 9, 2004 at 7:41 am
That's correct ! Sorry for that ![]()
I didn't notice because I didn't document that in the script at the time I developed it. 
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
November 9, 2004 at 3:21 am
Hi Noelson,
This is part of a script I used to convert some pk-indexes (clusterd/nonclusterd).
Test it for usability for your purpose.
Declare @TbNaam varchar(128)
set @TbNaam = 'T_Tabel'
create table ##Tmp_TbRefsW1 (
cType...
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
November 9, 2004 at 2:31 am
no can do. ![]()
Structured Query Language (SQL) uses a comma as a separator and not as a decimal sign.
You can avoid this problem by...
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
November 8, 2004 at 3:39 am
just to be complete : ![]()
where indid=0 gives only heaps !
where indid in (0 , 1) gives heaps and clustered...
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
November 5, 2004 at 2:31 am
In addidition to the other replies :
-If you are going to choose the "delete "-path, go for small transactions.
Declare @Counter int
Set @Counter = 1
Declare @TotCounter int
Set @TotCounter...
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
November 3, 2004 at 12:09 am
dynamic ? Think #/## temptb or @ tablevar.
Populate your temp-object with search- and replacementvalues and join it so you get the correct results.
Maybe this gets you on track:
http://www.sqlservercentral.com/scripts/contributions/100.asp
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=32921&SearchTerms=CSV
Johan Dont drive faster than your guardian angel can fly ... - How to post Performance Problems - 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
Learn to play, play to learn !
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post data and code to get the best help
October 29, 2004 at 8:22 am
1) tell the other dba(s) you're going to redo the restore
so (s)he doesn't redo the reboot ![]()
2) redo the (full/pit) restore !...
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
October 29, 2004 at 8:02 am
just some readingstuff.
http://www.sqlservercentral.com/columnists/awarren/shouldyoubuyasan.asp
http://www.sqlservercentral.com/columnists/bknight/clustering_a_sql_server_machine_.asp
http://www.sqlservercentral.com/columnists/kpart/scalingout.asp
http://www.sql-server-performance.com/ew_san.asp
and
forum http://www.sqlservercentral.com/forums/messages.aspx?forumid=54
it works fine overhere ![]()
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
October 22, 2004 at 5:00 am
what's your sqlserver version an sp /hotfisex ?
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
October 22, 2004 at 12:29 am
or
SELECT A, count(distinct B) as B_Count, count(distinct C) as C_count
FROM tableABC
GROUP BY A
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
October 7, 2004 at 11:16 am
what's sp_who/sp_who2/sp_lock stating ? ![]()
is msdtc running ?
is SQLAgent running ? (and is it running any jobs ?)
Do you connect using SQL-authentication 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
October 5, 2004 at 11:21 am
In addition to the other replies : check your ODBC-settings (clientside). If ODBC-logging is active, everything slows downdramaticaly. ![]()
are your problem sqlservers dedicated servers...
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
October 4, 2004 at 1:03 pm
CREATE TRIGGER trg_updatedt ON [dbo].[tablename]
FOR UPDATE
AS
UPDATE tablename
set modified = getdate(), modified_user = suser_sname()
from inserted
where tablename.colid = inserted.colid
check out which user you want to store user_name() <> suser_sname()...
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
October 4, 2004 at 1:00 pm
So you'll need to copy the parent row first to the target parent-table, then copy the child row to the target-child-table and then delete the child row from the source-child-table....
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
October 4, 2004 at 12:55 pm
Viewing 15 posts - 6,886 through 6,900 (of 7,506 total)