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 39083

SQL Server 2014 (major build version 12.0.xxxx). Please also tag sql-server.

2
votes
I had to reread the vendor requirements a couple of times, but I take the instructions to mean the local administrator account only requires elevated permissions during installation. Run one of the f …
answered Nov 16 '16 by John Eisbrener
0
votes
It's likely that your Test-User account has different SIDS on the primary and replica servers. The best way to resolve this is drop the Test User on the Secondary, generate a create user statement fr …
answered Jun 19 '17 by John Eisbrener
3
votes
Your new index isn't covering the query as it's missing the load_ID column from the INCLUDE statement (which incidentally is also missing from the index definition). Recreate the index including the a …
answered Jun 21 '17 by John Eisbrener
1
vote
I fully expect down-votes on this, but deprecated doesn't mean discontinued. When a feature is deprecated it generally means that said feature won't be expanded and will likely be removed in a future …
answered Aug 21 '17 by John Eisbrener
13
votes
If you detach a database from an instance, you will need to perform an OS-level delete of the file. The safer approach is to drop the database instead. What I suggest is taking a final backup of the …
answered Aug 21 '17 by John Eisbrener
2
votes
Design is largely driven by personal preference, and I don't have enough context to tell you if you're approach is one I would agree with or not. However, if you wish to proceed with your current set …
answered Sep 30 by John Eisbrener
5
votes
A few things here that have not already been mentioned. First, is that a UNIQUE constraint can also be used for Referential Integrity. Per the BOL article on Unique Constraints and Check Constraints …
answered Aug 28 '17 by John Eisbrener
2
votes
While the rotating passwords are a hindrance, they don't negate any approaches available. Kendra Little does a great job of explaining a general approach to patching servers in an automated fashion i …
answered Aug 1 '17 by John Eisbrener
0
votes
The Import/Export wizard generally makes pretty basic 2-step packages. For instance, I quickly made one that migrates two tables from databaseA over to databaseB, and the Control Flow of the generate …
answered Jul 21 '17 by John Eisbrener
5
votes
I'm adding to Trubs' answer above, which you should upvote as (s)he's on the right track, but I'm adding more options here as well: Add more space (as stated above) If you have a high amount of aver …
answered Oct 8 by John Eisbrener
1
vote
My initial suspicion is that the initial setup didn't include the fully qualified name, but check for certain with the following statement: SELECT ag.NAME AS "Availability Group" ,ar.replica_serv …
answered Jul 27 '16 by John Eisbrener
1
vote
Chances are something in the backup history tables got out of sync and the UI is going to the last "consistent" full backup. If you're really interested in why it's doing what it's doing, start a pro …
answered May 18 '16 by John Eisbrener
1
vote
If you're looking for quicker performance, you may want to initially run DBCC SHRINKFILE using the TRUNCATEONLY option. Per BOL: TRUNCATEONLY Releases all free space at the end of the file t …
answered Sep 27 '17 by John Eisbrener
12
votes
You can bypass the 8000 character limit of OPENQUERY by utilizing EXECUTE AT, as follows: DECLARE @myStatement VARCHAR(MAX) SET @myStatement = 'SELECT * FROM TABLE WHERE CHARACTERS.... ' -- Imagine t …
answered Oct 3 '17 by John Eisbrener
1
vote
After each back up (log, diff and full) I'd like to delete all the files on the local disk. Will SQL Server notice this? Unlike other database solutions, such as Oracle, SQL Server does not nativ …
answered Dec 3 by John Eisbrener

15 30 50 per page