Viewing 15 posts - 3,961 through 3,975 (of 7,503 total)
As stated above, you can use management studio to perform the action.
However, more interesting is to let SSMS generate the SQL to complete the action.
Doing so, you'll see SQLserver encapsulates...
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 27, 2009 at 12:49 pm
Check out the execution plan of both queries and execute them both a couple of times (so data will be in memory).
(SSMS Querypanel Ctrl+M or Menu Query topy "Include actual...
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 27, 2009 at 12:42 pm
😉
What always tends to bring the confusing with charindex/patindex is that is has its arguments in another order then the replace function.
Whenever I need to use anyone of those, F1...
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 27, 2009 at 5:40 am
declare @charpos int
declare @searchterm nvarchar(max)
SET @searchterm = 'blood and sweat'
set @charpos = charindex('and', @SearchTerm)
IF (@charpos = 0) --Check to make sure string position was found
BEGIN
...
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 27, 2009 at 5:14 am
I've seen users being granted sqlagentoperator role, also appear in SQLAgentUserRole and SQLAgentReaderRole.
Did you try (re-) adding that user to these roles ?
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 27, 2009 at 5:10 am
I think it is CU2 http://support.microsoft.com/kb/961930
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 25, 2009 at 10:54 am
Yes, you can go directly to sp3.
Download it from MS.
This forum thread has more info:
http://www.sqlservercentral.com/Forums/Topic455158-146-1.aspx
Be sure to move the quorum of the cluster to the node that hosts the instance...
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 25, 2009 at 8:17 am
What's the number of rows that match the criteria ?
Is that number the same for both instances ?
How about concurrency ?
What software level are you on (@@version) ?
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 25, 2009 at 6:45 am
- Is there a clustering index on that table ?
if not, provide one, unless you can prove it hurts performance.
Data pages may be scattered all over...
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 25, 2009 at 5:47 am
the script also works on SP2.
By now you should at least be on SP2 with CU2 and if you can directly go to SP3.
MS did improve the product to your...
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 25, 2009 at 5:40 am
Oh yes ... SANs .... the big black magic box :hehe:
- Performance monitoring a SAN is very vendor specific, so contact your vendor if you really think that is the...
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 25, 2009 at 5:00 am
You pull over the data to be processed into a temptb, so you'll no longer lock out the actual table.
- Why don't you use a regular cursor to loop your...
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 25, 2009 at 4:51 am
- size
- distribution
- index organization
- memory usage
- paging activity
- other processes on the server
- locking
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 25, 2009 at 2:55 am
Get things organized !
create table Testperf (col1 varchar(5000) )
cannot be a reference because of ... table design.
No indexes, a table with a single column, ...
If you want to stress 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 25, 2009 at 2:53 am
Mark Pratt (2/24/2009)
EXEC MASTER..xp_cmdshell 'BCP "EXEC GfmReplication.dbo.zz_ExportXml" queryout c:\Org.xml -S(local) -T -c'
The problem is that my script, being part of a unit...
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 24, 2009 at 11:48 pm
Viewing 15 posts - 3,961 through 3,975 (of 7,503 total)