Viewing 15 posts - 7,171 through 7,185 (of 7,506 total)
with
<< SELECT JOBID, JOBTITLE, JOBPOSTEDDATE
FROM JOB_POSTINGS ORDER BY CONVERT(VARCHAR(5), JOBPOSTEDDATE, 108) ASC >>
your query only sorts on the TIME(HH:mm)-part of your datetime (108format check BOL) !
If that is wat you want, 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
February 20, 2004 at 1:47 am
we have such "dynamic" tables.![]()
parametertable
( tablename, colparam, colname, startdatetime , enddatetime, whodidit)
table
(datetimeInsert, d001 float, d002 float, d003 varchar(500), ...)
In the presentation layer, 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
February 20, 2004 at 1:23 am
my 2ct:
ThΓ© main advantage is 'meaningless primary keys' ! ![]()
Some use identity others use uniqueidentifier to do this.
Disadvantage of uniqueidentifier :
-...
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
February 20, 2004 at 12:44 am
can do ![]()
but I 've just foundout that the bo-client's mdac is not at 2.6 yet ![]()
I hope their helpdesk...
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
February 19, 2004 at 4:58 am
If only you had that (old) backup. With full logging, all could be restored to the point where you dropped the object(s).
(then you could restore to an alternate db 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
February 19, 2004 at 12:28 am
It surely would, but I would like to have some alternatives, because of # of clients using BO.
e.g. Windows aliassing the server. But I cannot seem to get to 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
February 18, 2004 at 11:59 pm
-dbcc updateusage can help out. statistics get a bit messy when you use truncate table every now and then.
-then dbcc spaceused your db and look for fragmentation rates.
-make sure 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
February 18, 2004 at 11:47 am
Do you have (not simple) logging ?
maybe log-explorer (lumigent) or log-pi can help out ?
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
February 18, 2004 at 11:39 am
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
February 17, 2004 at 4:40 am
you could use xp_logininfo, but imo you'd better use the security-capabilities of sqlserver.
e.g. grant a nt-group as db-user and then grant it the needed (sp) rights.
because then you avoid over-authorised...
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
February 17, 2004 at 2:41 am
isn't that (Being lazy) one of the top prerequisite to become a sysadm/dba ![]()
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
February 17, 2004 at 12:54 am
my 2β¬ct![]()
- post ddl ! tables and indexes
- remove functions from your predicates if you can (they wil...
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
February 17, 2004 at 12:41 am
there is an issue with using windows-accounts as job-owner.
I don't know the kb-no by heart. I'll add it if I find it back.
If I'm correct it was http://support.microsoft.com/?kbid=233161
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
February 17, 2004 at 12:22 am
profile, profile, profile and don't forget index-tuning-wizard.
There has to be a reason for this latency.
Maybe an other clustering index can help out. Choose it wizely, based upon your usage info.(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
February 17, 2004 at 12:18 am
check smtpmail (http://www.sqldev.net)
BEGIN TRANSACTION
DECLARE @JobID BINARY(16)
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
IF (SELECT COUNT(*) FROM msdb.dbo.syscategories WHERE name = N'[Uncategorized (Local)]') < 1...
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
February 11, 2004 at 12:21 am
Viewing 15 posts - 7,171 through 7,185 (of 7,506 total)