GilaMonster (12/26/2012)

---

It's not lock escalation.

Truncate table locks at the table level because there's no other sensible level to...

zi (12/26/2012)

---

Dear Friends

1-1-How to know the fragmentation size for whole database not only for certain table, to decide if it exexceeds 30% to re-build index or re-organise.

2-what is the relationship...

OK so...

That looks like Oracle not SQL Server. SQL Server doesn't have a TO_CHAR function. 😛

I am willing to help you but you have to provide enough details for me to...

Thanks for sharing Scott. That gives me an idea of what you are doing here. Never really thought of using the extended properties like that. Gives me some cool ideas...

cleanup

headmanracer (12/26/2012)

---

I need some help with SQL to capture transactions posted 90 days prior to month end for the last 12 months. I have a table named TRANSACTIONS and...

Well unless you can share a LOT more details there is not much I can offer. This sounds like a challenging situation.

ScottPletcher (12/26/2012)

---

Sean Lange (12/26/2012)

---

ScottPletcher (12/26/2012)

---

Sean Lange (12/26/2012)

---

SQL_Kills (12/26/2012)

---

Hi,

First of all I hope everyone has had a good Christmas!

Just wanted to know if anyone documents there table using MS_Description? I'm...

WangcChiKaBastar (12/26/2012)

---

I have a stored procedure and when I run it First time it creates an execution plan and it takes long time to complete which is understandable after the...

This seems to be a representation of what you are looking for.

create table #Client

(

ClientID int identity,

Name char(2)

)

insert #Client

select 'C1' union all

select 'C2' union all

select 'C3'

create table #Orders

(

OrderID int identity,

ClientID int,

OrderName...

ScottPletcher (12/26/2012)

---

Sean Lange (12/26/2012)

---

SQL_Kills (12/26/2012)

---

Hi,

First of all I hope everyone has had a good Christmas!

Just wanted to know if anyone documents there table using MS_Description? I'm struggling to think...

You are right Adi. I was the one missing something. :blush:

Hugo Kornelis (12/26/2012)

---

Basics? That's not how I would describe it! :w00t:

Thanks for a good question, Sean. I think I once read or heard that after deleting all rows from a...

Great question. A bit hard to read through the formatting but is not the author's fault.