Domain controllers have nothing to do with the use of database roles. Database...

Don't give database users direct permissions to table. Give database role(s) access to the table, and add or remove database users from those roles as needed. When you...

Here is another one you can look at:

Defragmenting/Rebuilding Indexes in SQL Server 2005 and 2008

http://weblogs.sqlteam.com/tarad/archive/2009/11/03/DefragmentingRebuilding-Indexes-in-SQL-Server-2005-and-2008Again.aspx

Columns that are too large also use more CPU time even if they are cached in memory. When you scan a table or index, it has to pass through...

bump

hreisterp (12/29/2010)

---

Hello,

sorry. I missed the link. Now i read it. Quite interesting what you guys did there. But this all ends up in implementing a welln known algorithm in T-SQL...

Look at this thread:

http://www.sqlservercentral.com/Forums/Topic724575-5-1.aspx

1. Make sure the database to be moved is in full recovery mode, transaction log backups are being made at short intervals, and make sure they are retained at least...

hreisterp (12/28/2010)

---

Jeff Moden (12/28/2010)

---

hreisterp (12/28/2010)

---

OK. Another try... 😉

Used then outstanding LINQPad [/url]tool to do the same.

int[] data=data=Enumerable.Range(2,65536).ToArray(); // learned this today 🙂

var q = from s in data where !(from...

The code on the thread below uses the Sieve of Eratosthenes and Sieve of Aitken to find prime numbers.

Tests for the Sieve of Aitken returned all primes below 100,000 in...

Indianrock (12/27/2010)

---

Unfortunately I think dropping ORM would take an act of Congress. So far we don't have a data warehouse, but it is being discussed. No use of analysis...

GSquared (12/27/2010)

---

Michael Valentine Jones (12/24/2010)

---

Some people just don't take criticism well, no matter how nice you try to be about it, and things can quickly get nasty.

I tried to just...

Some people just don't take criticism well, no matter how nice you try to be about it, and things can quickly get nasty.

I tried to just stick to the facts,...

On the original subject of this thread, this is what Books Online says:

"SQL Server 2008 Books Online (August 2008)

Sorting Rows with ORDER BY

...ORDER BY guarantees a...

evald (12/16/2010)

---

Rarely...