DBA Stack Exchange

Question Is there a way in SQL Server 2012 to get what the server time zone would be on a particular date/time? In SQL Server 2016, you have AT TIME ZONE, but that’s not available in 2012. I have a datetimeoffset and I need to … [Read More]

Question I came across some weird behavior: While passing a float value into a varchar column, the values are getting converted from integers into scientific notation, and it’s that scientific notation that gets stored as a string. results look like this: 1.49559e+006 Scientific notation stored … [Read More]

Question I have been using linked server with the old provider (SQLNCLI) without any issue, as recommended by Microsoft, I’m planning to switch to new provider (MSOLEDBSQL). I’m able to add linked server using following T-SQL after installing the drivers Unfortunately, getting following error when … [Read More]

Question I understand that table partitioning is mostly done for data management. I understand that table maintenance becomes more difficult for large tables, since e.g. an index rebuild cannot fit in memory or because e.g. sorts scale with O(n*log(n)) and this causes extra problems with … [Read More]

Question Error message: Msg 4145, Level 15, State 1, Procedure usp_BaseScan_CycleCount_Report, Line 16 An expression of non-boolean type specified in a context where a condition is expected, near ‘AND’. Msg 156, Level 15, State 1, Procedure usp_BaseScan_CycleCount_Report, Line 21 Incorrect syntax near the keyword ‘ELSE’. … [Read More]

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 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]