Brandie Tarvin (4/30/2010)

---

Have you tried right-clicking the Logshipped DB in SSM and going to Properties? You should be able to change the owner there.

Then again, I don't have a logshipped...

Grant Fritchey (4/19/2010)

It's going to vary from situation to situation, but the potential for it to have very large impact and take tempdb offline for a considerable length of time...

Ok, I know that this query is bad and needs to be redesigned. I also know that the tempdb will not release the space back to the OS, which...

Ok, will try to resurrect the topic again. It looks like the below query no longer works in SQL 2005. Is there a reason why? It looks...

In my case I had a problem uninstalling IS or upgrading it to...

Ok, the problem got solved by setting the following registry keys (for Service Pack 2 and the hotfix):

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Products\<Product Code>\Patches\<Patch Code>

MSI3 1

Patch Type 0

State 2

Uninstallable 1

lmu92 (3/21/2010)

---

Roust_m (3/21/2010)

---

Both estimated...

Paul White NZ (3/19/2010)

---

Not easy. One way is to show that the procedure cache is...

Both estimated and actual,...

Paul White NZ (3/19/2010)

---

Roust_m (3/15/2010)

---

Sorry, I got one thing wrong here, the execution time is about the same for 5 records on both servers if I use:

SET STATISTICS TIME ON

SET...

Paul White NZ (3/18/2010)

---

If it really concerns you, take a look at Forced Parameterization. Be sure you fully understand the implications before testing it.

Unless you can show that procedure...

Up! 🙂

Up! 🙂

I've tried to get the actual plan for this query:

SELECT * FROM [MyDB].[MySchema].[GetHashTable] (

'SomeValue'

,1)

Which calculates hash values for 11k records from a table, but did not get the "memory_grant" line...

It looks like the plan only...