Skip to content
#

sql-server

Here are 1,463 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.

ahmad-moussawi
ahmad-moussawi commented Mar 28, 2019
new Query("Users")
.Comment("Fetch invalid users")
.WhereTrue("Invalid");

We can log it using

queryFactory.Logger = (compiled, query) =>
{
    logger.LogInformation("// " + query.GetComment() + "\n" + compiled.ToString() + "\n", compiled.Bindings);
};

Output

// Fetch invalid users
SELECT * FROM [Users] WHERE [Invalid] = 1
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

PaulCharlton
PaulCharlton commented Mar 17, 2020

reconcile config options with TinyTDS and documentation; coerce config values to expected types

extended discussion at: rails-sqlserver/tiny_tds#461
copied here =>


TinyTDS v2.1.2 and current HEAD

Current State:

At the moment, the only "false" values for these configs are "nil" and the boolean value false, whereas all non-nil string values, incl

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

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.