I only work on my production servers via RDP to my work desktop. It's just not worth any kind of risk being on VPN as well as having my...

My numbers in testing seem to line up with what you are seeing. Change the last query out to be:

SELECT

CAST(Size AS BIGINT)/1024 AS [Free size, KB]

FROM

VAS_Summary...

RBarryYoung (12/22/2008)

---

Frankly I am not seeing any evidence that you have a performance problem. The peformance...

You are seeing the nature of Sharepoint, you can't change how it behaves except as prescribed by Microsoft in KB articles and supporting documentation. Is there a specific problem...

Let me double check that query. I know it is one I provided elsewhere, but something could be wrong with it... I'll get back to you in a...

Steve,

Isn't the DAC enabled by default? You only...

You really need to goto x64. I can certainly understand that might not be an option, but for what you are trying to do x64 is so much better....

Jeff Moden (12/22/2008)

---

Kit Brandner (12/22/2008)

---

Consider the one exception I've encountered - generating a variable number of PIN codes according to a proprietary algorithm. There are easily several set-based approaches, but...

timothyawiseman (12/21/2008)

---

Two things of note though are that it is sometimes faster to code the procedural solution than it is to code the set based one, largely due to habit....

You should be able to do a inplace upgrade from Evaluation to Developer in 2008 without problems.

Be really careful implementing the recommended missing indexes from the DMV's. In some cases they will recommend a duplicate index with a different list of included columns. You...

The URL and example of doing this with SQLCLR is:

http://msdn.microsoft.com/en-us/library/cc655659(SQL.90).aspx

If you are open to SQL CLR, Microsoft has a TVF Sample that you can use to do it with a simple select statement.

Change the application to use connection pooling. It isn't a SQL Server problem.

Marios Philippopoulos (12/22/2008)

---

I tried it on our server last week (added -g384) and, after rebooting the server, I ran the attached query in my instance to determine the total and...