Forum Replies Created
Viewing 15 posts - 6,886 through 6,900 (of 7,499 total)
-
RE: Database with a Loading Status (Server Rebooted during Restore)
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
-
RE: SQL server 2000 to SAN
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
-
RE: NULL not showing from right table if LEFT JOIN using.
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
-
RE: Using DISTINCT in a query
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
-
RE: Query Analyzer slow and spor attic
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
-
RE: Query Analyzer slow and spor attic
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
-
RE: Storing User/Date Time on update
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
-
RE: Insert/delete with Foreign Key
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
-
RE: xp_sqlmaint Rebuilding Index
if your DRP allows you to, you may want to switch the recovery_option of your db to bulk-logged during the time you rebuild the indexes. This will use less...
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
-
RE: Using DISTINCT in a query
select distinct a,b,c
from tableABC
-- order by a,b,c
returns the distinct combination of a,b,c in your table.This way "distinct" is applied at row level.
sometimes, one might want to count the...
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
-
RE: Could not find the index entry for RID 16abe380100 in index page (1:5269), index ID 0, database msdb..
euh ..
index 0 is the heap. (index 1 is the number for the clustered index, index 255 contains text, lob stuff)
before trying to...
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
-
RE: read text file contents in a stored procedure
you may want to take a look at "Read a text file from SQL Server query analyzer" http://www.sqlservercentral.com/scripts/contributions/417.asp
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
-
RE: Incorrect Result Returned From IF Statement
Nice coding reduces misunderstandings and misreadings
IF NOT (@TempVal) IS NULL
Begin
IF @TempVal < @RetVal
begin
SET @RetVal = @TempVal
end
end
PRINT @RetVal
or
if isnull(@TempVal,...
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
-
RE: SQLServerCentral.com Is Moving
Hey, Back online.
I hope everything went just as smooth as you planned it.
Seems good over here.
Nice...
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
-
RE: SQLServerCentral.com Is Moving
Aaarch ... you've told her ...
.... Now you'r under pressure And you have a deadline .., or "suitcases at the door"-line .
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
Viewing 15 posts - 6,886 through 6,900 (of 7,499 total)