Instant File Initialization - (IFI) sub-section, please add the "SQL Server Launchpad" service to the list of services filtered out
Nobody has claimed this yet.
Assessment
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Newbie friendliness
- 45/100
Research direction
Start by locating the "Instant File Initialization" (IFI) sub-section and its current SQL query. Review how the query filters SQL Server services, then update it so the SQL Server Launchpad service is excluded as requested. Confirm the revised query selects the intended SQL Server service without including SQL Server Agent or Launchpad.
Written by the indexing model from the issue text.
Description
Within the "Instant File Initialization" (IFI) sub-section, please filter out the "SQL Server Launchpad" service.
Current
SET @sqlcmd = N'SELECT @IFIStatusOUT = instant_file_initialization_enabled FROM sys.dm_server_services WHERE servicename LIKE ''SQL Server%'' AND servicename NOT LIKE ''SQL Server Agent%''';
Revised
SET @sqlcmd = N'SELECT @IFIStatusOUT = instant_file_initialization_enabled '
+ ' FROM sys.dm_server_services '
+ ' WHERE servicename = ''SQL Server'
+ ' ('
+ cast(@@SERVICENAME as sysname)
+ ')'
+ ''' '
Here is a screen shot
- Dominant language
- Jupyter Notebook
- Stars
- 1.6k
- Forks
- 749
- PR merge metrics
- No merged PRs in 30d
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from microsoft/tigertoolbox
-
Difficulty 2/5 1-3 hours Newbie friendliness 74/100
microsoft/tigertoolbox#320 ·
-
Difficulty 1/5 Under an hour Newbie friendliness 72/100
microsoft/tigertoolbox#199 ·
-
Difficulty 3/5 1-2 days Newbie friendliness 48/100
microsoft/tigertoolbox#319 ·
-
Difficulty 3/5 1-2 days Newbie friendliness 35/100
microsoft/tigertoolbox#312 ·
-
Difficulty 4/5 3-5 days Newbie friendliness 35/100
microsoft/tigertoolbox#311 ·
All issues in microsoft/tigertoolbox
Similar issues
-
bug: AI Gateway client filter lists "Unknown" twice when NULL and literal Unknown clients coexist Openbug
Difficulty 2/5 1-3 hours Newbie friendliness 90/100
-
[BUG] A column whose default is the empty string is drawn in the ER diagram as having no default Openbug database-provider good first issue hacktoberfest
Difficulty 2/5 1-3 hours Newbie friendliness 90/100
libredb/libredb-studio#1030 · 6 comments ·
-
comp-datalake
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
ClickHouse/ClickHouse#121222 ·
-
bug
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
-
bug redshift
Difficulty 2/5 1-3 hours Newbie friendliness 88/100