Viewing 15 posts - 1,546 through 1,560 (of 7,506 total)
Just today I've seen a tweet pointing to a delegation troubleshooting blog:
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
December 13, 2011 at 12:00 am
We choose to leave one SQL2000 instance to host DTS-packages until the project teams get budget to upgrade the packages to SSIS.
Main reason is to avoid troubles as you have.
We...
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
December 12, 2011 at 10:47 am
- at db upgrade time. (after restore, together with all other db maintenance)
we have auto update stats enabled.
We check every now and then how old statistics are and rebuild them...
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
December 12, 2011 at 9:57 am
Jeff Moden (12/12/2011)
ALZDBA (12/11/2011)
As a firefighter sysadmin/dba, I cannot but embrace your choice of solution.
( insert in table a server a with a trigger to insert into serverb some table)
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
December 12, 2011 at 6:19 am
R.P.Rozema provided the solution.
I just want to point to Some common date routines by Lynn Pettis
and
my rules of thumb for date/datetime related stuff http://www.sqlservercentral.com/Forums/FindPost1219915.aspx
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
December 12, 2011 at 2:05 am
richardkel (12/12/2011)
Everyone seems to be saying don't use triggers, but how do you get the record keys into the staging table for the records that need to be transferred by...
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
December 12, 2011 at 1:53 am
[sarcasm]
As a firefighter sysadmin/dba, I cannot but embrace your choice of solution.
( insert in table a server a with a trigger to insert into serverb some table)
This will guarantee my...
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
December 11, 2011 at 1:23 pm
Greg Edwards-268690 (12/9/2011)
ALZDBA (12/9/2011)
With fixed ports, you can also register the spn...
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
December 11, 2011 at 11:32 am
Jeff Moden (12/11/2011)
ALZDBA (12/11/2011)
That's one of the reasons some of us try to stick with ansi sql and never use proprietary language features.But, as Jeff mentioned, excel.
Heh... It's a personal...
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
December 11, 2011 at 11:22 am
george sibbald (12/10/2011)
powershell.anything on the BI side - SSIS, SSRS, SSAS
Darned, I even forgot that one, despite of my article "Me, myself and Powershell[/url]" :crying:
Thank you for bringing it up,...
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
December 11, 2011 at 7:14 am
The last replies have been to have a db per customer in your set up. That's the one I would go for for simplicity of management, upgrades, specific client tailor...
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
December 11, 2011 at 7:10 am
My rules of thumb for date/datetime data:
1) always store in the appropriate data type (date / datetime)
2) don't put functions on columns, so if you need e.g. 23 year old...
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
December 11, 2011 at 6:46 am
just my 2ct to add ...
it also depends if you have more than just NULL/0/1 ( e.g. you want to know if the data "is being prepared" or "is being...
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
December 11, 2011 at 6:29 am
your backup database command isn't initializing the bak file.
Things to check:
- the @BackupPath backup file name composition (as it still has the same name as the day before, and...
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
December 11, 2011 at 6:21 am
suppose _you_ know the matching criteria, and only want to know if rows defer ... have a look at checksum and only show rows that have non-matching checksum values 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
December 10, 2011 at 7:23 am
Viewing 15 posts - 1,546 through 1,560 (of 7,506 total)