Search Results
| 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 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| 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 sql-server-2014
Search options not deleted
user 8783
SQL Server 2014 (major build version 12.0.xxxx). Please also tag sql-server.
1
vote
Mystery Backup Database Job
The mystery backups just show a long alpha-numeric string in curly brackets. Anybody know what this is?
This might be a 3rd party software using Volume Shadow Service (VSS) backup .
I would l …
- 62.4k
4
votes
What does it mean when a table is listed with fragmentation?
Dont try to reinvent the wheel as there is a cost to reinventing it.
Use Ola's maintenance scripts - they are tested well enough and follow best practice. You can even use LockTimeout in Ola's soluti …
- 62.4k
2
votes
Problem with Script to Synchronize Login on AlwaysON
I would suggest using dbatools - Sync-DbaAvailabilityGroup with -Exclude <-- exclude the settings that you dont need to sync.
Honestly, you should sync all e.g. sp_configure, logins, jobs, etc
- 62.4k
1
vote
Accepted
Need to move backup folder
For backup folder :
If you mean the default backup folder as configurable in server properties --> database settings
You can easily change that location to the one you want. If your SSD has only …
- 62.4k
1
vote
Updating dbi_dbccLastKnownGood
I agree with Martin on running CHECKDB to make sure that you do not have corruption.
Relying on dbi_dbccLastKnownGood does not tell you the full truth if DBCC CHECKDB was ran clean on the database.
Fo …
- 62.4k
3
votes
clustered index got disabled suddenly
clustered index got disabled suddenly
You have to rebuild it to access the base table.
then Data in the table still exists, but will not be accessible for anything other than Drop or REBUILD …
- 62.4k
7
votes
Accepted
Migrate SQL Server from 2012 to 2014 (11 to 12)
I have just installed SQL Server Management studio 2014
SSMS wont install database engine. Its just a GUI to connect to SQL Server. You can check the SQL Server version using below T-SQL :
SELEC …
- 62.4k
2
votes
Accepted
SQL Server Agent maintains thousands of sleeping connections
KB 3034297 - Cumulative Update 6 for SQL Server 2014 describes the issue that you are encountering and is fixed in SQL Server 2014 CU6
When you turn on SQL Server Managed Backup in Microsoft SQL S …
- 62.4k
2
votes
Database Files through Linked Servers
Powershell is the way. And it make it easier, just install dbatools on one of your admin servers and use get-dbadiskspace
Get-DbaDiskSpace -ComputerName server1, server2, server3 -Unit GB
if you …
- 62.4k
2
votes
Accepted
MDF file size and performance
Does a very large MDF file negatively impact latency? If so what is the appropriate size?
Only the size of MDF does not impact IO latency. Latency is related to your disk IO subsystem, its config …
- 62.4k
4
votes
Accepted
What does "Drop Connections" and "Update Statistics" in the "Detach Database" dialog do?
Supplementing to the current answer...
Detach database will leave you without any backup. If for some reason, you cannot attach database, you will end up with a detached copy of mdf and ldf.
A best …
- 62.4k
4
votes
Accepted
Can I limit SQL server one database resources
Since you are using Developer Edition (and is cheap as compared Standard or Enterprise), you are better off installing another instance with 5GB Max Memory. Put the databases that you need less memory …
- 62.4k
1
vote
Database Backup Drive Occupancy
You have options
Move away the backup files to a network share or a central backup server. Based on your company's retention policy, the backup can be archived to tape or just deleted (Caution !). …
- 62.4k
3
votes
Accepted
Why does a Columnstore index build often wait on SLEEP_TASK?
To help the global dictionary be a better reflection of the data in the entire table, the column store index build process has been changed in SQL Server 2014.
It now first kicks off on a single thr …
- 62.4k
16
votes
Is a weekly rebuild of indexes a good idea?
Dont just blindly go for rebuilding all the indexes. There is a much intelligent way of doing it. (hint: SQL Server Index and Statistics Maintenance by Ola hallengren)
This is an official guideline fr …
- 62.4k