|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Getting the default Datefirst | |
Where can I find the default DATEFIRST setting for my instance? | |
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) |
Level 0 Extended Properties Which of these are not valid level0 types for sp_addextendedproperty? Answer: LOG FILE Explanation: You cannot add extended properties to log files. Ref: sp_addextendedproperty - https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-addextendedproperty-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 2016 - Administration |
Linked server - I can able to grant user who is non sysadmin to linked server by granting rights to user on SYS.XP_PROP_OLEDB_PROVIDER. However, the caveat is it allows user to access all the linked server on the server. Is there a way i can Just grant specific linked server? Please advise? |
VMware datastores and SQL Server drives - Hi, I am changing a standalone SQL Server 2008 R2 to a Windows Failover Cluster 2016 Server with SQL Always On Availability. The current 2008R2 server has the following drive setup: C: (OS), D: (SQL Server 2016 application program files), F: (SQL log files) and G: (SQL Backup files) are currently on one vmware datastore […] |
Accessing data from a case-sensitive server to a case-insensitive server - We had some consultants install a warehouse management software requiring a new database engine to be created on our sql server box. This software requires Latin1_General_BIN collation. As part of an integration project, we are trying to access data in our main ERP software which resides on another server, but has a case insensitive collation […] |
Administration - SQL Server 2014 |
Question related to moving tempdb files into different disk drive - Hi everyone. I asked this question in dba.stackexchange.com but unfortunately I wasn't satisfied with answers so I decided to ask here. Question: is there any point of moving tempdb files into different disk drive if all LUNs are from the same RAID pool? According to best practices, it is recommended to move all tempdb (not […] |
SQL 2012 - General |
Parse XML field? - Hi How would I parse out a value in an XML field Say in the XML field below I want to parse out clientid 12345? Thanks |
SQL Server 2012 - T-SQL |
INDEX REBUILDING DEGRADED PERFORMANCE - Hi Experts, We have a stored procedure to search users. In order to improve performance i have rebuild the index. But the performance of the query degraded. I have attached the actual execution plan before and after index rebuild. Can you help in analyzing why the performance degraded. |
SQL Server 2019 - Administration |
Move SQL Server AG to new Server - We need to migrate our Windows SQL (2014) Server Always-on Availability Group Cluster to new hardware in the same data center with zero down time. This would be from one VMware Cluster to a new VMware Cluster in the same data center. Is this possible? It is on a Windows 2012 R2 Server. Thank you... |
SQL Server 2019 - Development |
Is SELECT a part of DML, DDL or something else? - According to this post https://www.sqlservercentral.com/blogs/what-is-%e2%80%93-dml-ddl-dcl-and-tcl-in-tsql SELECT is classified under DML. However, when I check the SQL online documentation, https://docs.microsoft.com/en-us/sql/t-sql/statements/statements?view=sql-server-ver15 SELECT is not listed under DML. So which language type is SELECT officially classified under? I can't find anything in the online book. The first link above mentions DCL and TCL. Why doesn't the online book […] |
Json String to Multiple Rows - Greetings, I have a json string in the following format and I need to split a small portion out to multiple Rows. My json string is shown below. My goal is to split a small part of this into separate rows as shown below. I've been able to get this into a single row but […] |
Powershell |
copy file from sharepoint site to Azure storage - I'm looking to transfer files from sharepoint site to Azure storage. I cannot use Logic apps or Flow. Planning to use Powershell. Can someone help me with a sample script for the same? Also, this script would be automated to run every 4 hrs. |
Analysis Services |
XMLA discover database roles in SSAS multidimensional - Hi Colleagues, I am breaking my head against XMLA that will list all roles existing in a database. I know I need to use Discover. There is DISCOVER_XML_METADATA DISCOVER_XML_METADATA SSAS_DB_ID But it runs too long and returns several megabytes of information. Yes, it […] |
Integration Services |
Flat File source not recognizing {CR}{LF} - Using VS 2017 I have a bunch of "^" delimited flat files i am importing into SQL server 2019 tables. The files are formatted identically as far as i can see. One of the files fails. The flat file source returns this message "The specified header or data row delimiter "{CR}{LF}" is not found after […] |
SQLServerCentral.com Website Issues |
How do I post a table as part of a forum question? - I have a question which could benefit a lot from having a 3-column table as part of the content. However, although BBCode has a pair, along with the stuff for defining individual rows, this seems not to be implemented on SSC. At least, the example from the BBCode website didn't render properly in preview. Am […] |
COVID-19 Pandemic |
Daily Coping 10 Jun 2020 - Today’s tip is show your appreciation to those who are helping others. http://voiceofthedba.com/2020/06/10/daily-coping-10-june-2020/ |
Daily Coping 9 Jun 2020 - Today’s tip is to think of 3 things you’re grateful for and write them down. http://voiceofthedba.com/2020/06/09/daily-coping-9-june-2020/ |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |