Question My organization had a security audit and was told that we need to DISABLE the "allow remote connection to this server" option for all of our SQL Servers. What impact would this have on connection to the SQL Server via Management Studio (SSMS) from … [Read More]
Question When saving a number with leading zeros into a string variable or column, leading zeros are truncated. When I run this query: The result I get is 11. Is there any way to get 011? asked 2021-05-17 by sandhun p.s Answer In your code … [Read More]
Question I have 2 tables(source and destination) which are respectively NOR_LABOR and ALL_LABOR_DETAILS. In the source table(NOR_LABOR) there is a column feet_produced with the data type nchar(10). In the destination table(ALL_LABOR_DETAILS) there’s a column labor_feet_produced with the data type decimal(18,4). I want to convert the … [Read More]
Question Is there a way to view and copy the code that the "Import Flat File to SQL" Wizard ultimately uses, after I have gone through all the steps (chosen file, set up data types for my columns, etc.)? While using the Import Flat File … [Read More]
Question we use the SqlTransaction-class in the backend to access data stored in the MS-SQLServer. In some cases we definitely know that no data were changed by this transaction (and no errors occurred). So the question is: How to close transactions in these cases? Shall … [Read More]
Question I have a stored procedure that begins by declaring a few variables then contains begin tran; After this it performs some validations on the supplied arguments (and increments an error count each time a supplied argument fails validation). If there is no error count … [Read More]
Question This is the oracle query that I have, I want to create similar query for my MS SQL DB, Any help please asked 2021-03-31 by Luv Gupta Answer Just remove the hint for SQL Server. The cardinality and parallel hints are designed to help … [Read More]
In my prior post, I talked about how all signs pointed to it being Closing Time for PASS. Since then, PASS has announced the organization will “cease its operations and pursue dissolution.” TL;DR; The short version is that on 15 January, 2021, PASS will shut … [Read More]
This year, I’ve written a couple of critical posts targeted at PASS. If you follow me on Twitter, you know I’ve been critical there, too. Last week, the PASS Board of Directors had their December meeting. Coming out of that meeting, Mindy Curnutt (blog|twitter) resigned … [Read More]
Question Table sysjobschedules contains 2 columns next_run_date and next_run_time. With the help of sysschedules and column enable it should be easy to determine the next running date/time of a specific job. However, when you change a schedule, sysjobschedules is only refreshed 20 minutes after alteration … [Read More]
Copyright © 2025 | Andy Mallon | am2.co