Skip to content
#

sql-server

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

server
eloekset
eloekset commented Feb 22, 2020

Ref #1101 we've concluded to remove the MyGet feed, which has been used for pre-releases up until now. That involves several tasks. From the top of my head:

  • Move all NuGet packages currently on the MyGet feed over to the Azure Artifacts feed
  • Update readme.md to show a badge for the latest release on the new feed and remove MyGet
  • Delete the Travis build script all together, or
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

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?

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

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.