Viewing 15 posts - 16 through 30 (of 42 total)
It will have negligible impact. These are backups of the transaction logs. Transaction logs are broken into VLFs (virtual log files) which are many mini buckets within the transaction log...
January 28, 2019 at 12:50 pm
That was the first thing I did on day 1 here. The application was extremely slow. The MAXDOP was set at 0, so a query would come along and grab...
January 25, 2019 at 5:05 pm
Thanks, Jeff
Our DEV box has 2 CPUs.
January 25, 2019 at 2:35 pm
I am completely on board with everything said. My issue is we have a C# development team who have been tasked to begin writing their own TSQL. But neither I,...
January 25, 2019 at 1:19 pm
Check all statements from the app, not just RPC. There could be a rollback. Is this in an Availability Group? Does the app's connection string have a READ_INTENT=TRUE? Does the...
January 24, 2019 at 6:51 pm
Thanks
I have that hanging in my bedroom already.
Yeah ... right.
Maybe I can hang it in my bathroom ... hmmm ...
January 24, 2019 at 4:54 pm
The user is in a security group and all of the users in that group are experiencing the same thing.
January 24, 2019 at 4:52 pm
Yeah, not when the user can script the indexes just fine. Just not the filter.
It is odd.
It's like the filter is part of some slightly...
January 24, 2019 at 4:46 pm
The filter_definition is NULL, but when I run it, it has the WHERE clause.
I know, crazy
January 24, 2019 at 3:42 pm
Thanks, Grant. Found it.
Great tool to use, especially with...
January 24, 2019 at 12:27 pm
No, that just tells a query it's OK to use additional processors in parallel if it thinks it needs them. What I am talking about is if your development instance...
January 23, 2019 at 9:28 am
I have had the need to do this as well. As Aaron points out, referential integrity will need to be maintained in order for your subset to make any sense.
January 22, 2019 at 4:14 pm
Dig into the server setup for Always On. You will create a cluster, just not a failover cluster, with the nodes you want. In your case, it sounds like you...
January 21, 2019 at 2:59 pm
Interesting.
I was able to connect to mine as mentioned above.
Check the SSRS log for clues.
February 13, 2018 at 1:37 pm
Browser plays no role in your ability to connect. Ensure you are an Admin on the Site Settings and have the fully qualified path to the Web Service URL (found...
February 13, 2018 at 12:32 pm
Viewing 15 posts - 16 through 30 (of 42 total)