I would also change your autogrowth to grow by a set size each time. Growing by 10% means each time it grows, it will grow by 10% of its...

Peter,

I just took the time to read your article above. I wish I had know about it as I was doing my article, I would have put a...

To all those who are noticing some issues with some of the code in the article. I will contact Steve about making some corrections. The code in the...

Okay, I saw a slight mistake in mine, which I noticed after looking at noeld's version. Mine and noeld are very similiar, his however will also work in SQL...

Since you posted this in a SQL Server 2005 forum, I am assuming you are using SQL Server 2005. Try this and see if it works for you.

with SumAcres...

I can't provide specific help, but you might want to look at SMO. My guess would be to start with BOL and go from there.

😎

Which is a good thing. I wish more people needing help would read that article and follow the procedures outlined. Jeff Moden did an great job with that...

Steve was right, all you need is a HAVING clause as shown below:

SELECT

fund_vintage,

count(fund_vintage) as NumFunds

FROM

#tmpRR_Testing

GROUP BY

...

I am going to need more to help you out. Please read this article, it will show you how to help up help you:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

😎

A GROUP BY assumes you are aggregating some data in your select statement. That was the question I also asked in my previous post.

Now my question is, what are...

Read this article, it will help you with everything you need to allow us to help you:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

😎

Start with this:

select

rightt.*,

leftt.*

FROM

#temp2 leftt

left outer join #temp1 rightt

...

based on this:

(CONVERT(nvarchar, FireBrigade_ShiftFallows.ActualStartDate, 102) = CONVERT(nvarchar, @date,102))

I'd do this:

FireBrigade_ShiftFallows.ActualStartDate >= dateadd(dd, datediff(dd, 0, @date), 0) and

FireBrigade_ShiftFallows.ActualStartDate < dateadd(dd, datediff(dd, 0, @date) + 1, 0)

😎

We had a similiar, yet different, problem between two PeopleSoft production servers. We had to configure DTC on both servers to fix the problem even though the data transfer...

Just to be sure, did you modify the DTC settings on both servers?

😎