Silverfox (9/11/2009)

---

Do you know what really frustates me at times, is when someone posts after you have posted, and says, yes that is correct or says exactly the same as...

Business Intelligence Development Studio, usually referred to as BIDS, is a slimmed down version of Visual Studio that comes with the SQL Server install (client components) which is used for...

Adam Machanic (9/9/2009)

---

This one I can actually answer 😀

Put the eggs in the pan with cold, salted water

Bring to a boil

Immediately upon...

Ken,

I think the original point of this thread was that it seems like people aren't even putting the effort in to find the answer themselves, but are using forums like...

Have you verified that Named Pipes is enabled on the SQL Server using SQL Server Configuration Manager? You may need to force it to use TCP. See this...

I believe you need to use some javascript and url access to the report in the jump to url. See this blog post: http://blog-mstechnology.blogspot.com/2009/07/provide-hyperlink-to-open-in-new-window.html

You need to check the page_count for the indexes that are not being defragmented. If they only have a few pages the fragmentation will not be removed.

Look up the Data Conversion Task in SQL Server Books on Line (BOL).

No problem Paul, you just put me in good company.

Sirish likely has the best answer for fixing currently incorrect data, the real issue is to fix the data entry application.

Another option in SQL Server if the #...

You also need to take into account collation. Are they all the same?

I think that's your problem. Before running the rest of the script you need to change your database context...

Oh and then I remembered this article[/url] which may help you.

Someone else may come up with a better solution but this works:

WITH ctePayments AS

(

SELECT

ClientNumber,

MAX(DateOfEvent) AS PaymentDate

FROM

Fact_Events AS FE

WHERE

FE.EventType IN (10, 11)

GROUP BY

FE.ClientNumber

),

cteNonPayments AS

(

SELECT

ROW_NUMBER() OVER(PARTITION BY FE.ClientNumber ORDER BY...

Bitbucket has a good method. The other method that I would suggest is to use schema's as well as naming convention. It could be as simple as 1...