3 votes
Accepted

ApplicationIntent = ReadOnly and Writes queries

If application that connects to SQL and does both read and write queries using a single connection string that has ApplicationIntent = ReadOnly, does it mean that it will error out if application will ...
David Browne - Microsoft's user avatar
2 votes
Accepted

Extra `CASE WHEN` Removes Text from Dynamically Created String

According to documentation this is antipattern known to return incorrect results: Avoid the following pattern for recursive use of variables and expressions: syntaxsql SELECT @Var = <expression ...
Yano_of_Queenscastle's user avatar
1 vote
Accepted

snapshot to apply just the schema changes - not the data

In the job activity monitor check those who are the snapshot jobs: double click the job and go to the second step - Run Agent add /NoBCPData at the end: -Publisher [myserver] -PublisherDB [PP_Master]...
Marcello Miorelli's user avatar
1 vote
Accepted

Trying to renumber a field in order grouping by another

For an UPDATE query you don't need to rejoin, you can update the derived table directly UPDATE T SET sequence = RowNum FROM ( SELECT T.*, row_number() OVER (PARTITION BY C.co ORDER ...
Charlieface's user avatar
  • 12.9k

Only top scored, non community-wiki answers of a minimum length are eligible