|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
The OPENJSON return schema | |
What items do I need to include in the WITH clause of OPENJSON() to define a schema? | |
Think you know the answer? Click here, and find out if you are right. |
Yesterday's Question of the Day (by Steve Jones - SSC Editor) |
Unloading an Extended Stored Procedure Normally an extended stored procedure is not unloaded from memory until SQL Server is shutdown. How can I unload an XP without stopping SQL Server? Answer: Use DBCC FREE Explanation: You can use DBCC with the name of the DDL and then the FREE command. Ref: DBCC (dll name) FREE - https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-dllname-free-transact-sql?view=sql-server-ver15 |
Database Pros Who Need Your Help |
Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2017 - Administration |
SSRS 2017 How to check which SSL cert is bound - Hello experts, I need to update the SSL certificate on our SSRS 2017 instance. However, in the Report Services Configuration Manager it lists the 2 certs without any room to expand the name or check the properties. So happens both the old and new SSL cert that our systems team assigned start the same way, […] |
SQL Server 2016 - Administration |
SQL Agent job - Can I run extended event session against 1 SQL agent job? I have a job which runs at 7 every day, takes about 10, 12, 14 hours to run. It inserts 2.5 million records into a table thru a bat file. To me, it should run fast but I am just trying to educate myself […] |
Rebuild index - I have a table which is partitioned (Total 10). The table is 1.6 TB in size. Rebuild index on that is quite challenging, especially we have some resource constraints. I am wondering if there is a way to rebuild index, just for 1 partition. Just trying to educate myself. |
SQL 2012 - General |
There is insufficient sys memory in resource pool 'internal' to run this query - Hi All, I have an issue with production server , from SQL error log I can see "There is insufficient system memory in resource pool 'internal' to run this query. when i check the memory usage for 1 month , it is like around 35% everyday and also min memory is 1 GB and max […] |
SQL Server 2019 - Administration |
Multiple instance on SQL server 2017 with VS 2019.... ERROR 26 on Visual Studio - I have a system with multiple clients and each one in different virtual machines, I have proposed the task of joining all the clients in the same virtual, of course taking into account that they are all in the same version of sql server. my first tests failed as i installed each of the instances […] |
SQL Server 2019 - Development |
Need some help with tsql code - I have 4 tables (DevDB, TestDB, StageDB, ProdDB). All those tables have 2 columns (DatabaseName, Environment). There are tons of DBs which exist on Prod but don't exist in lower environment. I need help with writing a query which pulls data so I can see that let's say 1 specific database exists in stage but […] |
Capture login information - I want to Capture Login information in table or view. who connected to database and when they connected. looking for script |
How to grant Exec ON multiple Stored Procedures - Hi, I have multiple Stored Procedures that are named like _Test_01, _Test_02 _Test_03 I would like to grant EXEC rights to multiple Stored Procedures at once. Something like: GRANT EXEC ON [dbo].[_Test*.*] TO [udr_db_FocusOneUserRole] How can I Grant these in one line? |
XML data extract - Hi I've been tasked with extracting information for a report where the field type is XML. THe SQL table contains 2 fields Personcode and XMLBody THe XMLBody Field contains information like the below example; Extarct the data string located here. |
Issue with the SUM function - Hello friends, I have one question. It may be a little bit hard to explain but I will try my best. Let me know if my explanation is confusing. Right now I have a query that has a chain name and lots of repetitions of the same information. I am 99,9% sure that the reason […] |
Formatting issue with percent - I have an issue that may be an easy fix for someone, but is not for me. I need to calculate Instock%. For this I need to take p.QTY (Forecast Demand) / s.OH (What is on hand) and get a percentage. For example p.QTY (Forecast) was 2 and Inventory On Hand is 100 now so […] |
SQL StoredProcedure for data validation using REGEX in SSIS - hi, I have a requirement where we get data from Oracle source and destination is also Oracle db. Only validation is done in SSIS. So, i have to validate the data using regular expression in SQL Storedprocedure (in ssis) and send bad data to a error log table with logging the record ( with table […] |
Reporting Services |
Hex-tile map (e.g. United States) in SSRS? - I've created them in Tableau and PowerBI but would like to do this in SSRS: |
Powershell |
SQL Server connection using Get-StoredCredential - Hi, I am currently able to log in using a trusted connection. I stored credentials for an SQL login in the Windows Credential Manager, but I'm not sure how I can use this for authenticating from a PowerShell script. Currently, I'm connecting: $con = New-Object System.Data.SqlClient.SqlConnection; $con.ConnectionString = "Data Source=my-apps-server;Initial Catalog=myDatabase;Integrated Security=true"; $con.Open(); # execute […] |
Integration Services |
Save Blob Storage Key in Package - Hi Guys, Is there a way to save the Blob Storage Key into a package/project so that it doesn't need to be modifed after deployment each time? cheers Alex |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |