Why do you think a max body size of nvarchar(max) limits your email content to 4000 characters?

Have you run a test to see if it is actually limited to 4000...

I give people I interview a test of SQL questions, four that I expect that anyone worth hiring can solve, and one that I expect most people will not be...

Unfortunately, it is much more likely that management will look at the mounting costs of a long overdue project and set an ultimatum for the project manager like “If it...

I don't think you can use a local temp table with sp_send_dbmail.

Create a global temp table using newid() to generate the table name, and use that.

declare @temp_table_name sysname

set @temp_table_name =...

Following a consistent style is an important part of any system for several reasons:

1. It makes it easier to figure out what the last person was doing.

2. You don’t have...

You should avoid using global temp tables (##tablename), use local temp tables (#tablename).

This should a better way to check for a temp table. The other methods will have a...

The real fun will start when you do a large batch update that escalates to a table lock. When it finally completes after 4 hours, everyone can go back...

You might consider modifying the transaction table to include the balance at the end of the transaction. Then you will only have inserts to worry about. Add a...

I think that the support cycle fro SQL Server is too short for an enterprise level application. I think that 10 years of support after that next major software...

michael.welcome (5/9/2008)

---

Well I could post the company name, embarasing them in a public forum could be grounds for firing, so I will not. I have payments on my 2003...

I think these are a good reference for the usual relationship between DBAs and senior management.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=46783

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=63071

This is usually called an EAV (Entity, Attribute, Value) design.

Simply put, this approach is always a disaster. The disadvantages are so overwhelming that the small benefit they think they...

Why don't you ask the DBA to explain in detail why this is a good idea, and post what he says on this thread?

So how long will it be before Homeland Security requires all air travelers to have an RFID in their ear?

http://www.sciam.com/article.cfm?id=rfid-power

"Now Hitachi, the maker of that chip, is aiming even smaller....

Peso (5/7/2008)

---

Somewhat shorter code

SELECTCOUNT(*)

FROMmaster..spt_values AS d

INNER JOINmaster..spt_values AS h ON h.Type = 'p'

WHEREd.Type = 'p'

AND d.Number <= DATEDIFF(DAY, @Date1, @Date2)

AND h.Number BETWEEN 0 AND 23

AND DATEADD(HOUR, h.Number, d.Number + @Date1)...