Forum Replies Created
Viewing 15 posts - 5,806 through 5,820 (of 7,499 total)
-
RE: Database Keeps Freezing (timeout error)
When you are experiencing the issue, run the query mentioned at the hyperlink. It will show you who is blocking who, this may get you on track.
You can run profiler...
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: Database Keeps Freezing (timeout error)
SQL Profiler :
start \ programs \ microsoft sqlserver 2005 \ performance tools \ sql profiler
I'd start with the default presented trace.
Keep in mind this may have impact on your...
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: Frozen SSMS
What's the actual size (mb) of the serverlogs ?
I guess it's pulling it over the network, hence the "not responding"
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 hints best practice.
Just a thought at this time ....
Like with all hints, try to avoid them !
And if you...
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: Database Keeps Freezing (timeout error)
- run sql-profiler to figure out what's going on
- find out what's blocking the server :
http://www.microsoft.com/technet/scriptcenter/scripts/sql/sql2005/trans/default.mspx?mfr=true
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: Stop execution when the error occur in EXEC (SQL statement)
did you try ...
CREATE PROCEDURE testUnique
AS
declare @strSQLExec nvarchar (1000)
set @strSQLExec = N'select * from NonExisting_object '
print @strSQLExec
DECLARE @myrc AS INTEGER
SET @myrc = 0
EXECUTE @myrc =sp_executesql @strSQLExec
IF @myrc <>...
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 7.0 xp_sendmail
how about books online ?
btw to avoid some hassel, some use smtpmail
Have a look at Gert's site : SQLDev.Net
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: I/0 error Torn page
maybe this can get you back up and running.
if it concerns only model, pubs and northwind.
(remember to keep the old mdf-ldf files)
Just copy another model-db (mdf + ldf) from another server...
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: Restore db from network location
Be very carefull !!
DBCC TRACEON (1807) : Allows you 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: Configuring 2005 to run SSIS packages containing DTS packages on a cluster
..Now I have to go find out why all our upgraded master databases are set to a compatbility level of 80...
If you've upgraded, the compatibility level has not been changed....
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: Help needed w/query
maybe this can help you out ....
create table #PhoneCalls (CallId int not null identity(1,1) primary key, CallTime datetime not null, CallEnd Datetime not null default ('9999-12-31 00:00:00.000'), CallDuration int not...
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: Configuring 2005 to run SSIS packages containing DTS packages on a cluster
as you will have noticed, SSIS is not cluster aware. What I mean is SSIS is not member of a cluster group, unless you install it yourself.
This means, you'll have...
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: DELETE all records except most recent
In short :
The delete query :
DELETE t1
FROM
(
SELECT
ROW_NUMBER() OVER
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: BULK INSERT
this works for me ...
I've created a table (csv_test) with 256 columns , saved the xls as csv and used this statement :
BULK
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: DELETE all records except most recent
I've tested the # ways on a testbox singleproc 1,8mhz / 1GbRam with 10,000,000 rows per table and cleared buffers to begin 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
Viewing 15 posts - 5,806 through 5,820 (of 7,499 total)