Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 21924

SQL Server 2016 (major build version 13.00.xxxx). Please also tag sql-server.

1
vote
You can change the destination during the restore using the GUI. There are two options, on the Files page Option 1. Check "relocate all files to folder"; This allows you to select specific location …
answered May 13 by James Jenkins
3
votes
1answer
I have SQL 2016 Standard Edition instance with 40 logical processors in 2 nodes. (2x20=40) Per Recommendations and guidelines for the "max degree of parallelism" configuration option in SQL Server …
asked Feb 23 '18 by James Jenkins
4
votes
1answer
Query Store is available in SQL Server 2016+ and on Azure SQL DB it is on by default. With an on-premises SQL Server, it has to be started on each database individually. Is there a way I can have Que …
asked Jan 25 '18 by James Jenkins
3
votes
1answer
In the "Effectively Troubleshooting Latency and Failover of Always On" by Sourabh Agarwal At PASS on Friday, November 3, 2017 3:30" about 30 minutes in he talks about how Synchronous mode commits are …
asked Apr 10 '18 by James Jenkins
8
votes
In addition to the great answer by armitage you probably do not need to use DBCC CLEANTABLE in your scenario. You state Then I ran an index reorg on ALL indexes and reclaimed and additional 60GB …
answered Apr 5 by James Jenkins
2
votes
It is not possible. Everything includes granting access, which means they can change whatever access you give them. There are some encryption methods that can be used so DBA's can have full access b …
answered Sep 6 by James Jenkins
0
votes
I am not sure what your issue is here. When you restore the database, the data (mdf) and log (ldf) files have be on disk someplace. The WITH MOVE just tells SQL where to put them. You can't have a …
answered Sep 19 by James Jenkins
3
votes
I am not fully understanding your situation. There are a couple of things not mentioned in the question or existing answers. While taking backup data should not be changed in any case. Why? - A …
answered Sep 24 by James Jenkins
1
vote
2answers
I have a 3 node availability group (Enterprise 2014), it is multi subnet, with two data centers and file share witness in a third data center. There are about 20 "production" database that exist on th …
asked Jan 17 '18 by James Jenkins
4
votes
2answers
I want to start using Query Store with suggested setting by Erin Stellato. USE [master] GO ALTER DATABASE DatabaseName SET QUERY_STORE = ON GO ALTER DATABASE DatabaseName SET QUERY_STORE (OPERATION_M …
asked Jan 24 '18 by James Jenkins
2
votes
3answers
I have some queries that run against Query Store, the view sys.query_store_wait_stats is not in SQL Server 2016, but it is in SQL Server 2017. I want my queries to work in SQL Server 2016 and SQL Ser …
asked Jul 16 by James Jenkins
9
votes
2answers
Of the SQL system database (master, model, msdb, tempdb) query store can only be used on msdb. I looked and don't find any documentation about query store on msdb. While you can't see it in the GUI, …
asked Jan 25 '18 by James Jenkins
2
votes
To answer you question #3 If #2 is the best fix, is there any good way of preserving the data in Query Store that would be deleted? See How can I export Query Store data? it is not difficult in …
answered Aug 15 by James Jenkins
0
votes
Assuming from the image and design that the "prod server" is the primary OLTP server and that the "report server" is for reporting only. The AGs are probably set up with different Primary locations. …
answered Apr 6 '18 by James Jenkins
2
votes
As sp_BlitzErik mentioned in a comment, and as I gathered from my own research, you can find some things in sys.query_store_query_text but not necessarily always a SHRINK. This query returns 22,497 r …
answered Aug 22 '18 by James Jenkins

15 30 50 per page