Forum Replies Created
Viewing 15 posts - 2,836 through 2,850 (of 7,506 total)
-
RE: Agent start on one cluster node, not the other
Strange indeed. According to the sqlagent.out logging it seems sqlagent received a stop request.
[131] SQLAgent$INST1 service stopping due to a stop request from a user, process, or the OS... 2010-09-16...
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: Are the posted questions getting worse?
CirquedeSQLeil (9/16/2010)
BTW - at the pace you guys are on with this thread - 20K should be easy peezy lemon squeezy.21k may be attainable 😎
A single printout may even cover...
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 taking too long to Run
please post both execution graphical execution plans (you can save them as .sqlplan and attacht them in a reply) ?
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: To insert a value from a table into a warning statment
did you try a joined solution like ...
Update A
Set RptStatement = ' watever you ' + C.comapnyName + ' @' + cast (year(getdate()) as char(4))
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: Agent start on one cluster node, not the other
can you attach a sqlagent.out file that came from the (failed) start of the troublesome node ?
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: Raw Materials - The Decision
It's a shame Raw materials is about to be ripped from our daily relief.:crying:
Can't they just turn it into a flipover kalender (you know, this kind thing
)Many times,...
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: Are the posted questions getting worse?
GilaMonster (9/16/2010)
Combine this and the BIT thread and I'm just about ready to throw in the towel.I can understand this feeling .... :crying:
On the other side ... altough they came...
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: Are the posted questions getting worse?
Paul White NZ (9/15/2010)
Chad Crawford (9/14/2010)
If only you and DEAD people can read Hex, how many people can read Hex?Don't know. But I do know what an expired...
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: Patients who come in within 14 days
The easiest way to find out is to actually run the query and use the returned results to check for correctness using the subquery.
You'll only get comfortable with sql 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
-
RE: How to move the SQL server table insert rows from test server to Prod server
-If you have BIDS you can just create a new integration server project and compose the stuff you want to using the import/export wizard.
-You could also just use SQLCMD 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: How to move tables, indexes & Logs from one disk to another disk drive
have a look at this SSC article http://www.sqlservercentral.com/articles/Administration/65896/ and see if it fits your needs.
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: Patients who come in within 14 days
With the extra "exists" clause it checks for existance of _any_ data in the query within the brackets.
Because I'm using a Correlated Subquery (check Books Online (bol) for "Correlated Subqueries")
I...
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: Are the posted questions getting worse?
Brandie Tarvin (9/15/2010)
All this talk about the "rankings" makes me want to know what they are and how many points or posts it requires for each one.Is it posted somewhere...
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: Patients who come in within 14 days
If this is for homework, please mention the url as a ref 😀
use mfCarlRepos
SELECT crn
, admission
, admdate
...
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: Index creation after of before populate?
Any partitioning involved ... search BOL for "sliding windows"
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 - 2,836 through 2,850 (of 7,506 total)