Viewing 15 posts - 4,786 through 4,800 (of 49,571 total)
Start by replacing the split function (which is probably an inefficient one) with the DelimitedSplit8K[/url] from this site.
If the query is still slow after doing that, please post table definitions,...
September 10, 2015 at 7:51 am
Have you checked the replication agent logs for errors?
September 10, 2015 at 7:06 am
2012 added the ability to create custom server-level roles. In 2008 there was no point in denoting what server-level roles were built-in, because they all were.
September 10, 2015 at 6:31 am
Yes.
As a once-off, after something unexpected happened, shrinking a log is fine. Do not shrink on a regular basis and make sure you've figured out and fixed whatever caused the...
September 10, 2015 at 6:30 am
If the job is already running, it won't start a second time.
In your example, after the job has completed, on the next 1 minute interval it'll start again.
September 10, 2015 at 6:27 am
Couple strange things.
If you are seeing 200GB free (not 200MB), then one or all of those SQL instances aren't using all their memory. The combined max server memory is over...
September 10, 2015 at 3:26 am
Set the job to output to a file, so that we can see the full messages. There's no error in the fragment you posted.
September 10, 2015 at 2:51 am
Best thing would be to discuss this with your thesis advisor or a professor at your university. Also, review the existing literature. The google scholar and microsoft academic search engines...
September 9, 2015 at 3:39 pm
See my earlier comments about spoofing the program name. If you suspect that this person may know how to do that (or might use google to find out how), then...
September 9, 2015 at 3:35 pm
No. @@rowcount returns the number of rows affected by the previous statement, that's it.
September 9, 2015 at 7:27 am
Blackdog (9/9/2015)
So, am I right in saying I could substitute the word AlwaysOn for High Availability?
No. Well, not if you want to be understood by others anyway.
I was thinking AlwaysOn...
September 9, 2015 at 7:26 am
Very simple.
Always On Availability Groups is Enterprise Only.
September 9, 2015 at 6:17 am
Query results/messages aren't stored, so without custom logging on SQL Server to log error messages, no.
September 9, 2015 at 5:56 am
That's not going to be adequate. There's different stuff in master for a clustered SQL instance.
Uninstall SQL and reinstall is as a clustered instance.
September 9, 2015 at 5:29 am
Restore the full backup. Restore the log backup WITH STOPAT '08:00'
Once you've done that, fix this backup strategy as it allows a full day's data loss. If a full day...
September 9, 2015 at 5:26 am
Viewing 15 posts - 4,786 through 4,800 (of 49,571 total)