Good point, I hadn't considered the size limitation.

Just a note - it is not necessarily correct that this error indicates a backup file is corrupt. There could be versioning issues here - example, try to restore...

Hmmmm, it appears I don't have much of a point, but, if I did, it would be that it is not good practice to cast a variable unless it is...

Textfield is the field name... are we not saying the same thing? The textfield is not the same for both the variable and the temp test table. If...

Maybe, because there is confusion over C2 audit?

Limitations

The main limitation of the auditing is that it reduces the performance of the SQL Server. This happens due to saving the every...

Could call it a trick... in another form:

select * from(

select 'red'

union select 'red'

union select 'blue'

union select 'green'

union select 'yellow'

union select 'orange'

union select 'purple')x

where textfield like 'red' -- or...

When I read the question, I can see the semi-colon doesn't belong there and it looks like an error in the question. Many of us come from...

I found the Hartree reference quoted in the American Mathematical Society Journal from 1960... I had half hoped that the "6" in 1960 along with the six possible answers...

I have a...

MS is responsible for creating adequate documentation so the person answering the question can answer the question accurately

The panel I threw in because it seems all the other answers are...

When are Kim and Paul coming to Atlanta... this sounds like a great lecture.

Interesting question... adds to the sql vocabulary...

Guess I am a bit confused by the question

A sparse column must be nullable and cannot have the ROWGUIDCOL or IDENTITY properties. A sparse column cannot be of the...

If you are listening Steve, these CTE's are great fun and make great questions!

This is one I learned of the hard way. Who would have thought a Microsoft product would include case sensitivity but those who practice in csharp. The database...