Without any table DDL, index definitions, queries used and query plan we can only guess.

Maybe because in the first query data was already presorted by an index, while in the...

BWFC (4/30/2014)

---

Koen Verbeeck (4/30/2014)

---

BWFC (4/30/2014)

---

Koen Verbeeck (4/30/2014)

---

Your point being?

Normally you only see this thread after you answered...

BWFC (4/30/2014)

---

There's a...

Your point being?

Normally you only see this thread after you answered the question.

Since you control the string that is to be executed, you can add some extra SQL to it.

For example:

DECLARE @SQLStatement NVARCHAR(1000) = '';

DECLARE @ID INT = 0;

SELECT @SQLStatement = Query,...

Interesting question, thanks.

For people who like an official reference:

ALTER TABLE (Transact-SQL)

ALTER COLUMN

Specifies that the named column is to be changed or altered.

The modified column cannot be any one of the...

Great question, thanks!

Not sure I am an expert, but I second...

You cannot take a log backup when you are in simple recovery mode (the log is recycled).

So it is either option 1, or option 2.

The log file keeps recording transactions until you take a log backup (unless in simple recovery mode).

If the log file grows, it's because it needs that space to log all...

Since you use the wildcard % at the beginning of the search term, you cannot index on that.

This means SQL Server has to scan the entire 100 million row table...

Maybe try a metaphor.

A very busy businessman has a few kids.

He can either drive them around town with his car to bring them to school et cetera and waste a...

If your log file is full and it isn't allowed to grow, the database can't do any transactions any more.

So you either make sure the log file is big enough...

Nice question, thanks.

SQL is delicious (4/25/2014)

---

Koen Verbeeck (4/24/2014)

---

Seems like an issue loading the assemblies needed for VB.

Did you try a repair of BIDS? (bit of a long shot, I know)

I think this...