Viewing 15 posts - 5,506 through 5,520 (of 22,211 total)
CREATE PROCEDURE, and nothing else, should not be placing locks on tables. Further, CREATE PROCEDURE, and nothing else, should complete on most systems in an extremely fast fashion.
Are you certain...
September 23, 2015 at 6:50 am
That totally varies by company.
My last employer had four levels: Junior, DBA, Senior, Principal
We were part of the overall IT organization, under a VP responsible for Server Administration, SAN Administration...
September 22, 2015 at 4:05 pm
If it's only a small chunk of the overall database, you might look into building an Integrations Services (SSIS) package to do the move. Otherwise, for a subset, it's probably...
September 22, 2015 at 4:02 pm
jasona.work (9/22/2015)
I keep going back to the "Jet" topic, it's like watching a train wreck and I can't stop...
Absolutely NO intention of posting and feeding...
September 22, 2015 at 12:41 pm
Alina.Sotnikova (9/22/2015)
Please, help me with this question.
Give an example of a business use case where the knowledge you need to store would be best stored in an SQL database....
September 22, 2015 at 7:55 am
BL0B_EATER (9/22/2015)
Interesting, thanks for sharing your experiences. Deciphering the licensing document(s) is tough.
Yep. Pretty sure that's intentional.
September 22, 2015 at 7:47 am
BL0B_EATER (9/22/2015)
Grant with your SA can you leave your production server up and running during a DR test (and bring up your SQL Server over at your DR site too)?
We...
September 22, 2015 at 7:00 am
We just had Software Assurance. Made things easier when dealing with a large(ish) enterprise, especially DR, etc.
September 22, 2015 at 6:45 am
Wayne's explanation is excellent.
Just remember, similar is not same. Just because a query has similar structures doesn't mean it has the same structures. Those differences really do matter.
September 22, 2015 at 6:43 am
Sounds like it might be hitting a timeout on the DataStage side of things. I don't know how to adjust that in DataStage. But the description is how a client-side...
September 22, 2015 at 4:28 am
I'd use Kristen's approach for showing data without NULL values. Just don't use the same thing in the WHERE, HAVING or ON clauses because you'll cause table scans since that's...
September 22, 2015 at 4:24 am
Shelley Allen (9/21/2015)
But if it's set to 'secondary'. How do I just exit? I don't want the job to run if the DB is marked 'secondary'
(Sorry. ...
September 21, 2015 at 3:44 pm
Assuming it's a trigger, because that makes the most sense. It has to exist somewhere on the system. It's attempting to make calls to the missing database.
September 21, 2015 at 3:42 pm
I'm with NJ-DBA. What is AHCAuditAllObjects?
That procedure seems to be giving you issues. I can't find it in a search, so it looks like it's something you've created locally.
September 21, 2015 at 11:28 am
For more on sqldiag, check out this information from Microsoft.
It's a monitoring tool. Like all monitoring tools, it will cause additional overhead on your system. I would only turn it...
September 21, 2015 at 11:26 am
Viewing 15 posts - 5,506 through 5,520 (of 22,211 total)