Johan Bijnens

Forum Replies Created

Viewing 15 posts - 7,216 through 7,230 (of 7,503 total)

RE: BUG Or What Am I Missing

an other 2ct.
The best things about nulls is you don't need to use them.
So only define null alowed when you need null, when it makes sence for your datamodel...
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

January 26, 2004 at 12:11 am

#491560
RE: GETDATE -> only DATE needed

Actualy, I don't consider this to be nitpicking
Your comments do point to brainteaser issues, when one does not keep in mind sqlserver...
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

January 23, 2004 at 5:24 am

#491311
RE: Deleting LOG FILES automatically

please elaborate.
You could take a log-backup and move that from your db-server.
Check recovery-models in BOL.
If your logfiles grow more than you'd expect, or you've performed an operation causing 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

January 23, 2004 at 5:15 am

#491309
RE: database owners, users, roles, security

dbo is the default schema SQLserver has implemented.
If a user (lets say User0 )performs "select * from mytable" SQLserver will first search an object...
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

January 23, 2004 at 1:40 am

#491284
RE: BUG Or What Am I Missing

Should result in 2 rows.
Is this on a multi-processor sqlserver-box ? try queryhint maxdop 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

January 23, 2004 at 1:19 am

#491279
RE: Recovery option for SQL 7

In addition to Allen Cui's reply :
' Select into/bulk copy' will alow non-logged operations.
This will have some recovery disadvantages.
Check SQL7 BOL.
found this in my sql-log :
The Select Into/Bulk Copy option...
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

January 23, 2004 at 12:44 am

#491275
RE: Fixed memory errors

Check these articles http://www.sqlservercentral.com/columnists/jsack/aweadventures.asp
http://www.sql-server-performance.com/awe_memory.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

January 22, 2004 at 6:00 am

#491100
RE: Moving filegroups to a different disk

detatch db ... move files ... attatch db
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

January 22, 2004 at 4:46 am

#491085
RE: GETDATE -> only DATE needed

UPDATE tbldummy SET datefield = convert(char(10), getdate(),121)
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

January 22, 2004 at 4:22 am

#491083
RE: Bulk Insert

nice large index-columns
My guess is your primary file(-group) is autogrowing.
<<A new table is created everyday. >>
If...
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

January 22, 2004 at 4:13 am

#491081
RE: Bulk Insert

- win-permon and sql-profiler can point you in the right direction.
- post the script (DB-(filegroups) + table + indexes + indexed views)
- is the db autogrowing during this load ?...
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

January 22, 2004 at 12:22 am

#491063
RE: Help with indexes

IMO, create FKsupporting-indexes for all FK-columns or columngroups (exact column-order as PK).
If you want more usable replies, post the DDL and expected stats.
<<searching in the a, b, c, d...
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

January 21, 2004 at 6:19 am

#490956
RE: How are usernames checked?

Awaiting new hardware and tackled most of the urgent problems yesterday
This seemd like a nice educational timespender
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

January 21, 2004 at 2:20 am

#490949
RE: How are usernames checked?

-- edit post -- is not working ??
also add this at the bottom of the script :
insert into T_SQLServerCentralUsers (uAlias) values('jonathaN')
results in :
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

January 21, 2004 at 2:18 am

#490948
RE: How are usernames checked?

oops uncommented to much :
--Maybe this will help :
--drop table T_SQLServerCentralUsers
go
create table T_SQLServerCentralUsers(uidnr int identity(1,1) primary key,
uAlias varchar(128) COLLATE SQL_Latin1_General_CP1_CS_AS not null,
uDtMember datetime...
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

January 21, 2004 at 2:11 am

#490946

Viewing 15 posts - 7,216 through 7,230 (of 7,503 total)