|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Logging Event Permissions | |
I want to allow a user to use the xp_logevent procedure to log messages in the log for various events from an application. What rights do I need to give this user to do this? | |
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) |
Do I need a restart? I have been using sp_configure to change some settings for my instance. I know I need to run RECONFIGURE to change the option, but how can I tell if I need a restart? Answer: You can query sys.configurations and the is_dynamic column Explanation: There is an is_dynamic column in sys.configurations that lets you know if this option can be dynamically changed. Ref: sys.configurations - https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-configurations-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 |
What do you like for third party database backup/restore for SQL server & Azure - Hi all, my company currently uses SQL server native tools to perform nightly backups. We are a small company and unfortunately do not have an actual DBA - our network admin and group of developers are working together on the backups. But we are looking into other vendors, such as RedGate's SQLBackupPro, Idera's SQL […] |
Disk space - I noticed the system volume information is consuming the disk space on database server log drive. Also found that shadow copy is disabled but maximum size is not configured to use limit. My understanding is that during the setup of server someone would have not configured properly to use limit. Do you agree with me? […] |
SQL Server 2017 - Development |
Find the last occurrence of \ character and get the left of string. - How to find the last occurrence of '\' in the following string and get left part of it? DECLARE @V VARCHAR(max)='O:\Z\P_Metrics\Inbox\07-13-20200702_abc_enroll.csv' DECLARE @V1 VARCHAR(max)='O:\Z\P_Metrics\Inbox\07-14-20200702_abc_complete_enroll.csv' The Final output I need is O:\Z\P_Metrics\Inbox. Thanks in advance. |
Creating a Dimension with no Primary Key - Hi all, I'm rebuilding some cubes in SQL Server 2017 using Visual Studio and SSAS. The cubes were originally constructed in SQL 2000. It's been going well so far until I try to recreate a "Calculated Time" dimension that worked so well in the old build. The dimension table was linked to the fact table […] |
SQL Server 2016 - Administration |
Migrate database with encrypted columns to SQL 2016 - Hi all, I need to migrate a SQL 2012 database that has a few tables with encrypted columns, to a SQL 2016 instance. I have done this same process between two 2012 instances, and it always worked, but I am unable to do so with 2016. Below is the code I run after I restore […] |
SQL Server 2016 - Development and T-SQL |
Code signing a dll with certificate for use in SQL Server 2016 - I have a dll that will perform some webservice calls function. in order to use in SQLServer 2016 i would like to create a user called sqlex from a certificate. When I try to do this I get the below error: USE [master] GO /****** Object: Login [sqlRext] Script Date: 10/07/2020 12:06:30 ******/ CREATE LOGIN […] |
Find whether a clustered index is actually unique - Hi I have a table that has a clustered index on it The table does not have a primary key and the clustered index has not been defined as unique There are approximately 3B rows in the table It's been around for years and I'm wondering why neither a PK or a unique clustered […] |
temp table performance in sql 2016 - HI everyone, I just restored a DB on sql2016 from sql2012. One of my sql queries that heavily uses temp tables is running 3x slowin sql 2016 . I am still baffled with this performance degradation. I read some articles on google to set Compatibility level to 2012 (110) and Legacy Cardinality Estimation to TRUE […] |
Isnull in a Where Clause - Dear friends, We used Stored Procedure on our Queries for us to get valuee we Put the conversion of ISNULL inside the WHERE condition but per checking it affects the Process of our strodproc, it is not using indexes, never index seek always table scan. For example, SELECT * FROM tblInfo WHERE fldinfo=ISNULL(@parameter,fldinfo) What's your […] |
Administration - SQL Server 2014 |
Create SQL Login to View only one database on server - Hi All, I have one task to create a login, and user need to view only One Database, there are 20 other databases but requirement is for the user to view only one database and only 5 tables from 1000 tables. I tried to create a login and give Server Role Public and Database role […] |
Development - SQL Server 2014 |
To use the same function to pass table name as a parameter - I have this function, but I wanted to pass a table so as to use the same function to get the job done for multiple tables. For example, I want this function work for table1, and table2. But it is just for table1 currently. I was trying to use a dynamic sql in vain; it […] |
SQL Server 2012 - T-SQL |
Nearest Proximity For every record - Hello! We have a query we are trying to build with a key component. All of our locations have a lat and long entered as own values in the table. We need to find out the nearest location to EACH building from all the other buildings. Another tricky part is we have to make sure […] |
SQL Server 2019 - Administration |
SSRS - Certificate - Hi Team, When I am trying to configure web service URL, using HTTPS certificate I am getting an error as " Create Certificate binding error" I have installed SQL Server 2019 along with SQL Server 2019 reporting service from the link : https://www.microsoft.com/en-us/download/details.aspx?id=100122 Is this error related to any version issue? My SSRS product version […] |
SQL Server 2019 - Development |
T-SQL decoder ring for Google BigQuery? - Sorry if this is in the wrong forum... feel free to move it. I'm okay with T-SQL, but BigQuery boggles my mind. Is there a good reference comparing the two somewhere? I was looking for a little bit of something sort of like an intro and recipes for converting between the two. thanks! |
SQL Server 2008 - General |
Join is faster? - I am using SQL server 2008. Is JOIN always faster than sub query ? |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |