Here's a few of the new posts today on the forums. To see more, visit the forums.
|
| SQL Server 2017 - Administration |
| Connecting to SQL 2017 with SQL Server Driver from Windows 2012R2 - Hi we have a legacy application that connects from the application servers (Windows 2012 R2) to the SQL servers using the SQL Server driver. This work fine against an old version of SQL, but we're upgrading to SQL 2017, and it no longer connects. You can connect from Windows 10 using the SQL server driver. […] |
| Most accessed tables/indexes - This is a generic question to know more about SQL server performance.Nobody has complained of any performace issues on our servers, but there is an agenda to know the existing performance and how that can be improved upon. What are the metrics that need to be captured to identify a baseline for a sql server […] |
| Data type for large text. - Hi, I have a table I am importing from excel where are few of the cells have a length of 450. What data type should I use when I create the table? Varchar(MAX) or should I use something else. Using sql server 2017. Thanks |
| SQL Server 2017 - Development |
| GROUP BY with SELECT SUM - Why is this not working? Field 'EmpNo' not contained in either an aggregate function or the GroupBy clause SELECT EmpNo, SUM(Time1) AS TotalTime, Dept, Job, Description, Rework FROM TimeData2 GROUP BY EmpNo |
| Errors using XML value method - I'm having issues using the xml value method to convert an XML COlumn to values and the answers I've tried have not worked. My XML Column appears as follows 42702e49b4 f3db96464e I've tried Select transit.value('/Transit/docid)[1]','varchar(50)') as docid from Client and […] |
| SQL Server 2016 - Administration |
| Licence SQL server Edition developper sous une machine EC2 - Good morning all Can I take advantage of the fact that the SQL develop license is free to install it on EC2 AWS machine?Is the use of SQL developing ON EC2 AWS free thank you for your clarification |
| Logon Trigger security context - I recently had to create a logon trigger to track what appeared to be unused accounts, putting the logon, IP and time into a table in my Management database. The aim being to see if the accounts are still being used, when and from where. The code was pretty simple: create table DBAManager.dbm.tbl_LogonTrack ( LogonTrackID […] |
| Administration - SQL Server 2014 |
| Shutdown order for nodes in AG and quorum disk - When shutting down the whole farm environment with two nodes in Failover Cluster/AG, my thinking is to shutdown secondary first and then primary. When bringing up, start with primary and then the secondary. What I noted was when the secondary was brought up first and then the primary, the databases synced and AG dashboard showed […] |
| Excessive Blocking despite Read Committed Snapshot Isolation - I've got a DynamicsAX database that's seeing a significant amount of blocking despite having RCSI set and the connections using Read Committed. This Microsoft article ( https://docs.microsoft.com/en-us/sql/t-sql/statements/set-transaction-isolation-level-transact-sql?view=sql-server-ver15&viewFallbackFrom=sql-server-ver12 ) confirms that there should be far less blocking, under the READ COMMITTED section it says: If READ_COMMITTED_SNAPSHOT is set to ON (the default on Azure SQL Database), the […] |
| Development - SQL Server 2014 |
| Sql query - Projected Monthly Revenue - Hi, I've been sitting with a projected revenue query for sometime , trying to figure out the best way to do this. Basically, I'm trying to get a monthly revenue number based on daily shipment totals. eg: Total Rev MTD $88,720 / 9 days = $9,857 * 23 shipping days = $226,731 as Monthly Project […] |
| Clone a table from a script - I have a table schema in an exported .sql file (text). Is there any way to use that to create an identical table (with the name changed of course)? The file was created using script table as -> create to -> file. TIA |
| Stored Proc. Date parameter loop - Morning, I have a SP that I created that does select query, using a date parameter. Because of a few joins the query takes a little long to run. and present in an app. What I thought of doing is changing the SP to a Insert select, and pre-fill a table with results needed, and […] |
| SQL Server 2012 - T-SQL |
| Help filtering my WHERE clause - Hi, I work in a hospital and look after a db containing the surgical procedures performed on our patients. I am trying to write a query that will count the number of specific combinations of procedures performed by our two surgeons but I'm struggling to extract just the right patient records. I have attached a […] |
| SQL Server 2019 - Administration |
| Encrypt/Decrypt issue - Version :Microsoft SQL Server 2019 (RTM-GDR) Followed these links as underneath: https://www.mssqltips.com/sqlservertip/2431/sql-server-column-level-encryption-example-using-symmetric-keys/ https://www.surekhatech.com/blog/column-level-encryption-and-decryption-in-mssql I created 2 tables. For the first table I inserted individual rows (with encryption as in the links) and when I did a decrypted select.The result came out perfectly.No issues.The result showed the original password column,encrypted password column and then the decrypted […] |
| Integration Services |
| Execute PowerShell script, via Execute Process Task, results into a Table... - I'd like to Execute PowerShell script, via Execute Process Task and store the results into a SQL Table. Can this be done? If yes, could you point me to an example? Thank you |
