Viewing 15 posts - 42,496 through 42,510 (of 49,566 total)
Ultraedit's not free. If you're happy with the other text editors, use those
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...
December 9, 2008 at 10:48 am
Not enough information.
What does the ASP page need to pass to the server?
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.
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...
December 9, 2008 at 3:33 am
H. Nosrati (12/9/2008)
The SQl is standard edition. Does it make any difference?
No.
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.
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...
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
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.
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.
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
...
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)
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.
December 8, 2008 at 2:58 pm
Any errors in the error log when you try to use the DB?
December 8, 2008 at 8:21 am
Viewing 15 posts - 42,496 through 42,510 (of 49,566 total)