Viewing 15 posts - 25,831 through 25,845 (of 49,552 total)
forsqlserver (5/31/2011)
The file size is around 1.12 Gb and it is notepad file.When it opens my system is becoming slow.
Well..... yes.
How much memory does your client machine have? I struggle...
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
May 31, 2011 at 6:27 am
Bear in mind that if you run query output to file you'll have to go and open the file to see the results, and the app you use to read...
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
May 31, 2011 at 6:19 am
Use the SQL Memory manager total server memory counter to see what SQL has allocated.
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
May 31, 2011 at 6:17 am
Triggers use tempdb to materialise the inserted and deleted tables. From the message (dbo.deleted) that's what's happening. Probably a trigger on a huge data modification and a tempDB that's too...
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
May 31, 2011 at 6:16 am
ashok.faridabad1984 (5/31/2011)
I mean different execution plan for non clustered and clustered index in the same situation. Reply will be highly appreciated .Thanks again.
Please go and read the article I...
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
May 31, 2011 at 5:49 am
Begin Transaction
Insert into Table1 (<column list>) Values (<Values list>)
Insert into Table2 (<column list>) Values (<Values list>)
Commit Transaction
You should add error handling if it's for real usage.
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
May 31, 2011 at 5:36 am
Sure, but that's a completely different thing to what the OP was doing. The rules for when SQL will do a clustered index seek are different to a nonclustered index...
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
May 31, 2011 at 5:35 am
Syed Jahanzaib Bin hassan (5/31/2011)
Create Clustered index and check the result
Unless he makes the address column the clustered index, that will have no effect. The index will still not be...
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
May 31, 2011 at 5:17 am
Then get more memory on your client machine.
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
May 31, 2011 at 5:15 am
Your client application doesn't have enough memory to hold all of those rows. This is not a database engine error
What are you trying to do that requires 13 million rows.
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
May 31, 2011 at 5:01 am
http://sqlinthewild.co.za/index.php/2009/01/09/seek-or-scan/
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
May 31, 2011 at 3:42 am
Are you absolutely sure that there's only one instance? Check Services, check SQL configuration manager
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
May 31, 2011 at 1:59 am
Where is it showing and what exactly is it showing?
Users can certainly be orphaned, databases however can't, so it's not completely clear what your problem is.
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
May 31, 2011 at 1:55 am
From what I understand, no, but it will help you track the source of the problem.
Ask your hardware people for the results of the memory diagnostics. "We're sure it's fine"...
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
May 31, 2011 at 1:36 am
Table definition please (pmddb..pmd_mpsp_ps_postn) and sample data.
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
May 31, 2011 at 1:32 am
Viewing 15 posts - 25,831 through 25,845 (of 49,552 total)