Johan Bijnens

Forum Replies Created

Viewing 15 posts - 6,676 through 6,690 (of 7,499 total)

RE: SQLPutData

yep, basic rule No 1 for programming is still : "learn copy/paste"
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

March 16, 2005 at 12:12 am

#547200
RE: SQL logins changed domains

That should be no problem because the new domain will use the old sid from the users sid-history.
The only "issue" you'll have is...
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

March 16, 2005 at 12:02 am

#547198
RE: help creating sequence value using sql transaction

... parameter-table and proc set to manage sequences ...
This way you could emulate identity
This is just a simple representation :
create table t_mySequenceParameters (
TableName...
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

March 15, 2005 at 7:04 am

#547038
RE: SQL logins changed domains

you could add the old domain's user-SID to the new domain-user's sid-history.
As you can imagine, this is a windows-ad-operation, and not a sqlserver operation....
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

March 15, 2005 at 6:33 am

#547030
RE: help creating sequence value using sql transaction

~~you may want to check out IDENTITY and scope_identity if you can live with gaps in your numberings.~~
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

March 15, 2005 at 6:25 am

#547029
RE: The maximun Power of a Database

we always set it to the max available blocksize and let sql handle it internaly.
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

March 15, 2005 at 6:20 am

#547027
RE: SQLPutData

Can't DTS help ?
(check out Enterprise manager, database, tables, rightclick and choose import data. The wizard will guide 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

March 15, 2005 at 6:17 am

#547026
RE: Hekp - Deleting Table/Records

In addition to sa24's advice, you can also use this delete-batch.It will take a while, but since transaction are kept small, interferance should...
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

March 15, 2005 at 12:14 am

#546987
RE: use of trigger to update history table
```
CREATE TRIGGER Itr_T_Current
            ON T_Current
FOR INSERT
AS 
```
```
insert into T_History
select * from inserted
```
```
GO
```
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
March 15, 2005 at 12:07 am

#546985
RE: Memory Allocation

maybe these resources can help :
- http://www.sqlservercentral.com/columnists/jsack/aweadventures.asp
- http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;319942
- http://www.sql-server-performance.com/sql_server_performance_audit5.asp
- http://www.sql-server-performance.com/jc_sql_server_quantative_analysis7.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

March 11, 2005 at 12:29 am

#546545
RE: List all tables and filenames for each

Keep in mind filegroup-files are balanced within a group, so your maxcapacity is the size of the smallest file * the number of files in the filegroup.
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

March 9, 2005 at 6:52 am

#546132
RE: List all tables and filenames for each

Is this what you're looking for ?
this query uses native sqlserver systemtables .
SELECT FG.groupid AS GroupID
, SUBSTRING(FG.groupname,1,30) AS FilegroupName
, SUBSTRING(O.name,1,30) AS ObjectName
,...
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

March 9, 2005 at 6:43 am

#546126
RE: Convert minutes to Hours:Minutes

select dateadd(mm,yoursum,getdate() - getdate()) as yourTime_1900_01_01
check out dateadd in BOL
this example may 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

March 8, 2005 at 7:31 am

#545864
RE: Truncating Transaction Logs

I guess not. Maybe it only comes available if the log is rolledover
I've tested this small sample, and the restore to the new...
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

March 8, 2005 at 1:11 am

#545818
RE: T-Sql Contruction

couldn't deduct that from the example
in that case , Helen 's response will work.
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

March 7, 2005 at 4:13 am

#545675

Viewing 15 posts - 6,676 through 6,690 (of 7,499 total)