backup to MSSQL 2012 from mssql 2016 - I do not think it's possible, but i could really use it. Best regards Edvard Korsbæk
Making Indexes Invisble to the Optimiser - Good Morning Folks! I am working on an optimisation project that is focusing heavily on indexing within the database. At the...
Nested insert statements problem - Hello all. fairly new to SQL. but not that new. I have 3 stored procedures. The first one has a statement like...
Challenging string handling in T-SQL - Hello Experts, I have a data in a table as shown in the first column (A) and would like to update...
How to only select 11pm to 7am in DateTime (many months of data) DDM&DDL included :) - Looking to run a report for a few years but only between 11pm and 7am. CREATE TABLE mytable( i_ticket_id INTEGER NOT...
Possible to add a Total for Amount at the end of each day? - DECLARE @Yesterday DATETIME = DATEADD(DAY,-1,CAST(GETDATE() AS DATE)); DECLARE @PeriodStart DATETIME = DATEADD(DAY,-6,@Yesterday), @PeriodEnd DATETIME = CAST(GETDATE() AS DATE), @MonthStart DATETIME =DATEADD(MONTH,DATEDIFF(MONTH,0,GETDATE()),0); SET NOCOUNT ON; SELECT ...
Set up job to convert word document to pdf - I'm working on a SQL job to transfer some data along with some word documents. After copying the word documents...
Trying to speed up this 'GetWorkingDays' function. - I'm trying to redesign one of our working days functions. The idea is to calculate weekends (easy enough) but holidays...
Database design to handle Millions of records - Dear Techies, Please suggest how should design database to handle millions of records. And also let me know strong points to...
parallel installation of SQl Server, - We have a 2012 windows server with SQL 2012 installed. . Can we install SQL 2016 on the same server in a separate partition?
Importing data reports data truncation in both EM and SSIS from multiple data sources - First, I'm retired so have time to play with my own data. I have two data sources, an extensive collection...
SSIS : "The value could not be converted because of a potential loss of data.". - Dear all, I have a data conversion task and I am getting the following error message: while converting column "VALUE_IN_FUND_CURR" (488) to...
Find tables - I have to design a script to find all tables in a database with below criteria. 1. Identify all tables should...
Identify wrong links inside a hierarchical tree-structure - Hello, I'm working on an electrical network, edge are link between nodes, insert lines with 'end' are all clients. The first line...
Open .PRC with connection - Using V17.3 and 2008R2 When I double-click on an .sql file, SSMS v17 launches with a new connection window. When I...
Resource Governor Classifier Function Question - How to restrict resources usage based on individual Databases in resource governor? We have many databases in one instance; I would...
Session Scope with Temporary Tables and Dynamic SQL - I came across something interesting while troubleshooting a developer's code recently. We use temporary tables which are populated by executing...
Managing Assemblies - Dear Community, An application that validates user accounts, using assemblies, IIS, etc. works fine. Lately, some problems has originated that validation get...
Measures showing up Blank in Power BI - When I attempt to connect POwer BI Desktop to my tabular model, The measures all show up blank. I am able...
Restore Database Failed: 'Exclusive access could not be obtained because the database is in use.' - Hi, While trying to restore a database (with replace option), I am getting the below error - Exclusive access could not be...
