| Here's a few of the new posts today on the forums. To see more, visit the forums. |
| SQL Server 2017 - Development |
| A question about unique keys - I've been away from SQL Server for a number of years. Years ago what I am asking could not be done. I assume that it still can't be done, but rather than make an assumption I thought that I should ask. Below is a completely fictitious example, but it illustrates my question. Supposing that I […] |
| SQL Server 2016 - Administration |
| SPN/KERBEROS issue - Hi everyone. I would like to kerberize SQL connections in the following situation and have not been able to: I have a single server with two SQL instances and only one IP (the server's). I can't configure more IPs due to infrastructure limitation: SERVER1.domain.com --> 10.10.10.1 I start each instance on a different port using […] |
| SQL Server 2016 - Development and T-SQL |
| For Each Loop Query (SSIS) - In above screenshot can anyone tell me how can I enter value of "Files" field as expression? |
| calculate 12 months of data from a given date from a user - I have a query that it seems to be off dont know what wrong but I need to show last 12 months of data based off a user input for a date. my query is this. My results show different in SSRS. /*Declare @Date as Date = '11/1/2022' Declare @prop as int = 8000 --*/SELECT […] |
| calculate 12 months of data from a given date from a user - I have a query that it seems to be off dont know what wrong but I need to show last 12 months of data based off a user input for a date. my query is this. My results show different in SSRS. /*Declare @Date as Date = '11/1/2022' Declare @prop as int = 8000 --*/ […] |
| calculate 12 months of data from a given date from a user - I have a query that it seems to be off dont know what wrong but I need to show last 12 months of data based off a user input for a date. my query is this. My results show different in SSRS. /*Declare @Date as Date = '11/1/2022' Declare @prop as int = 8000 --*/ […] |
| Administration - SQL Server 2014 |
| Error on File - Hi Experts, I have a database with multiple files on multiple drives and one of the drive is restricted to a defined size. Now because the index maintenance job is failing with below error. How can I rectify this without increase the disk space. Could not allocate space for object 'dbo.Table1'.'PK_Table1_ID' in database 'DB1' […] |
| how to check the table is being used(selecting/inserting/updating/deleting/locki - how to check the table is being used(selecting/inserting/updating/deleting/locking) by some sql statement? many thanks! |
| SQL 2012 - General |
| SQL Server 2012 Auditing Question - I am currently trying to set up SQL Server audit specifications, but they are not showing with the following query: select distinct(eventid) from sys.fn_trace_geteventinfo(1) When I run the query it only shows defaults. However prior to installing KB2958429 (SP 2), the audit specifications manually selected showed up with the query. So, I installed KB3045321 (a […] |
| Azure Data Factory |
| Upskill Azure Data Factory knowledge - Hey guys, I'm a DE with of 2 experience and I've been working with Azure Data Factory as the main ETL tool for 6 months now. However, I feel I need to gather more knowledge and assume more responsibilities inside my team but most of the senior professionals don't have much time to teach me. […] |
| SQL Server 2022 - Development |
| Using SQL - Convert column to rows - not a straight forward pivot - Hello All, I have below sample table. Code is also included. create table Trade_test (portfoliocode nvarchar(10), tradedate varchar(10), tradeamount varchar(10) ); insert into Trade_test values('A','01012021','100') insert into Trade_test values('A','01012022','1000') insert into Trade_test values('B','01012018','100') insert into Trade_test values('C','01012019','100') I need to pivot the data to have below output. I have tried few things but not getting […] |
| What's the logic of the NOT IN clause? - I thought I understood the "NOT IN" logic very well until I run into a case where the presence of NULL values affects the result in a way I was not expecting. The setup is super simple: CREATE TABLE A1(ID1 INT); CREATE TABLE A2(ID2 INT); INSERT INTO A1(ID1) VALUES (1), (2), (NULL); INSERT INTO A2(ID2) […] |
| Struggle Bus - Varbinary(max) Performance Suggestions? - I have a very large table I am dealing with that has a varbinary(max) column. I have a Order By that is extremely slow on this field and also I have a Convert as well to a NVARCHAR(MAX) but even without the convert it is slow. How can I somehow increase the performance on this […] |
| I have to do a price increase on our parts. My question is history records. - For each part there must be a history record of price from to price to. Is there a better way to do this than a cursor? Use M2MDATA01 declare @part char(30) declare @rev char(3) Declare @price numeric(15,5) declare @newprice numeric(15,5) Declare @now datetime = current_timestamp declare @new varchar(max) declare @old varchar(max) ALTER TABLE [dbo].[inmastx] Disable […] |
| height_cm -> 167.60 centimeter need to convet height_FT column and Height_IN - height_cm -> 167.60 i have data in sql server column that data i need to insert HeightFT column feet and remain Inches should go into Height_In column. |
