sqlserver Image

sqlserver

question
Jeff Moden avatar image
Jeff Moden answered Default

ID is primary key value increasing by +15 or +random number every time I add a row

table sqlserver tables primary-key

0 Likes

1Answer

0 Comments

question
Jeff Moden avatar image
Jeff Moden answered Default

How good is resource governor?

sqlserver

0 Likes

2Answers

0 Comments

question
E.Thompson avatar image
E.Thompson commented Default

Find records where JSON contains value

sqlserver json

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
Jeff Moden avatar image
Jeff Moden answered Default

Move all DB indexes with page_count of 10000 or less to new filegroup

sqlserver filegroup nonclustered-index move

0 Likes

1Answer

0 Comments

question
Jeff Moden avatar image
Jeff Moden answered Default

How to replace below cursor code to any other method

tsql sqlserver

0 Likes

1Answer

1 Comment

question
DaveC avatar image
DaveC edited Default

How to combine multiple rows into 1 row

sqlserver

0 Likes

0Answers

0 Comments

question
UNKNOWN avatar image
UNKNOWN published Default

Input part of a pilot's name and produce the schedule for the pilot.

sqlserver sqlcmd #sqljob

0 Likes

0Answers

0 Comments

question
UNKNOWN avatar image
UNKNOWN asked Default

SQL: Produce an aggregated report of the number of flights done by:

sqlserver

0 Likes

0Answers

0 Comments

question
UNKNOWN avatar image
UNKNOWN asked Default

sql: Find all pilots whose total flight hours (total_hours) is greater than the average.

sqlserver sqlcmd #sqljob

0 Likes

0Answers

0 Comments

question
Nasrudin avatar image
Nasrudin asked Default

Update column with condition

sql query sqlserver

0 Likes

0Answers

0 Comments

question
thotels avatar image
thotels published Default

SQL Select, join

select joins sqlserver

0 Likes

0Answers

0 Comments

question
ujjwa_jain avatar image
ujjwa_jain commented Default

Data Access option getting false for subscriber Linked server when calling "sp_addsubscription " from publisher end in SQL server 2019

replication sqlserver transactional-replication sqlbrowser transactional replication

1 Like

0Answers

2 Comments

question
tsdinesh1003 avatar image
tsdinesh1003 asked Default

log backup job getting failed for particular DBs in secondary replica always on SQL

sqlserver always-on

0 Likes

0Answers

0 Comments

question
artisltover avatar image
artisltover asked Default

I need to use infile in a stored procedure. How do i add username and password to the procedure?

sqlserver

0 Likes

0Answers

0 Comments

question
kevinj avatar image
kevinj published Default

Help; Create function T-SQL

t-sql sqlserver

0 Likes

0Answers

0 Comments

134 Posts
111 Users
0 Followers

Topic Experts

SQLArnold avatar image
SQLArnold
0 Points