|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Azure Serverless Compute Cost | |
If my Azure Serverless database is paused from no activity, do I incur a compute cost? | |
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) |
Heap Order How is data stored the the rows in a heap? Answer: In no guaranteed order Explanation: A heap has no guaranteed storage. In general, as you add data, the data gets added in INSERT order, but an insert can be added to any page where there is space. Ref: |
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 |
Create view by accessing tables from other server - Hi, Need to create a view in a database in server A by using the tables from other database in server B. Is it possible ? Any suggestions please. Thank you. |
Syntax to QRY XML Data - What is the syntax to Query this XML data to find a statement = "coalesce" or any other text string , within a date range ?? I created a table EE_Table with Extended Events data in it. It has 1 column, defined as XML, called Event_Data. Something like this? select * from EE_Table where event_data.value('(/event/data/value)', […] |
Query Store regressing queries Report: can I get its results without GUI? - The GUI is beautiful and all. Yet only Sr. Prod DBAs can access that, noone else, in our environment. Can I request them to send me that report in any other format than visual/direct access via GUI? How? is there a ready script for something like that somewhere by any chance? Thank you. |
SQL Server 2016 - Development and T-SQL |
Efficient nested query to query on string and fetch corresponding PK - Hello, The search text (not exact match) is in excel column and will be passed to sql query to fetch the data from database. I am using vba for querying the database. My sql description column sample is attached herewith. Thanks |
Administration - SQL Server 2014 |
creation of sql authentication login with a specific requirment - Hi All, As an admin we create sql authentication logins for application users. For those logins, we want to give the ability for the user to change the password and should never expire. To accomplish this requirement, what specific permissions we should give for the sql login? Thanks, Sam |
SQL 2012 - General |
How to add column columnunit dynamically when FlagAllow is 1? - How to add column column unit dynamically when Flag Allow is 1 on table #nonparametric table ? I work on SQL server 2012 I can't add column unit dynamically when Flag Allow=1 as example below I have two rows have Flag Allow=1 family 90AM will be family 90 and family unit AM on two column […] |
How to do User Defined Function take input as text and output text and numbers ? - problem How to make UserDefinedFunction on sql server 2012 split column text to two columns . first column include text characters as unit measure only and second column include numbers only in case of integer or decimal etc..? create table #temp ( columnTextNumbers nvarchar(50) ) insert into #temp (columnTextNumbers) values ('3.5A'), ('5.50kg'), ('35.70kg'), ('9m') I need […] |
SQL Server 2019 - Administration |
SQL 2019 FCI in Azure - Unable to Connect on Secondary Node - Hi - I setup a new SQL FCI in Azure. Two newly created VMs with SQL 2019 installed. Cluster validates successfully and i configured the Load Balancer per the Microsoft recommendations. I am able to connect to the SQL FCI from the node it is currently running on (can connect via SSMS or even just […] |
SQL Server 2019 - Development |
Where to fit CREATE statement in script with MACROS? - Hi All, Not too familiar with Macros at all, but I have adjusted a pre-existing script and I am trying to create a Table from it. The query works fine but I just font know where to fit my CREATE OR REPLACE table statement (CREATE OR REPLACE TABLE Bookings_Monthly AS) Any advice? If its relevant, […] |
Calculating Previous and Next Week - Hi ,I do have Year week as below as Integer and I would like to know if we have any best way to calculate the Previous Year Week and Next Year Week . Do we have any formula to calculate it . Thanks in Advance Year Week : 201952 , 201953 , 202001 , […] |
General |
Does anyone have the Microsoft Auto Index Tuning DB - I have left my old job but cannot find a copy of the Auto Tuning Index DB TSQL that I used to have on all my servers. It was written about 10 years ago I believe by Microsoft people and I took the code from their blog. However I cannot find the SQL to rebuild […] |
Integration Services |
SSIS XML Parsing Error with Parent/Child Elements with Same Name - I am having a problem parsing an XML file to MS SQL staging tables via SSIS due to the XSD file structure which I may not change. Here is the XSD format: […] |
SQL Saturday and User Group Organizers |
Improving PASS - Debate on how to make PASS better. Please keep it civil and actionable. Suggestions needed on 1 Is PASS adding value to community, if not how can we do more? 2 How are user group affiliations working? 3 What are alternates to using an expensive management company, if that is a suggestion. 4 What can […] |
COVID-19 Pandemic |
Daily Coping 18 Jun 2020 - Today’s tip is to say positive things in your conversation with others today. http://voiceofthedba.com/2020/06/18/daily-coping-18-jun-2020/ |
Daily Coping 17 Jun 2020 - Today’s tip is to take a photo of something that brings you joy and share it. http://voiceofthedba.com/2020/06/17/daily-coping-17-jun-2020/ |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |