Viewing 15 posts - 12,526 through 12,540 (of 22,214 total)
Two things, first, if you make a change to security, you might break the app. It doesn't sound like it's been terribly well designed. Inevitably these types of apps require...
May 18, 2011 at 8:10 am
It could be that the trigger is the issue too. Can you just move the code into the stored procedure that does the insert?
May 18, 2011 at 8:06 am
GilaMonster (5/18/2011)
Grant Fritchey (5/18/2011)
May 18, 2011 at 7:50 am
Lowell (5/18/2011)
you'd want...
May 18, 2011 at 7:49 am
Ninja's_RGR'us (5/18/2011)
Grant Fritchey (5/18/2011)
May 18, 2011 at 6:20 am
If you're trying to isolate it for a restore or some other operation, set it to restricted user and use the ROLLBACK IMMEDIATE command. It will immediately cause all connections...
May 18, 2011 at 6:19 am
Yes, some of the counters are available from Dynamic Management Objects.
Take a look at sys.dm_os_performance_counters.
May 18, 2011 at 5:17 am
It's possible that you're hitting resource contention when running both these processes at the same time. I'm assuming users are also accessing the system? You may want to separate the...
May 18, 2011 at 5:15 am
There is no table where this information is stored, but you can look at the default trace to see if the information is available there. It would only not be...
May 18, 2011 at 5:12 am
And if the constraint is not valid, the optimizer won't use it for simplification, eliminating tables from joins when it can because it knows the data will be available in...
May 18, 2011 at 5:01 am
In general, except for data, most of the time the flow of structural changes is not from production down to a dev or test environment, but the other way, from...
May 18, 2011 at 4:59 am
You could create a table with the list of distinct database names and then run a query against that to provide a list of files for the backup. That's the...
May 18, 2011 at 4:56 am
The information is available, but it's not collected in a month-to-month fashion. You have to make that collection yourself. I'm assuming you don't have monitoring set up. I'd start there.
May 18, 2011 at 4:47 am
Steve Jones - SSC Editor (5/17/2011)
Grant Fritchey (5/17/2011)
True, but this one time, I'm taking the supposed high road. I've posted that I have sessions. I'm done. Vote or not. I'm...
May 17, 2011 at 10:09 am
Ninja's_RGR'us (5/17/2011)
Here's another option...
Excellent! I didn't want to bring it up, but this is a perfect solution, and one that uses very few disk resources to give you a perfect...
May 17, 2011 at 7:30 am
Viewing 15 posts - 12,526 through 12,540 (of 22,214 total)