SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• T-SQL to run if in Active Directory Group

  So we have a block of code that I only want system account to run.. but if a user is db_owner.. the…

  dwilliscp

  2 replies

  1 year, 4 months ago

  By: Dennis Jensen

• Developing Extensions for SSMS 2016

  I recently released my extension and wanted to share what I have learned so that others can start c…

  DarkNexusNR

  7 replies

  1 year, 4 months ago

  By: Daniel Brink

• SSMS 2016 extension object explorer context menu

  Im trying to rewrite our addin to an extension for SSMS 2016. I cant seem to find a way to add a me…

  skully2000

  1 replies

  1 year, 4 months ago

  By: Daniel Brink

• Query performance comparison

  All, I'm trying to compare two queries in terms of actual CPU and IO usage. In terms of IO the near…

  as_1234

  5 replies

  1 year, 4 months ago

  By: as_1234

• UNION statement is inconsistent

  Hi I have a weird problem that I can't find the cause for. I have the statement below, it consists …

  Anders Hansen

  5 replies

  1 year, 4 months ago

  By: Anders Hansen

• Find the time difference between query output to the data received by the app

  Hi, I am looking for some solution where i can find out how much time did sql take to give full out…

  saum70

  5 replies

  1 year, 4 months ago

  By: Phil Parkin

• SQLCLR functions

  Hi all   We've written some SQLCLR functions in C# to try and get rid of the UDF's we'd writte…

  richardmgreen1

  2 replies

  1 year, 5 months ago

  By: richardmgreen1

• Converting rows into columns

  I have a table that contains three columns with ID, dates and value. I want to convert the contents…

  don075

  5 replies

  1 year, 5 months ago

  By: Jonathan AC Roberts

• INSERT INTO with tally is slower than INSERT INTO within WHILE LOOP

  My colleague wrote a following function to generate a table with 10,000,000 records, which works ab…

  BOR15K

  10 replies

  1 year, 5 months ago

  By: BOR15K

• SQL help with partition

  With the following data, I need to create a column that will display a counter for each VID, Acc wh…

  don075

  19 replies

  1 year, 5 months ago

  By: don075

• NOT LIKE Alternatives in WHERE clause

  Hello, I need help to improve an existing (hence I cannot change table's structure nor the content'…

  BOR15K

  19 replies

  1 year, 5 months ago

  By: Jeff Moden

• Help with a SQL Unpivot

  I am trying to use unpivot to extract some data, however, the results are getting messed up on at l…

  rogue1009

  6 replies

  1 year, 5 months ago

  By: Phil Parkin

• MS SQL Query - JOIN mutiple tables but it duplicates results

  MS SQL Query - JOIN multiple tables but it duplicate results; Good day! it duplicate results when …

  glennyboy

  6 replies

  1 year, 6 months ago

  By: Michael L John

• import from CSV - special chars

  My data csv file sometimes comes in with special characters and French accents too (è ë à ç ) A…

  datsun

  4 replies

  1 year, 6 months ago

  By: frederico_fonseca

• How to replace these special characters?

  Hi everyone, I have a SQL table in which there is a name column. I found these 3 names which contai…

  Jobs90312

  5 replies

  1 year, 6 months ago

  By: Jobs90312