Johan Bijnens

Forum Replies Created

Viewing 15 posts - 6,301 through 6,315 (of 7,499 total)

RE: Shrinking the database file

you databasesize has been shrunk.
it will try to shrink to it's original size, unless specified other size.
there is a procedure (which may need to be executed a number of 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

April 20, 2006 at 5:42 am

#633216
RE: SQL Server 2005 - Changing Port in Cluster Environment

I cannot see your screenshot, but here's how it works with an active/active cluster (x64).
I just testted it today.
SQL server configuration manager \...
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

April 20, 2006 at 4:00 am

#633202
RE: Shrinking the database file

this might occur when your database has autoshrink enabled.
If this is a production db, disable autoshrink, unless you like to have no control regarding when the shrink will occur !
alter...
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

April 20, 2006 at 3:26 am

#633196
RE: Ownership

Now this is a good parallel projection
As is the final solution ... bringing in another person can help you fix your problem in...
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

April 19, 2006 at 3:24 am

#633007
RE: Retrieving HD info from CLR SP?
Wich permission set did you use when creating the assembly for SQLServer ?
```
CREATE ASSEMBLY xxxx from 'c:\xxxx.dll' WITH PERMISSION_SET =  SAFE | EXTERNAL_ACCESS | UNSAFE 
```
```
I guess for 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
April 14, 2006 at 6:55 am

#632591
RE: Problem starting SSAS 2005

I've set the SQLBrowser service account to "LocalService" but that did not to the trick.
After changing it to "Local System" SSAS was accessable, but the Server-browser (SSMS) did not show...
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

April 7, 2006 at 1:06 am

#631413
RE: ::FN_DBLOG - Problem in retreiving [row data]

I didn't know the function, but sp_help fn_dblog gave some info.
use
your_db
go
declare
@StartLSN nvarchar(50)
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

April 7, 2006 at 12:41 am

#631411

RE: Triggers to Execute in Pre Defined Order

now that's where the cautions come in ...

12 triggers on one object, may be a bit _to_ many

Maybe there is a way 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

April 7, 2006 at 12:25 am

#631409

RE: Result into Table

declare @sql as varchar(5000)

set @sql = 'RESTORE FILELISTONLY FROM disk=''U:\MSSQL\backup\masterfull.bak'''

create table #tmpFilelist ( LogicalName nvarchar(128)

, PhysicalName nvarchar(260)

, [Type] char(1)

, FileGroupName nvarchar(128)

, [Size] numeric(20)

, [MaxSize] numeric(20)

&nbsp

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

April 3, 2006 at 1:03 am

#630324

RE: Triggers

First question that has to be asked : Does this all have to be in the same transaction-scope ? (on-line/realtime). Keep in mind, if the trigger fails, your sql-transaction also...

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 29, 2006 at 1:35 pm

#629648

RE: RowGUIDCol

Consider it as an extention to "Identity"

from books online (BOL)

If an application must generate an identifier column that is unique across the entire...

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 22, 2006 at 5:56 am

#628058

RE: Working With SqlParameter in .NET

also keep in mind when defining your parameters, the better you allign with your sproc-parameter-datatype or column-datatype, the better your commandobject will be served.

Tell the system what you know !

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 22, 2006 at 2:35 am

#628031