Viewing 15 posts - 42,481 through 42,495 (of 49,552 total)
Paul will probably be along in a few hours. Or he might be on vacation.
Restore is always the preferred option. Repair is, in most cases, for when you can't restore...
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
December 9, 2008 at 11:01 am
Ultraedit's not free. If you're happy with the other text editors, use those
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
December 9, 2008 at 10:49 am
TheSQLGuru (12/9/2008)
Ballpark the optimizer will switch to scan when it estimates you are asking for somewhere between 8 and 15% of the total number of rows in the table.
Depends on...
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
December 9, 2008 at 10:48 am
Not enough information.
What does the ASP page need to pass to the server?
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
December 9, 2008 at 4:24 am
Can you post definition of the tblAankomsten table (along with any indexes), some sample data (as insert statements) and your expected results? I'm pretty sure this doesn't need a cursor.
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
December 9, 2008 at 4:20 am
Heisa (12/9/2008)
Hi,Here is the UDF,
It is a quite some text... But I don't see an option to attach a file in the post....
Right below the textbox where you type 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
December 9, 2008 at 3:33 am
H. Nosrati (12/9/2008)
The SQl is standard edition. Does it make any difference?
No.
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
December 9, 2008 at 3:10 am
Heisa (12/9/2008)
I am looking for the best way to optimize the process.
Change the insert statement so that it doesn't insert dupes.
If you want specific help, post the UDF.
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
December 9, 2008 at 2:53 am
As a guess, another case where float's inaccuracy gives problems. The number been cast back to decimal probably has too many decimal places to fit in the specified scale.
If...
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
December 9, 2008 at 2:43 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic615953-1291-1.aspx
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
December 9, 2008 at 2:38 am
You should always set a max memory on a 64-bit server. I have known SQL to starve the OS.
With 16 GB memory, set SQL's max to 14.
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
December 9, 2008 at 2:37 am
Sure. That's how I used to always read my log files.
Open in ultra edit and set the editor to reload changes any time it got focus.
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
December 8, 2008 at 3:30 pm
Sergei Zarembo (12/8/2008)
--can you try this: [not tested]
;WITH MyCTE as (SELECT TOP 1 c.ID, MRN
...
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
December 8, 2008 at 3:18 pm
I generally find it much easier and faster to open the error log in a good text editor (ultraedit, notepad++, etc)
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
December 8, 2008 at 3:06 pm
Shark Energy (12/8/2008)
Is there any point having multiple .ndf files within this secondary group if they are all sitting on the same raid array?
Not really.
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
December 8, 2008 at 2:58 pm
Viewing 15 posts - 42,481 through 42,495 (of 49,552 total)