Brandie Tarvin (1/27/2012)

---

If your updates are going to cause a lot of fragmentation, and frequent fragmentation at that, then it is advised you check your database maintenance jobs and verify...

Grizzly Bear (1/27/2012)

---

When a Clustered index gets updated, do all the Non Clustered Indexes gets rebuilt ?

My guess is yes. But want to understand the underlying mechanism.

My...

ross.mason 49698 (1/26/2012)

---

That is so much more elegant that the one I wrote, and works like a champ

Thanks for getting back so quickly. I will try to adhere to the...

ross.mason 49698 (1/26/2012)

---

Is this script the best way to compare OrderAmount to the previous months OrderAmount and then show both this months and last months OrderAmount in the same snapshot...

Matt Miller (#4) (1/23/2012)

---

sturner (1/23/2012)

---

Matt Miller (#4) (1/23/2012)

---

So developers and DBA's are on the hook for not spitting out solutions they don't understand, but it is imperative to remember that...

GilaMonster (1/20/2012)

---

Yes, they will,...

GilaMonster (1/20/2012)

---

Just one correction:

Non-leaf level entries contain only index key columns and the pointer to a lower level page. Included columns only exist in the leaf level entries; they...

guerillaunit (1/19/2012)

---

I have a date column that displays as "12/1/2011" in Access. I noticed that if I write a Select statement in Management Studio, I get no results when...

stebennettsjb (1/19/2012)

---

Hi all,

Im trying to create an inventory of all our SQL instances. Ive been using SQLCMD -L for one source of where all the instances are. But noticed...

Divine Flame (1/19/2012)

---

carmellabanker (1/19/2012)

---

SQL Server Enterprise Manager allows for enterprise-wide configuration and management of SQL Server and SQL Server objects. SQL Server Enterprise Manager provides a powerful scheduling engine, administrative...

Jeremy... (1/18/2012)

---

Is this in the BI studio? I'm not seeing "report" in the properties box....

http://technet.microsoft.com/en-us/library/dd255278.aspx

for some reason the reply I'm quoting to has the link as:

http://www.sqlservercentral.com/Forums/%3Cbr%3Ehttp://technet.microsoft.com/en-us/library/dd255278.aspx%3Cbr%3E

Jeremy... (1/18/2012)

---

Hey Guys. I'm new to the forum and wasn't able to find this issue anywhere so here we go.

My reports often have a couple hundred lines...

Bex (1/17/2012)

---

I like the system here. I don't look at points totals. They are fairly meaningless other than a gauge of overall activity. Rehashing a previous poster in...

L' Eomot Inversé (1/16/2012)

---

patrickmcginnis59 (1/16/2012)

---

PaulB-TheOneAndOnly (1/16/2012)

---

Please do not take it the wrong way but, out of curiosity, why is the subject of this thread "my favorite normalization case study" if...