Make the link clickable:

https://support.microsoft.com/en-us/kb/303528

erichansen1836 (9/15/2015)

---

WHEN TO USE:

SQL SERVER

========

* For Network or non-Network Databases larger than 5 Terabytes and 25 Billion rows - use SQL Server

* For Network Databases smaller than 5 Terabytes and...

ScottPletcher (9/15/2015)

---

Lynn Pettis (9/15/2015)

---

Ed Wagner (9/15/2015)

---

If your DateDetailDisposed column is a datetime data type, you might run into a performance problem here....

Ed Wagner (9/15/2015)

---

If your DateDetailDisposed column is a datetime data type, you might run into a performance problem here. Applying a...

Not as good at commenting my code as I would like, but working on it.

I...

Wayne West (9/14/2015)

---

I'll be honest: I currently do not use a version of VCS. I did back in the Dos days using BRIEF, someone came out with a source...

Try using the new system views since it looks like you are using SQL Server 2012. Check out this one: sys.sql_modules.

Please note that you may not see the entire...

When talking to recruiters, try to find ones with a headhunter mentality, not those that are just trying to fill slots or meet quotes. Those with a headhunter mentality...

ScottPletcher (8/25/2015)

---

I think you can combine the two queries, possibly if will perform better, esp. if the joins are a lot of overhead. As to the joins, they seem...

Ed Wagner (9/14/2015)

---

Lynn Pettis (9/14/2015)

---

Ed Wagner (9/14/2015)

---

Will this work for you?

SELECT so.name table_name, sc.name column_name, fk.name fk_name, so_fk.name references_table, sc_fk.name referenced_column

FROM sys.objects so

INNER JOIN...

Ed Wagner (9/14/2015)

---

Will this work for you?

SELECT so.name table_name, sc.name column_name, fk.name fk_name, so_fk.name references_table, sc_fk.name referenced_column

FROM sys.objects so

INNER JOIN sys.columns sc on sc.object_id...

Here is a start using the system views. You would need to do some work to get things like VARCHAR(100), VARCHAR(MAX), DECIMAL(18,6), etc.

select

tab.name tableName,

...

krypto69 (9/14/2015)

---

I just noticed that allot of the fragmentation seems to be on HEAP tables.

So if I exclude the HEAP tables I still have 100 tables that have fragmentation over...

How big are the tables with 70% fragmentation? What is their page size?

I am not interested in rolling my own DBMS even if part of it is done for me, the Jet engine. Everything you have been writing from scratch is...