Viewing 15 posts - 4,786 through 4,800 (of 49,552 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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2015 at 7:51 am
Have you checked the replication agent logs for errors?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2015 at 3:35 pm
No. @@rowcount returns the number of rows affected by the previous statement, that's it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2015 at 7:26 am
Very simple.
Always On Availability Groups is Enterprise Only.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2015 at 5:26 am
Viewing 15 posts - 4,786 through 4,800 (of 49,552 total)