Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    Samuel Harrold
    @stharrold
    Issue submitted: Microsoft/vscode-mssql#1213
    Elvis Begović
    @elvisbegovic
    Is it normal my sqlserver express (16databases) takes almost 5gb memory ram while nobody is using webapplication
    matrixbot
    @matrixbot

    rudi_bruchez > <@gitter_istiti:matrix.org> Is it normal my sqlserver express (16databases) takes almost 5gb memory ram while nobody is using webapplication

    Yep, SQL Server uses RAM for cache. When it takes it, in does not free it afterwards.

    Elvis Begović
    @elvisbegovic
    What is the max RAM size for cache sql use ? is it 5gb or it can be higher ?
    Elvis Begović
    @elvisbegovic
    @rudi-bruchez
    Elvis Begović
    @elvisbegovic
    Any issue on mssql relating to indexes defragmentation. I defragment dbA it is fast but dbB is slow then i run script to defragment dbB , this time dbB is fast but dbA is slow
    cardonacoder
    @cardonacoder
    Hello, someone would like to help me? I'm having trouble trying to connect to my local mysql server. user: root with no password.
    image.png
    cardonacoder
    @cardonacoder
    :(
    Julian Hüpppauff
    @jhueppauff
    As far I know you can’t connect to a MySQL using the MSSQL add-in.
    matrixbot
    @matrixbot

    heleh > <@gitter_jhueppauff:matrix.org> As far I know you can’t connect to a MySQL using the MSSQL add-in.

    cardonacoder (Gitter): I Am not sure, but i don't belive that the mssql extention is working with MySQL server

    elendrum
    @elendrum
    Does Anyone know what it takes to make the mssql extension authenticate with Azure AAD Azure active directory, I can get the SQL Server user accounts to work fine.
    ABDUL-QAHHAR OLAKUNLE ABUBAKRE
    @abdulqahhar2000_gitlab
    Hello please am new to SQL
    where should I start from? please
    karanam-narendra
    @karanam-narendra
    You can search kudvenkat in YouTube
    SykesAllenC
    @SykesAllenC
    still getting command 'extension.connect' not found error
    tried uninstalling and installing
    Krushna Kadam
    @stronguserkk_twitter
    How can I install extension for SQL server under Visual Studio code.
    Andrew Hill
    @AartBluestoke
    <slightly off topic coment removed> -- this isn't about the vs code extension, it was about sql server itself ...
    Mike Mahon
    @jetstreamin
    I may get laughed out of here but is there away in SSMS to run a query across multiple servers?
    I have servers registered and I am tired of flipping one to the next
    would rather union the results and run it once
    Karl Burtram
    @kburtram
    image.png
    @jetstreamin if you have the servers registered in a Registered Servers group you should be able to execute a query across the group to accomplish a federated query.
    Mike Mahon
    @jetstreamin
    yeah, I got it figured out... I had jack with network settings, my client decided to use non-standard ports on internal development servers so ...
    Hédel Nuñez Bolívar
    @hedelnb_twitter
    Ghost
    @ghost~5d8c5a1bd73408ce4fcc1484
    Hi, sorry to bother all you experts with such a simple problem but my knowledge of sequel is VERY limited. The problem I'm having is I have an excel sheet that I'm supposed to take data from and put it into the SQL DataBase. It's a local DataBase so if I do screw up then it won't affect the company and I can use it to just instead learn but I've been fighting with this problem since yesterday and I'm tired of it now. The guy I got this task from, sino, wants the code in the excel sheet so I can give him the file and he can manage the live DataBase so this is what I've written so far and changed a hundred times by now hahaha. ="INSERT INTO [dbo].[Audit] ([Submission_date], [Audit_date], [BuildingID] ,[Building],[Room_barcode],[Room_number],[AssetUserID],[Responsible_person],[Asset_barcode],[AssetDescription],[Condition]) VALUES ('"&TEXT(B2)&"','"&C2&"', '"&D2&"', '"&E2&"', '"&F2&"', '"&G2&"', '"&I2&"', '"&J2&"', '"&K2&"', '"&R2&"', '"&M2&"')". I keep on getting an error about the conversion from string value into datetime failing for the column Submission_Date but even when it is in datetime format I'm getting the same error. Any ideas? sino wants it in this format somewhat and insists that his =TEXT(B2, "YYYY-MM-DD") is right.
    Ghost
    @ghost~5d8c5a1bd73408ce4fcc1484
    Nevermind, I got it to work.
    Hédel Nuñez Bolívar
    @hedelnb_twitter
    @0ddC0d3 glad to read it :) sorry for be late
    fred
    @fredpoon
    Launching server using command c:\Users\<user>.vscode\extensions\ms-mssql.mssql-1.6.0\sqltoolsservice\1.6.0\Windows\MicrosoftSqlToolsServiceLayer.exe failed.
    anyone run into this?
    Hédel Nuñez Bolívar
    @hedelnb_twitter
    @fredpoon what said event viewer
    Automatic Subscriber
    @autoadsubscrib_twitter
    图片.png
    Hi all
    I updated my VSCode to 1.40.1, but I find the top two icons for exporting are missing
    The missing two are 'save as CSV' and 'save as JSON'
    Automatic Subscriber
    @autoadsubscrib_twitter
    By the way, have the developer group scheduled offering support for exporting DBF ? I guess it would be of great help, since there are few software available offering this function now.
    Oasis
    @oasisfleeting
    I have a scheduled database redesign task coming up next month.. Hoping to split the database up over 4 drives of 500GB a piece and take advantage of some of the IO benefits from asynchronous reads.
    Not sure how virtualization will impact that IO
    Kylee Webb
    @kyleewebb7
    I am not seeing the database icon on the bottom left and therefore cannot open mssql... can anyone help me?
    Kylee Webb
    @kyleewebb7
    Does anyone know what we are supposed to put here?
    Screen Shot 2019-12-11 at 4.14.30 PM.png
    above where it says 'Server name or ADO.NET'?
    Joshua Dapitan
    @joshuadapitan
    the name of your SQL Server instance
    无限风灵
    @WuLex
    (︶︹︺)哼
    use vs
    ste
    step and step
    Tim Bush
    @t_busht_twitter
    Screenshot 2020-01-01 at 10.53.04 PM.png
    Hi all, has anyone successfully got the mssql extension for VS code running on ARM hardware ? I've got this far with headmelted 's build, running as a Linux App in Chrome OS, on an Acer Chromebook Tablet :P
    Tim Bush
    @t_busht_twitter
    Screenshot 2020-01-01 at 11.00.15 PM.png