Hey guys,

I got a fantastic response to the connect item I filed concerning the collation performance thing. Check it out at http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=512459

Extract:

Jim Hogg MSFT

---

I have assigned this report over...

Alias the table variable.

Correct.

If the maximum value for quantity is relatively small, or if you don't have a Numbers Table available, something like the following provides an efficient alternative:

declare @data

table (

...

The collation thing again. It'd probably be fairer to tweak each...

How shocking :laugh:

It would still be good to know that you are running the latest...

1-2GB free is plenty on a dedicated box. Don't worry about it.

See http://blogs.msdn.com/slavao/archive/2006/11/13/q-a-does-sql-server-always-respond-to-memory-pressure.aspx for more information.

If your Windows Authentication account has the appropriate permissions, you can use any of the usual methods, including Management Studio and ALTER LOGIN

These questions might be better asked of the Quest LiteSpeed support team 😀

You might also try The Quest Online Support Forums.

Often, these things come about when using a older version...

Bob Hovious 24601 (11/24/2009)

---

1. cte or subquery

2. numbers or tally table

3. thrice-damned cursor or elegant and efficient set-based solution

4. pork chop or steak

5. lightsabre, katana,...

ManoharV (11/24/2009)

---

Thanks Paul,

In our database there are around 3,000 procedures and as we are deploying our application in multiple location, we need some sort of encryption for...

:laugh: :laugh: :laugh:

Books Online

---

If string_expression is not of type varchar(max) or nvarchar(max), REPLICATE truncates the return value at 8,000...

Michael Meierruth (11/24/2009)

---

Very strange this MAX stuff on SS2005. The code below behaves very strange. I.e. I set a string to 8004 characters and yet the LEN function shows it...

Well, there is the WITH ENCRYPTION option of ALTER PROCEDURE, but it's pretty weak.

It might...

The...