Viewing 15 posts - 42,496 through 42,510 (of 49,571 total)
Please post table definitions, sample data and desired output.
Read this to see the best way to post this to get quick responses. http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 9, 2008 at 11:30 am
kotlas7 (12/9/2008)
- Logical Scan Fragmentation ..................: 2.31%
For an index, that's the most important one. Extent fragmentation is less important but should still be kept low.
December 9, 2008 at 11:10 am
If you have no experience with SQL 2008, then don't write the 2008 exams. They're not that much more difficult than the 2005 ones, but they do require that you...
December 9, 2008 at 11:09 am
Debbie Edwards (12/9/2008)
at the beginning of the script Ive got DBCC SHRINKDATABASE (MyDatabase, 20);
Why?
Is the entire job running within a transaction? Logs can only be truncated to the beginning of...
December 9, 2008 at 11:04 am
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...
December 9, 2008 at 11:01 am
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
Viewing 15 posts - 42,496 through 42,510 (of 49,571 total)