Nice. You are welcome 🙂

--

SQLBuddy

Use this query ..

SELECT name,

[MB used] = SUM(single_pages_kb + multi_pages_kb)/1024.0

FROM ...

I think he is trying to normalize table 1 more to table 2. It's normalization problem... What's the PK of table 1

--

SQLBuddy

MyDoggieJessie (3/3/2014)

---

I'm embarrassed to say but I've little to no experience with the newer versions of SQL server beyond 2008. Recently, I got approval to upgrade to 2012 however,...

Robert Graff (9/11/2013)

---

Jack Corbett (9/11/2013)

---

I haven't done this in quite awhile, but I will say it sounds like you are just covering over the root of the problem...

Check if SQL Server is up and running ?

--

Best Regards,

SQLBuddy

Do you do Index Maintenance and index rebuilds ? Also see if you can find any missing indexes.

Is this 32 bit or 64 bit ? What are your memory settings...

Follow this advice from SQL ORACLE. It works

--

SQLBuddy

If you don't have replication, run this query and check the result ..

SELECT...

Dennis Post (3/3/2014)

---

Is this a 32 bit system? The memory pools used by SQL Server in a 32 bit system sometimes needed help. Especially if you were moving around a...

sram24_mca (3/3/2014)

---

Hi,

I am getting the following error in two SQL Server 2008 servers[Production]. This happens usually every two days for a month now. The SQL Server log dump is below.

SQL...

Rt Click on DB --> Tasks --> Shrink --> Files --> Change File Type to Log , Check the...

bubby (3/3/2014)

---

Hi!,

Need Help,

I have SQL 2008 R2, Database XYZ in simple recovery mode, the database log is growing very face, no maintenance in place, the log size grows about 1GB...

yuvipoy (3/3/2014)

---

What is the performance gain when we upgrade sql server 2000 to sql server 2008

apart from the new approaches like cdc, cte ,....(big long list)........

Here will i be gained...

Could you tell us why you are trying to move from...