| Here's a few of the new posts today on the forums. To see more, visit the forums. |
| SQL Server 2017 - Administration |
| Database list and the last access date - I've SQL like this, SELECT name as [Database Name], [Last Access Date] =(select MAX(temp.lastaccess) from ( select lastaccess = max(last_user_seek) where max(last_user_seek)is not null union all select lastaccess = max(last_user_scan) where max(last_user_scan)is not null union all select lastaccess = max(last_user_lookup) where max(last_user_lookup) is not null union all select lastaccess =max(last_user_update) where max(last_user_update) is not null) […] |
| cost licence calculated - Good morning all , How is the cost of the SQL CAL license calculated (Per number of Users) this is the SQL 2019 Standard Edition and according to you which is the cheapest CAL or Core license Thank you for your feedback |
| SQL Server 2016 - Administration |
| How to check if a column exists in SQL Server table? - I need to add a specific column if it doesn't exist. I have something like the following, but it always returns false: IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'myTableName' AND COLUMN_NAME = 'myColumnName') How do I check if a column exists in the SQL Server database table? |
| SQL Server 2016 - Development and T-SQL |
| BCP - Export Query to Tab Delimited Text File - Dear Group: I am using SSMS and trying to export a query to a text file using T-SQL (I know there are options in the tool itself to do this, but I need this code for a stored procedure). I found examples but none of them seem to work and each gives a different error […] |
| Does SQL 2016 allow for column encryption? - I have a feeling I've asked this question before, but I can't find my having asked it previously. I'm sorry if I've already asked this question. We have a need to encrypt some data in the columns that they're stored in. However, we've no idea how that is done, both to store the data encrypted […] |
| SQL 2012 - General |
| How to compare development and production server database tables schema - Hello Everyone, We have converted a existing web application application from Asp.net Web forms to Asp.net MVC. The existing web-application hosted in dedicated server and the new one we are moving to Ms Azure cloud. On the development server we have Microsoft SQL Server 2012 - 11.0.2100.60 and in Azure cloud environment we have Microsoft […] |
| SQL Server 2019 - Administration |
| Connection issue from SSRS to SSAS data source - I have a data source defined on our SSRS server and it connects successfully when I am in IE but from Chrome or Edge, it fails. I ran Server Profiler on the SSAS server and see that when I Test Connection with IE, my user account logs in but when I do the same in […] |
| SSMS Encryption - Hello, Please forgive the elementary nature of this post -- I've been tasked with encrypting certain fields in our Azure SQL Server DB -- I have never done this and so far I have done the following: -Right-clicking on the column I want encrypted, and select 'Encrypt Column' -After following the prompts, SSMS created a […] |
| SQL Server 2019 - Development |
| String Manipulation Work? - Hello Geniuses, I have a string manipulation task that I am not sure is even possible... Here is the data CREATE TABLE #TEMP ( Id INT IDENTITY(1,1), Sales Money, StateCode VARCHAR(2) ) INSERT INTO #TEMP (Sales, StateCode) Select '1200', 'MA' UNION ALL Select '200', 'MA' UNION ALL Select '120', 'GA' UNION ALL Select '190', […] |
| tune a table valued function that is using recursive CTE - We have a function that calculates student truancy records by counting their absence in a moving 30 days window. It uses a recursive CTE to count any 30 days passed. Then we use other table to join this table valued function, and it was extremely slow as records increased. I tuned it to select the […] |
| SchemaBinding and Temporal Tables - I have schema bound a view to a temporal (system-versioned) table and receive no errors in doing do. However, I am able to delete/modify columns from the temporal table, without issue. When I do a query against the view, it fails with a binding error. Has anyone else tried this? Should it work? BTW...on the […] |
| T-SQL SubQuery Help Please - Hi, I know this will be rather obvious to many, but I am struggling writing a sub-query at the moment. I am trying to return just the 1 row for each BadgeNo attendee based on the latest date updated joining it with a conf_code in table B. (Illustrative data below) Table A […] |
| SSRS 2012 |
| How to set up a zoom in the browser - Hi all, I have a problem with zoom option in SSRS. I published my report on the SSRS Report Server. After that I open it in GoogleChrome and when I go to the browser setting and change the zoom (for example 100 to 120) - my parameters are shifted. When I zoom in screen and […] |
| SSDT |
| Build SQL Server Data Project on Ubuntu - Hi everyone, we are currently designing CI/CD Pipelines and the build server we have available at the moment is a Ubuntu machine. I investigated a lot and it seems that this combination is just a bad idea and I really need a windows build server. Basically the CI pipeline is just a task to pull […] |
| Hardware |
| Block Size on MSSQL on Linux - Do I need to set my block size of drives on linux at 64k allocation size like I do on windowsOS? |
