Viewing 15 posts - 1,471 through 1,485 (of 7,499 total)
another reason to switch to a more intelligent solution in stead of a maintenance plan.
there are a couple of alternatives at SSC.
Ola Hallengren has a very nice one at http://ola.hallengren.com/
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 12, 2012 at 12:48 pm
What about servername, instance name for your standalone server ?
Are they equal to the original servername ?
If not, you may have some issues with msdb (sqlagent), and master sysservers
have 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
January 12, 2012 at 12:34 pm
with numeric data, leading zeroes do not play a significant role, so don't worry.
If you want leading zeroes in your result, handle that in your presentation layer (gui, report, ...)
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 12, 2012 at 12:28 pm
GilaMonster (1/12/2012)
...Speaking as a occasional trainer and presenter..
And a darned good one too, may I say ! :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
January 12, 2012 at 6:55 am
As Jason stated, the query I provided should cover your quest.
Oh indeed. I forgot to mention this:
Test it, Test IT !
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 12, 2012 at 1:01 am
- the trc files you see are the ones generated because the default trace is active (+_ 20MB each, wright ?) I presume.
( please let it be active. It 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 11, 2012 at 2:03 pm
Because you're only using inner joins, just let the sql engine determine at which step in the process it will handle your where clause.
(It will take indexes and statistics into...
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 11, 2012 at 1:47 pm
Maybe this can be an option too
Declare @SeriesStartDate datetime
Declare @SeriesEndDate datetime
Select @SeriesStartDate = '2010-11-01'
, @SeriesEndDate = DATEADD(mm, 4, @SeriesStartDate)
Declare @DynamicPivot varchar(1000)
declare @Separator char(1)
Select @DynamicPivot = ''
, @Separator = ''
Select @DynamicPivot=@DynamicPivot...
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 11, 2012 at 1:24 pm
I would first look for things that may cause your kind of corruption:
A good starter is : http://sqlskills.com/BLOGS/PAUL/post/Example-20002005-corrupt-databases-and-some-more-info-on-backup-restore-page-checksums-and-IO-errors.aspx
You'll find more corruption/checksum related blogs on that site.
http://www.sqlservercentral.com/articles/Corruption/65804/ also contains very helpful...
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 10, 2012 at 12:04 am
you could try to investigate its execution count
select qs.execution_count
FROM sys.dm_exec_query_stats qs
cross apply sys.dm_exec_query_plan(qs.plan_handle) QP
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 6, 2012 at 1:23 pm
that's one of the advantages you get when switching to dbmail 🙂
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 6, 2012 at 1:10 pm
Thank you for the feedback !
Others will benefit from it.
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 6, 2012 at 1:08 pm
Is this a single shot migration ?
Did you have a look at the SSMA for access (freeware by MS )?
( SQLServer Migration assistant for access )
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 6, 2012 at 1:03 pm
Can this help out ?
insert into @sku values ('12345000'),
('32134000'),
('21340000'),
--It was not working for skus like
('1234567'),
('1234012'),
('1234500')
Select sku
, SUBSTRING ( sku , 1, datalength(sku) - patindex('%[^0]%',reverse(sku)) +1) as newsku
--, patindex('%[^0]%',reverse(sku)) as pos
from...
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 6, 2012 at 12:59 pm
manju3606 (1/4/2012)
Hi ALZDBA,
can i ask question here,i am using bellow qurey to get all relationship tables and i am getting all the relation ship tables also now what i...
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 6, 2012 at 2:29 am
Viewing 15 posts - 1,471 through 1,485 (of 7,499 total)