Thanks Paul! I'll take a closer look tomorrow morning.

The problem is you are saying that that column gets updated frequently. So every time you update that value, it has to move the data. That may be to another...

LGDBA (1/25/2012)

---

I have a sql server 2008 R2 production system with 32 GB memory and 26GB of memory is set as max memory for SQL Server rather than the default...

I think the first question is "does having the primary key and clustered index on an identity column and the partitioned column of datetime eliminate page splits when new data...

To the OP; the point is you cannot shrink a database smaller than the size of the data it contains. DBCC SHRINKFILE doesn't magically shrink the file while keeping all...

The only rationale that I can come up with is that you had highlighted everything up to, but not including, the WHERE clause and then executed the query. When you...

Can you please post the DDL for the PEOPLE_PROJECT table?

I see... So the query was being run in SQL Server Management Studio, not Visual Studio? Was the query typed in or was it copied and pasted? Do you have...

So, you are running this query in which part of Visual Studio? Is this...

fahey.jonathan (1/24/2012)

---

This may be unrelated, but I had a problem once with a query that acted very strangely. Long story short, there were unprintable characters in the texgt that...

Yes. Change this:

(CONVERT(char(10), a2.timestamp, 120) = @date)

to this:

timestamp > = @date AND timestamp < DATEADD(dd,1, @date)

EDIT: Grr... No matter what I do I cannot change the > to >...

Brandie Tarvin (1/25/2012)

---

Andrew,

I hate to break...

Great! However, don't discount...

For my own understanding... I assume you mean database DR, as I can see this being an acceptable solution for site outage;...

Try starting with this:

SELECT a1.timestamp, a1.Computer_Name, a1.Packet_Type, a1.User_Name, a1.Client_IP_Address,

CASE

WHEN a2.Packet_Type = 2 THEN 'Pass'

WHEN a2.Packet_Type = 3 THEN 'Fail'

END AS Status

FROM accounting_data_BU AS a1

INNER JOIN accounting_data AS a2

ON a1.timestamp =...