Viewing 15 posts - 3,196 through 3,210 (of 7,499 total)
You are correct !!
Apparently it doesn't store the UserName, but the its internal identifier 'S-1-9-3-3482764364-1226597329-2493949361-1082924894'.
I wonder why they would do that !!
They should have documented this behaviour.
In my test...
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 2, 2010 at 12:06 am
Is it always object ID 7:1086626914:0 that suffers this issue ?
declare @ObjectRef varchar(128)
Set @ObjectRef = '7:1086626914:0'
Declare @DbId varchar(128)
Declare @ObjectId varchar(128)
Select @DbId = substring(@ObjectRef, 1, charindex(':',@ObjectRef)-1)
, @ObjectId = substring(@ObjectRef,...
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 29, 2010 at 2:38 am
parthi-1705 (1/27/2010)
This Time my problem is bit different
I am having a database with daily Full backup i did not put Translog backup for...
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 29, 2010 at 2:04 am
As you have seen I prefer these kind of "lookup" values in table rows.
If you really need the "original" parsed value, on top of the actual individual value, just extend...
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 29, 2010 at 1:59 am
I have the vast impression it must be something with this sqlinstance... the box should be able to cope with the threads without a problem.
Another thing is we are having...
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 28, 2010 at 12:43 pm
any progress ?
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 28, 2010 at 12:39 pm
Keep in mind HOW a between works with string values !!
Here's another way to get started ...
-- TEST IT -- TEST IT -- AND SEE WHAT IT DOES !!!
Declare @InputTable...
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 28, 2010 at 8:03 am
As always it depends ...
Partitioning only uses a single column to work on ...
If you aim to partition on one of the columns that currently composes your primary key ......
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 28, 2010 at 6:54 am
- removed because of stupidity - to early in the morning :hehe:
[Second Edit]
... after the furst cup of coffee :w00t:
Did you try this ?
/*
dd 20100128
http://www.sqlservercentral.com/Forums/Topic699260-1291-1.aspx
How can I create a temporary...
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 28, 2010 at 12:15 am
Good feedback.
OT : Keep in mind you should avoid running in lower edition db-level ! So switch to your engines dblevel whenever you can !
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 27, 2010 at 7:12 am
Well .... altough I cannot get the point of using a "don't know what status it is in, but it is not a known status" ....
This may be what 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
January 26, 2010 at 12:42 am
Don't use the identity property in your reference table !
Create a trigger for Insert and and use the inserted object to load your target table.
Keep in mind to do this...
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 25, 2010 at 11:04 am
Hi Barry, must have been "last day of the week syndrome" 😉
Off course I should have posted the used DDL.
As stated in my previous post, i tried to play 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
January 25, 2010 at 12:09 am
As Gail already stated, you should implement this trigger to be able to cope with more than one row in the inserted and/or deleted internal objects !
e.g
--TEST IT -- TEST...
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, 2010 at 5:57 am
Tony Savoie (1/19/2010)
...We're off to a great start....this is the day after giving notice and he's called in sick 😉
That's very promissing towards the near future (post exit goodwill)...
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, 2010 at 1:41 am
Viewing 15 posts - 3,196 through 3,210 (of 7,499 total)