Viewing 15 posts - 38,011 through 38,025 (of 49,552 total)
GSquared (6/30/2009)
My abilities in lexiphanicism are singularly singular, are they not? I'm capable of a highly affected, albeit effective, vocabulary, when I wish to effect the effect of lexicographicolatry.
And...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 30, 2009 at 1:54 pm
In my opinion there's only one case where you may not want this turned on.
If the same drive that's used for the SQL data files also contains (or did contain)...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 30, 2009 at 1:50 pm
Hi Sir ,
Please help me !!
I am trying to optimize one store procedure
The problem is when
I use EXEC store procedure , i am seeing table scan in execution plan
but when...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 30, 2009 at 1:32 pm
GSquared (6/30/2009)
john.arnott (6/30/2009)
3NF-Boy got me ROFL with this response:w00t:. I can't wait to see Gus's answer. 😉
No more waiting required. Let me know...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 30, 2009 at 1:30 pm
Roy Ernest (6/30/2009)
Today I actually felt that I am invincible or totally ignored. It was as if I was a ghost... 😛
:hehe:
Looks like totally ignored to me.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 30, 2009 at 12:17 pm
That's the first of a series of three. Did you read the others?
Again, if you want specific help, please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 30, 2009 at 11:32 am
Please read through this - Managing Transaction Logs[/url]
If it happens again, query sys.processes and see what the wait_types are.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 30, 2009 at 10:58 am
I suspect parameter sniffing of one form or another. http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/
If you want specific help, please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 30, 2009 at 10:35 am
Begins and ends just denote blocks of code in a stored proc.
CREATE PROCEDURE BeginEnd
AS
SELECT 'Before Begin'
BEGIN
SELECT 'Number 1'
END
BEGIN
SELECT 'Number 2'
END
BEGIN
SELECT 'Number 3'
END
SELECT 'After end'
GO
EXEC BeginEnd
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 30, 2009 at 10:29 am
Maxer (6/30/2009)
So what is the GO statement doing there?
Signalling the end of the batch and the end of the stored procedure. If you don't put that there, the GRANT EXEC...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 30, 2009 at 10:12 am
YSLGuru (6/30/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 30, 2009 at 10:10 am
nscott (6/30/2009)
However, now I have an issue with the specific update query I'm running. Not sure if I should create a new post.
Please do, as this has nothing to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 30, 2009 at 10:09 am
A permanently running server-side trace.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 30, 2009 at 9:50 am
Lynn Pettis (6/30/2009)
I don't feel like checking, was AWE enabled?
Yes. At least, it was enabled in the config that he posted, can't tell if /PAE was in the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 30, 2009 at 9:48 am
MichaelJasson (6/30/2009)
There is one requirement that I have to edit boot.ini file and make /3GB switch on in Vista:doze:.
Why do you want to do that?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 30, 2009 at 9:13 am
Viewing 15 posts - 38,011 through 38,025 (of 49,552 total)