Viewing 15 posts - 3,196 through 3,210 (of 7,502 total)
also keep in mind a "drop column xyz" is only a catalog operation !
That columns space will only get reclaimed after maintenance or reindex.
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 3, 2010 at 5:00 am
and you'll need to convert your date to month-name-part ...
Apparently it returns the data in the same order as the in-list
Select *
from (
Select P.name, TH.Quantity, convert(char(3), TransactionDate, 100) as TrxMonth...
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 3, 2010 at 4:40 am
... I see that it still has been rejected as spam by server ...
That is a mail server issue .... contact your mail admins.
They may help you figure...
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 3, 2010 at 4:24 am
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
Viewing 15 posts - 3,196 through 3,210 (of 7,502 total)