Viewing 15 posts - 1,336 through 1,350 (of 5,393 total)
I feel your pain.
Been there, done that.
It still hurts 🙂
Talk to the DEVs and make them do the right thing. It may look too complicated in the beginning, but it's...
-- Gianluca Sartori
November 7, 2013 at 9:33 am
In SMP all processors shared the same RAM with no difference between local and foreign memory. In this case, the bus between RAM and CPU was the bottleneck, as it...
-- Gianluca Sartori
November 7, 2013 at 9:15 am
WHat about dropping the temp tables explicitly then?
-- Gianluca Sartori
November 7, 2013 at 9:10 am
I don't see how this belongs to a SQL Server forum...
However, 80070005 means "access denied".
I wrote an article about DCOM permissions for a totally different thing (Linked Servers), but should...
-- Gianluca Sartori
November 7, 2013 at 7:41 am
My question is why the NUMA is not benefitting here by provide foreign memory (from other nodes).
That's the whole point of NUMA. Local memory preference improves contention issues.
Does above...
-- Gianluca Sartori
November 7, 2013 at 7:36 am
I all those windows use a separate database connection, you don't need to use a different temporary table name. SQL Server will handle that for you.
As far as the "memory...
-- Gianluca Sartori
November 7, 2013 at 7:31 am
It's the way SQL Server treats remote queries with sp_prepexec.
The query you're executing is translated into a pass-through query to the linked server.
I can't find any documentation, though.
Google "sp_prepexec" "pass-through"...
-- Gianluca Sartori
October 31, 2013 at 1:10 pm
There's no DDL event for that as far as I know. Sorry.
Moreover, I still think it's not a good idea.
-- Gianluca Sartori
October 31, 2013 at 11:14 am
I modified my script for you.
Here it is: http://spaghettidba.com/2013/10/31/copy-user-databases-to-a-different-server-with-powershell/
-- Gianluca Sartori
October 31, 2013 at 11:10 am
The two servers should be able to communicate via SMB (shared folder), FTP or any other method.
In my script SMB is used.
-- Gianluca Sartori
October 31, 2013 at 10:56 am
I don't think there's a DDL event for GRANT/REVOKE permissions.
Let me reiterate: you're doing it wrong.
You either have permissions to do something or you don't.
-- Gianluca Sartori
October 31, 2013 at 10:00 am
I'm not sure I follow your logic.
As you wish, anyway.
DDL triggers can capture the ALTER LOGIN statements. You just need to ROLLBACK in the trigger code to prevent the action...
-- Gianluca Sartori
October 31, 2013 at 8:35 am
Sorry to insist, but if other DBAs (sysadmin) want to alter/drop a login, they have the rights to do it.
If they don't have that right, they shouldn't be sysadmin in...
-- Gianluca Sartori
October 31, 2013 at 5:54 am
spaghettidba (10/31/2013)
Powershell is the way to go.I posted a similar script on my blog. You can find it here[/url].
If something is unclear to you, feel free to ask.
Hope this helps
Actually...
-- Gianluca Sartori
October 31, 2013 at 5:43 am
Powershell is the way to go.
I posted a similar script on my blog. You can find it here[/url].
If something is unclear to you, feel free to ask.
Hope this helps
-- Gianluca Sartori
October 31, 2013 at 5:29 am
Viewing 15 posts - 1,336 through 1,350 (of 5,393 total)