Viewing 15 posts - 256 through 270 (of 614 total)
We're currently on a sql 2005 active/passive cluster and will probably be upgrading straight to 2012 eventually ( next year ). I don't fully understand Netapp snap technology yet,...
August 15, 2012 at 2:37 pm
Examples of ORM generated sql. Trust me, once this approach is entrenched its very difficult to change.
1. ORM generated query as application executes it with sp_executesql. This one...
August 15, 2012 at 9:21 am
Wow, that describes us perfectly. DBAs coming in very late in the game to try and improve performance when the ORM generates the SQL. We can tweak around...
August 13, 2012 at 3:05 pm
Vliet, you took the words right out of my mouth. I think our .Net, ORM, no-DBA database and application is also hampered by the fact that its serving as...
August 13, 2012 at 5:43 am
ok, what we're after is a) ability to kill the process and have that come to rest fairly quickly ( i.e. all prior transactions committed so only most recent needs...
July 31, 2012 at 2:26 pm
or this:
WHILE (1 = 1)
BEGIN
BEGIN TRANSACTION
UPDATE TOP (1000) [Order Details]
SET Discount...
July 31, 2012 at 2:00 pm
Thanks for the reply. Sounds like we just need to break these update statements down into chunks. No records are being deleted or inserted, just changing things like Name...
July 31, 2012 at 1:57 pm
I went ahead and removed builtin admins from sysadmin and found a monitoring account couldn't login. Gave that its own login to this sql server and then was able...
July 19, 2012 at 4:09 pm
The individual domain service account is directly a sql sysadmin, and also a sysadmin via a group called CM\Production Service Accounts.
I'm using this to check on ownership by builtin\administrators and...
July 19, 2012 at 1:08 pm
Yes those run under domain service accounts e.g. CM\sql_service
July 19, 2012 at 11:28 am
Fine so far. The trusts between domains are working so we havent had to change any logins
July 11, 2012 at 5:39 pm
Our Systems guys finally got most if not all of the domain trust issues worked out so now a migrated user can connect even if no new sql login has...
July 4, 2012 at 6:19 am
Well we have more testing to do. So far it seems that as people are migrated their old domain login is automatically disabled. One co-worker who has already...
July 3, 2012 at 5:55 am
Not sure if the domains have a trust, but would guess so based on the network admins confidence about things -- I'll ask.
As far as alter login, I was going...
July 1, 2012 at 6:57 pm
Too bad we don't get more OS and MS Office service packs instead of monthly patches.
May 7, 2012 at 1:05 pm
Viewing 15 posts - 256 through 270 (of 614 total)