Viewing 15 posts - 4,126 through 4,140 (of 7,191 total)
Have you tried the dm_os_performance_counters DMV?
John
March 22, 2013 at 5:32 am
SQL ORACLE (3/20/2013)Shrinking the database such that it has zero available space is requested by our users. They use ithe database for creating reports.
You're the database professional - it's OK,...
March 20, 2013 at 9:11 am
What are the differences between your login and the SQL Server Agent account login? Default database? Language? Anything else?
Does your package do anything user-sensitive, for example INSERT...
March 20, 2013 at 9:06 am
There's a limit to how small you can shrink a database. I can't remember off the top of my head what it its - I think it's either the...
March 20, 2013 at 8:47 am
What error message are you getting when you run it as a job? Does the package use package configurations? Could it be that the configuration settings are being...
March 20, 2013 at 8:44 am
Drndrb (3/15/2013)
If the job is run by SQL agent. Restart SQL agent. The altered env var will then get picked up.
No need. He's using a SQL table package configuration,...
March 15, 2013 at 2:39 am
From your brief description, I'd say you need a calendar table. Have a read about that - there should be some stuff on this site about it.
John
March 14, 2013 at 6:53 am
Failing over a clustered instance is, in effect, stopping it on one node and starting it again on another. So you should expect everything that happens when you stop...
March 14, 2013 at 6:46 am
If you can't see SQL Server Agent, it may be because you don't have the necessary access. Are you a member of the sysadmin server role, or a member...
March 14, 2013 at 4:03 am
This is because you're trying to configure things that don't exist in the package. If you're sharing one configuration file (or configuration table) between packages, the packages need to...
March 13, 2013 at 11:16 pm
The requirements on many job descriptions are more of a fishing exercise than a statement of reality. You'll probably find your two years' experience qualifies you for quite a...
March 12, 2013 at 10:25 am
Or you can use xp_logininfo. No linked servers, no loops, no "foreign" languages.
John
February 12, 2013 at 7:38 am
The REPLACE statement doesn't update the table for you. All it does is return the first expression but with any occurrence of the second expression replaced by the third...
February 12, 2013 at 7:30 am
Steve
I understand. You may still have a missing index, I suppose. In any case, do the SET STATISTICS IO ON thing as I suggested - you'll then be...
February 7, 2013 at 8:59 am
Try using SET STATISTICS IO ON next time you run it for the first time in a few hours. Save the results, and then run it again and compare...
February 7, 2013 at 7:55 am
Viewing 15 posts - 4,126 through 4,140 (of 7,191 total)