Joe-420121 (3/22/2012)

---

I have to manage 100s databases, and update SPs, UDFs, and Functions periodically, and I do them all manually. How to automate these steps? Instead of doing them manually,...

bruce 1565 (3/22/2012)

---

If you're still interested in a Powershell method try this.

Add-Type -AssemblyName "Microsoft.SqlServer.Smo, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" -EA Stop

foreach ($server in $(Get-Content -Path serverList.txt)) {

$srvObject = New-Object...

I do not know of a way to handle this case natively from within SQL Server. One way to handle this outside SQL Server might be to create an application...

The more normalized the schema, the more overhead there will be in constituting a resultset that crosses many normalization boundaries, i.e. more joins will be necessary for your read operations....

It is hard to say with this level of detail.

By swap space, do you mean paging file? And by "large amount", what does that mean in terms of GB?

If the...

Good deal, happy to assist 🙂

I was thinking partitioning, but that would be overkill for the three tables. I would however look into partitioning for getting your arms around your 1TB table.

Back to the three...

OK, our individual use of terminology can be such a funny thing sometimes, I'm with you now, thanks for the clarification.

Is this going to be an ongoing need? If not,...

marno (3/20/2012)

---

Hi,

Can anyone please assist me in the best way to create and run a powershell script from my machine across multiple servers (with multiple instances installed) to obtain facet...

Since you have LPIM and AWE enabled it is most likely not SQL Server buffer pool pages being paged to disk, which is what we want on a server only...

Sounds familiar. What bitness of SQL Server are you running, and what is the command line you're running via xp_cmdshell?

You are not blocking anyone by trying to run the command to change the DB owner, the change-owner command itself is being blocked. You cannot change the owner of the...

My guess is the "4-week limit" is a UI limitation. The proc is not limited in that way. Not sure about the MP task.

Jack Corbett (3/16/2012)

---

Return values are rarely used to determine the status of a stored procedures execution. Normally you will either let the error bubble up to the client...

What did I wander into with this thread? 😛

My best guess is you have something running that has a memory leak. Can you restart the server after disabling each of...