Viewing 15 posts - 1,321 through 1,335 (of 2,356 total)
The only thing I can think of may be to backup across multiple files, and copy them in parallel.
We created a separate backup network. Each server has multiple...
October 30, 2018 at 10:55 am
October 26, 2018 at 9:34 am
October 25, 2018 at 12:21 pm
jonathan.crawford - Wednesday, October 24, 2018 12:35 PMSo you're saying, I just have to do better than him to work there?
Well,...
October 24, 2018 at 12:37 pm
October 24, 2018 at 10:27 am
Probably read this series of articles first.
http://www.sqlservercentral.com/stairway/112556/
There should be nothing else you need to do for developer edition.
October 23, 2018 at 3:04 pm
When I see something like this stated in a forum post, I kind of shut off.
I've got thirty years of experience with rdbms tuning, the last...
October 23, 2018 at 11:27 am
nick.hinton - Tuesday, October 23, 2018 9:21 AMTry using the Parsename function:
https://docs.microsoft.com/en-us/sql/t-sql/functions/parsename-transact-sql?view=sql-server-2017
Considering that the OP is using SQL 2008, that...
October 23, 2018 at 9:24 am
Read this article, and download the "DelimitedSplit8k" function.
http://www.sqlservercentral.com/articles/Tally+Table/72993/
You code, based upon the little bit of info you posted, would look something like this:
October 23, 2018 at 7:34 am
Paul Randall wrote a lot about this, it may help.
https://www.sqlskills.com/blogs/paul/corruption-demo-databases-and-scripts/
October 22, 2018 at 9:23 am
October 18, 2018 at 12:47 pm
Quick glance, The ActivityInstance table contains many more rows.
The A query is reading 177160 rows on the index seek, the D query is reading 16168215 rows on the same seek
October 18, 2018 at 12:30 pm
October 18, 2018 at 11:56 am
I cannot open either of the files. Or, better yet, I do not have the patience to work through .xml or a pipe separated file so that I can actually...
October 18, 2018 at 11:48 am
Can you post the actual execution plans?
October 18, 2018 at 10:40 am
Viewing 15 posts - 1,321 through 1,335 (of 2,356 total)