Viewing 15 posts - 2,791 through 2,805 (of 7,499 total)
I'm glad it has been solved using the page method.
I've been confronted a couple of times with this issue and I've been able to filter the troublesome rows using 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
September 27, 2010 at 12:13 pm
it's a petty for us all, but "disable trigger" is not a ddl statement !
So you cannot capture it with a ddl trigger.
We have the same issue as you have,...
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
September 27, 2010 at 11:52 am
Grant Fritchey (9/27/2010)
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
September 27, 2010 at 6:52 am
Don't drop your clustering index !!
(because it actually contains the data pages, so a drop will cause all your data to be moved to a heap and all non-clustering...
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
September 27, 2010 at 1:47 am
And it even works! :w00t:
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
September 27, 2010 at 1:40 am
James Tech (9/26/2010)
ALZDBA (9/26/2010)
the function on the datetime column is another one. This causes no datetime index to be used !!
This conversion is also member...
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
September 26, 2010 at 11:57 pm
the cross join is one thing
the function on the datetime column is another one. This causes no datetime index to be used !!
This conversion is also member of the group...
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
September 26, 2010 at 1:56 pm
Also check your cluster log !!
It may also help with the facts analysis.
A long startup time for your sqlinstance may be cause by an excessive amount of virtual log files...
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
September 26, 2010 at 1:12 pm
The index will have to be dropped and recreated because of the change of datatype.
Rule number 1: tell the system what you know.
So don't use a (var)char datatype if 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
September 26, 2010 at 12:19 pm
There may be a difference between microsoft week and iso week !
try this:
declare @dates table ( dt datetime not null )
Declare @startdate datetime
set @startdate = '2010-01-01'
insert into @dates
...
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
September 26, 2010 at 6:14 am
george sibbald (9/24/2010)
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
September 25, 2010 at 12:10 am
indeed, every object needs its own drop statement.
In SSMS however, you can select all these tables in the detail pane of the tables section and delete them all in a...
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
September 24, 2010 at 2:44 pm
Oh, indeed quick copy / paste, you know ... forgot to translate the comments, but you got it anyway 😎
Off course, IMHO, it is better to avoid this kind...
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
September 24, 2010 at 1:38 pm
Keep in mind these "switch" weekends are determined on a country bases.
As in many cases in Europe, every country can do it differently 😉
These are the dates I found 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
September 24, 2010 at 1:10 pm
GilaMonster (9/24/2010)
ALZDBA (9/24/2010)
I like picture 3 : Finaly computer romance :hehe:
Unfortunately not. 😉
That was also during a power failure. I have 2 UPSs for the computer, TV, xbox and ADSL...
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
September 24, 2010 at 6:13 am
Viewing 15 posts - 2,791 through 2,805 (of 7,499 total)