Skip to content
#

sql-server

Here are 1,414 public repositories matching this topic...

server
erikdarlingdata
erikdarlingdata commented Nov 5, 2019

Is your feature request related to a problem? Please describe.
SQL Server 2019 introduced a new DMV, called dm_db_missing_index_group_stats_query that includes some interesting columns. It's not documented so far, but it provides some information that can be used to tie missing index requests to queries.

![image](https://user-images.githubusercontent.com/2136037/68211846-5a879600-ffa6-11

aroncal
aroncal commented Apr 2, 2020

When executing a query, the result object has the rowsAffected property. According to the documentation, it gives that information for INSERT/UPDATE/DELETE queries; but I can see that it also gives the number of rows returned by a SELECT query.

Can we be confident it will be that way always? If so, shouldn't the README be updated to reflect this behavior?

Thanks.

joshcobalt
joshcobalt commented Mar 17, 2019

The documentation is lacking any usage of .Dispose() (or wrapping with a using() block) on the instantiated sql connections.
e.g. https://sqlkata.com/docs/execution/setup

Is this being called somewhere in the code for you that I'm not seeing?

Otherwise, the documentation/code should be updated to suggest a better way of managing the life-cycle of the connection object. Many people will jus

dbatools
wsmelton
wsmelton commented Jan 24, 2020

We have a switch as [switch]$Enable that should enable the login but it is not actually coded to do anything.

All that is needed would be logic around whether the parameter was passed in, within the process block would be sufficient: Test-Bound Enable will return true if the parameter was properly passed into the function call.

If passed in then the login object has a Enable() method t

betelgeuse
betelgeuse commented Nov 11, 2019

Under the header "FreeTDS Compatibility & Configuration" README says: "We are currently having issues with passing down a TDS version with the login bit. Till we get that fixed, if you are not using a freetds.conf or a TDSVER environment variable, then make sure to use 7.1."

Later under "TinyTds::Client Usage" it says: ":tds_version - TDS version. Defaults to "7.3"."

Based on blame history b

thosomers
thosomers commented Aug 30, 2019

Description

executeDeleteQueryAsync in SqlRuntime.Linq.fs doesn't return deleted row count.

Repro steps

Seq.delete all items from single table always returns 0.

Expected behavior

Seq.delete all items from single table should return the number of rows deleted.

Known workarounds

Use cmd.ExecuteNonQueryAsync instead of cmd.ExecuteScalarAsync

Yannick86
Yannick86 commented Mar 20, 2019

Would it be possible to add links to files that are located on a network drive?

I'm planning to use RoadKill as a Wiki on our intranet to document our customers their systems.
We have some customer documentation in files on our network that will be managed outside the wiki. For example; powerpoint presentations, Excel listings, ..

Instead of having to upload them all, can we just add a ref

isaacabraham
isaacabraham commented Sep 8, 2018

Hi. Just having a look at this repo, it looks interesting and potentially something we would use. However I can't find much in the way of docs, particularly how to get up and running with the proper SQL version (although I managed to muddle my way through the in-memory version without too much difficulty). Anywhere I've missed?

bartelink
bartelink commented Mar 25, 2020

As a follow-up to #209, which fixes this bug for SqlStreamStore (the presence of the bug has its roots in #175)

There's a lack of coverage of the writing an event with a null content for the Data field

I believe Equinox.Cosmos has coverage, but the SqlStreamStore + EventStore integration tests do not cover it.

Fix is to include a test scenario that generates an Event union with no bod

IainESGlass
IainESGlass commented Feb 13, 2020

Latest Project Nami Windows Server 2016 7.3 php SQL Server 2016 Standard
Tried multiple clean installs with no other plugins
issues with assigning categories to items
you can only add one product to shopping cart
you cannot update nor delete the product in the cart
will checkout etc
Woocommerce status blows up with fatal error:

Fatal error: Uncaught Error: Call to undefined function my

Improve this page

Add a description, image, and links to the sql-server topic page so that developers can more easily learn about it.

Curate this topic

Add this topic to your repo

To associate your repository with the sql-server topic, visit your repo's landing page and select "manage topics."

Learn more

You can’t perform that action at this time.