Viewing 15 posts - 1,876 through 1,890 (of 7,499 total)
it states:
The owner (WIN-69WL56MFLQH\Administrator) of job Integrity Checks.Subplan_1 does not have server access.
Change the job owner to SA !
( this would be the only case one uses sa with sqlserver...
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
July 14, 2011 at 6:55 am
Jim Murphy (7/14/2011)
Koen Verbeeck (7/14/2011)
Koen Verbeeck (7/13/2011)
Gianluca Sartori (7/13/2011)
Crystal ball needed here. I forgot mine at home. 😀
I handed him "a" solution. And that he doesn't complain, he got *exactly*...
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
July 14, 2011 at 2:23 am
just to add to the replies ...
1) of course. Your operator is ">=" !
You should alter it with a ">=" and "<" ( between can have issues...
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
July 14, 2011 at 1:21 am
Have a look at:
- How to: Shrink a Database (SQL Server Management Studio)
- How to: Shrink a File (SQL Server Management Studio)
- How to use the DBCC SHRINKFILE statement to...
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
July 14, 2011 at 1:10 am
SQLBOT (7/13/2011)
...I think this means that each cluster needs a drive letter, but you can mount as many mount points on that drive as you want....
Indeed.
All luns need to be...
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
July 14, 2011 at 12:04 am
kapfundestanley (7/13/2011)
..failing without giving a clear error message.....
Please post all error information you can.
- Errorlog file of sqlserver
- MP log ( if you configured it)
even if it seem worthless, post...
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
July 13, 2011 at 8:30 am
FWIW maybe this way can also be given a try if you have a larger volume of data to process.
As shown in the script it is based on Adventureworks 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
July 13, 2011 at 6:55 am
Mark-101232 (7/13/2011)
ALZDBA (7/13/2011)
Very nice solution Mark. :smooooth:I hope OP understands the performance impact.
Yep, I suspect there's a fast way to do this without having to group by a concatenated string....
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
July 13, 2011 at 3:23 am
Very nice solution Mark. :smooooth:
I hope OP understands the performance impact.
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
July 13, 2011 at 3:10 am
Koen Verbeeck (7/13/2011)
Gianluca Sartori (7/13/2011)
Crystal ball needed here. I forgot mine at home. 😀
I handed him "a" solution. And that he doesn't complain, he got *exactly* what he asked 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
July 13, 2011 at 2:51 am
Define Group1, Group2 and Group3. What are the cryteria ?
Are there any other groups ?
Is your grouping dynamic ?
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
July 13, 2011 at 2:50 am
FWIW I just signed up to Google+ 🙂 Just to see what it's all about.
Let's see... facebook, LinkedIn, Twitter, G+, the fora .... It's gonna need a FTE...
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
July 12, 2011 at 1:30 am
NULL means unknown value for this column on this row.
You'll have to determine - based on your knowledge of your data system - how to interpret it for your case.
If...
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
July 11, 2011 at 12:32 am
We use mount points on almost all of our clusters because of that reason.
We haven't experienced issues with it over the years.
However, you need to take into account you need...
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
July 10, 2011 at 6:47 am
Tom.Thomson (7/8/2011)
ALZDBA (7/8/2011)
Steve Jones - SSC Editor (7/8/2011)
TGIFActually not so much. Leaving for the UK on Sunday, will be out of touch for most of the next week. Behave.
Keep 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
July 9, 2011 at 2:23 pm
Viewing 15 posts - 1,876 through 1,890 (of 7,499 total)