Viewing 15 posts - 781 through 795 (of 2,462 total)
Jason-299789 (11/21/2012)
Thanks Eugene, it just looks odd to my eyes.
you can test it with actual execution plan . that will give you exact picture what/where/why any object...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 21, 2012 at 4:39 am
Nikhi123 (11/20/2012)
Will optimizing the stored procedures improve the performance of the database while running reports.Thanks
you can also directly test the stored proc at mgmt studio with the passed parameters...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 21, 2012 at 4:37 am
sandeep.vemulas (11/21/2012)
its returning first select statement values.
means if u changed the positions of select statements then also its displays
select stmt values means which one first the values r...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 21, 2012 at 4:32 am
shohelr2003 (11/21/2012)
I went database mirroring monitor and found "Synchronized" from Mirroring State column of both of the server instances.
this would be the first assured and positive impression that data...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 21, 2012 at 4:20 am
below is the two sql i seperate .
ALTER procedure [dbo].[usp_Fixtures_BowlingAverages_Client]
( @Fixture_SeasonKey int,@Fixture_TeamKey int,@Fixture_FixtureType int)
as
begin
Select (cast(Max(D.Bowling_Wickets)as varchar)+'-'+cast(Min(D.Bowling_Runs)as varchar)) as Bestbowling
From InningsBowlingDetails D
JOIN (Select D.Bowling_MemberKey, Max(D.Bowling_Wickets) as Wickets...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 21, 2012 at 4:18 am
mah_j (11/21/2012)
Thank you both for your comments.Does it have any effect,If i implement partitioning only on one drive ?
I will read more,and also focus on partitioning.
your question depicts that...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 21, 2012 at 2:35 am
anthony.green (11/20/2012)
Bhuvnesh (11/20/2012)
tonyarp05 61903 (11/20/2012)
But i have some codes,which takes min 30 to...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 20, 2012 at 4:45 am
tonyarp05 61903 (11/20/2012)
But i have some codes,which takes min 30 to 45mins.
Even i...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 20, 2012 at 4:34 am
can you post here, your databases configurations (their size ) ? additionally also check if there are any open transactions or not ? tempdb handles alot of stuff...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 20, 2012 at 4:30 am
So whats your requirement then ..Sorry i havent able to retrieve anyting from your miles- long script 😛 . you only need to post the stpred proc (which is...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 20, 2012 at 4:25 am
Jeff Moden (11/18/2012)
make sure that you have a good FILL FACTOR on the index for the GUID.
Please explain 🙂
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 20, 2012 at 3:44 am
see " user must change password on next login" in attachement
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 20, 2012 at 3:27 am
I guess you have chose the option of
change the password on next login
thats why it is asking for change password on every time. see this http://technet.microsoft.com/en-us/library/ms144284.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 20, 2012 at 3:24 am
Aspet Golestanian Namagerdi (11/19/2012)
I have enabled notification email when the job
are you using database mail ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 20, 2012 at 2:58 am
Robert Davis (8/7/2012)
Read my tempdb whitepaper: http://www.idera.com/Action/RegisterWP.aspx?WPID=37
its not working
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 20, 2012 at 2:33 am
Viewing 15 posts - 781 through 795 (of 2,462 total)