Viewing 15 posts - 7,936 through 7,950 (of 49,571 total)
Koen Verbeeck (9/3/2014)
xsevensinzx (9/3/2014)
September 3, 2014 at 8:13 am
Nope. A member of the Sysadmin role can see everything, cannot be denied any rights. A Windows Admin can be slowed down, but cannot be prevented from accessing the databases...
September 3, 2014 at 7:58 am
John's already answered that
John Mitchell-245523 (9/3/2014)
Better to join PAT_ACCOUNT_MANAGER to the Inserted table to do the deletes, rather than attempt to get the IDs into a scalar variable.
September 3, 2014 at 6:35 am
Please don't cross-post.
No replies here please. Replies to http://www.sqlservercentral.com/Forums/Topic1606251-1632-1.aspx
September 3, 2014 at 6:31 am
Please don't cross-post.
No replies here please. Replies to http://www.sqlservercentral.com/Forums/Topic1606251-1632-1.aspx
September 3, 2014 at 6:24 am
Still won't handle multiple row inserts.
Any time you fetch values into a variable, your trigger won't be able to handle multiple rows. You need to get rid of all those...
September 3, 2014 at 6:19 am
AppSup_dba (9/2/2014)
DB size - 300GB
Log drive size 100GB.
VLF count 750.
growth rate 1000MB
And take 2-3 hours...
September 3, 2014 at 6:17 am
jacksonandrew321 (9/3/2014)
U can shrink the log and use simple recovery mode or shrink database files.
No, please don't recommend shrinks. They really shouldn't be run without a good reason....
September 3, 2014 at 6:13 am
ramana3327 (9/2/2014)
2) We can't use for very large queries because it will impact the memory
Nope, nothing to do with the query size.
3) Just this feature is for small queries...
September 3, 2014 at 4:14 am
DBA From The Cold (9/3/2014)
Your database is going into recovery mode probably because of some form of corruption.
Really? What form of corruption sends a DB into the recovering state?
September 3, 2014 at 4:13 am
Distributed Replay will do the job. See Books Online for details
Seriously though, In-memory tables are NOT for general usage. They're a specialised solution to specific problems. Not something to use...
September 2, 2014 at 3:53 pm
Huh? Your question makes no sense.
A sandbox is a test area, somewhere people can test and investigate things without breaking anything. It has nothing to do with MOSS and nothing...
September 2, 2014 at 3:32 pm
Look in the 2008 and 2012 Books Online for deprecated features.
September 2, 2014 at 3:23 pm
Lynn Pettis (9/2/2014)
Walked away since it seemed you had it handled. 😀
I thought I did. Now, not so sure...
September 2, 2014 at 2:44 pm
"The inserted table only contains the rows inserted into the table. I need rows from other tables as well. Hence I can't use a set-based solution"
Err.. ok...
September 2, 2014 at 2:18 pm
Viewing 15 posts - 7,936 through 7,950 (of 49,571 total)