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
Search options not deleted
user 93455
All versions of Microsoft SQL Server (not MySQL). Please also add a version-specific tag, like sql-server-2016, since it is often relevant to the question.
3
votes
How to Denormalize data efficently
To answer your second question, you can try to rewrite the select query like this:
SELECT
j.[JobID]
, j.[Active]
, jf.[JobFieldTypeId]
, jf.[ValueString]
, jf.[ValueInt]
, jf. …
- 887
0
votes
How to drop a table that was replicated in the past?
You can run the following script to cleanup any orphan replication objects:
USE [<YourDatabaseName>]
GO
exec sp_cleanupdbreplication
GO
exec sp_removedbreplication
GO
- 887
1
vote
3
answers
93
views
Enforce uniqueness on combination of columns + aggregate function
I have a SQL Server database with the following tables:
CREATE TABLE [dbo].[Rule]
(
[RuleId] [int] IDENTITY(1,1) NOT NULL,
[Value1] [int] NOT NULL,
[Value2] [int] NOT …
- 887
16
votes
Accepted
Length of LOB data (2135980) to be replicated exceeds configured maximum 65536
This configuration can be changed using Management Studio by right-clicking the server -> Properties -> Advanced tab -> Miscellaneous -> Max Text Replication Size.
Or you may want to try :
EXEC sys. …
- 887
7
votes
Issue with Table Naming Conventions and Policy Management in SQL Server 2016
Tested the scripts on a SQL Server 2016 SP1 CU2 instance and the policy works if the Evaluation mode is set to "On Change : Prevent". (there is a bug that doesn't let you evaluate policies that use sp …
- 887
0
votes
How automate backup and restore in Azure SQL Managed Instance?
You can use an SQL Agent Job to backup and restore a database from a storage account, you just need to create a credential in advance:
SELECT * FROM sys.credentials;
CREATE CREDENTIAL [https://Storag …
- 887