Viewing 15 posts - 1,336 through 1,350 (of 5,394 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...
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...
November 7, 2013 at 9:15 am
WHat about dropping the temp tables explicitly then?
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...
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...
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...
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"...
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.
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/
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.
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.
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...
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...
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...
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
October 31, 2013 at 5:29 am
Viewing 15 posts - 1,336 through 1,350 (of 5,394 total)