Forum Replies Created
Viewing 15 posts - 6,226 through 6,240 (of 7,505 total)
-
RE: Has anyone tried creating sp_ or fn_ in master on 2005 yet?
still works the same way, as long as you don't use dmv's.
Even better, if this standard date conversion is only calculation or formatting, you may want to take a quick...
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: This would be a cool feature...
you could use windows authentication in the dts-connection-objects, and only provide the needed rights on your prod-servers to the service accounts that runs sql-agent (so it starts the dtsrun.exe)
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: Trigger in SQL2k causing ASP.NET web page to timeout, help
if your processing does not need to be executed online-realtime, only execute it online-neartime.
have your update-trigger raise an error (nonblocking, but logged) and define an alert for it , so...
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: Remote SQL trace causing network slowness
it's not because your queries slow down, that your network slows it down !
For sqlserver it depends wich trace-flags are activated for the trace.
e.g. do you only capture sqltext 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: SQL Profiler - Minimum Security needs
Been there, done that
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: X64 Problems installing SSAS named instance
Thank you Jeff for this reference.
- I've contacted MS and they confermed in x64-sqlbrowser, it does not pulish, but only supplies connection-routing. That's why I couldn't see the instance but...
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: Casting error
I 've forgotten to mention the setup of my script.
So it creates an #-temptb and it fills it up with all the data.
Then each while loop deletes 1 row from...
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 syntax near ''''ge''''. [SQLSTATE 42000]
Start with just that code at line 1319
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: Casting error
just my 2ct to find the bogus data ...
create table #tmp (RNo bigint identity(1,1) not null primary key, ObligationNo varchar(15))
declare @Rowcount bigint
insert into #tmp (ObligationNo )
select ObligationNo
FROM CollExceptions
set @Rowcount =...
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 syntax near ''''ge''''. [SQLSTATE 42000]
well, this may sound a bit odd, but did you try retyping that querypart from the and clause up to the end of the full query ?
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: IS there a better way to write this query
actualy JeffB and Peter Larsson altered your query simanticaly
This...
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 syntax near ''''ge''''. [SQLSTATE 42000]
Did you check what statement is at line 1319.
In sql2005 management studi, there is this handy option for the query editor to show linenumbers.
tools/options/texteditor/all languages
check line numbers
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 syntax near ''''ge''''. [SQLSTATE 42000]
copy/paste the query in SQL Server Management Studio (sql2005 !)
You'll notice it has problems with carriage-returns char(13).
You'll have to replace them with char(10).
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 syntax near ''''ge''''. [SQLSTATE 42000]
Run the script in SQL2005 SQL Server Management Studio.
It has problems with char(13) linebrakes.
Change them to char(10)
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: How SQL server tracks the deadlocks
- Is there a primary key or unique key on this table ?
- Wich is the clustering index. (=the physical order of rows 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
Viewing 15 posts - 6,226 through 6,240 (of 7,505 total)