lookup the INDEX= hint for the FROM clause in BOL. You can force a query to use a particular index. Now you can compare the query cost (show...

Lav, based on the nature of the questions you are asking I highly recommend you read a book or two on SQL Server 2005 development before continuing with your project....

Gaby Abed (12/3/2008)

---

Read the previously posted articles, but a quick summary:

1. If you have 64-bit windows, skip this step and go to step 2. If you have 32-bit...

Since you seem to have 12 drives available, I would use SQLIO and test several configurations. Search online for guidance on how to use that app and even for...

SQL Server only takes memory as it is needed. Perhaps you only have (or access) a few GBs of data?

DBCC MEMORYSTATUS?? search online for documentation.

Maybe you...

1) since this is SQL 2005, the best practice is to use ALTER INDEX ... to perform index maintenance instead of DBCC INDEXDEFRAG...

2) I don't know why you need to...

Ninja's_RGR'us (11/27/2008)

---

Great I'll be the first to put a bid on this... 80 hours @ 95$ / hour >>> that'll be 7600$ to check up on this. Plus whatever...

Reading this thread one thought comes to mind: Paresh, you REALLY need to hire an experienced person to help you both evaluate what form of High Availability will meet...

Forums are for small, targeted help situations. This is NOT that! 🙂 230 lines of code in a sproc with nested cursors referencing multiple tables with...

In addition to the update all statistics with fullscan, what about the configuration? Is the hardware identical and identially configured? Are sql server settings the same? Did...

I tried the following calls, all with same error:

SELECT dbo.MoneyToWords(99999999.99, 'dollar(s)', 'and', 'cent(s)')

SELECT dbo.MoneyToWords(1, 'dollar(s)', 'and', 'cent(s)')

SELECT dbo.MoneyToWords('9.99', 'dollar(s)', 'and', 'cent(s)')

SELECT dbo.MoneyToWords('1.10', 'dollar(s)', 'and', 'cent(s)')

1) I recommend Professional SQL Server 2005 CLR Programming by WROX

2) SQL 2008 will allow for large CLR types if needed. I didn't review the needs carefully, but I...

That looks pretty slick! A minor nitpick would be to use UNION ALL for populating the table variable. Also, if this were to be used regularly I would...