|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
More Python Lambdas | |
I have this lambda defined:
x = lambda a: a * 2What happens with this code? x('a') | |
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) |
Azure Blob Store Redundancy Which type of redundancy offers this: data is replicated synchronously across three Azure availability zones in the primary region. Each availability zone is a separate physical location. Answer: Zone-redundant storage (ZRS) Explanation: When you want to ensure you have replication across Azure availability zones in one region, you can use ZRS. 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 2017 - Development |
Find gaps in string values within a table - I have a table with ~500K rows in it. Here's a sample of the data BegVal EndVal Volume Prefix Padding begnum endnum ABC000063738 ABC000063738 VOL001 ABC 9 000063738 000063738 ABC000063739 ABC000063740 VOL001 ABC 9 000063739 000063740 ABC000063744 ABC000063746 VOL001 ABC 9 000063744 000063746 DEF00000009 DEF00000011 VOL002 DEF 8 00000009 00000011 DEF00000012 DEF00000014 VOL002 DEF 8 […] |
SQL Server 2016 - Administration |
Suspect database on Secondary due to Log Redo issue - I have sqlserver 2016 in an AG with 2 secondary's for readonly and have recent cu. I have had multiple times in last 2 months where one of the secondary databases goes into suspect mode. Could not redo log record and suspend from redo are what I keep seeing Also, it's the same database every […] |
SQL Server 2016 - Development and T-SQL |
SSRS cascading parameter doesn't change value when upstream parameters change - My report has a title that is based on the values in a couple of parameters. I'd like to add a feature to the report where the user can overtype the value for that title when the logic that sets it doesn't give quite the result they'd like. I tried adding a parameter for that […] |
Insert into Table Not Working - supplied values does not match - Hello Community, I watched demonstration which showed how to insert values into a table with a view to adding a row to an existing table with new values. The following is an image showing that the 'Insert' working and add an entityID of 207 When I run the same code on my SQL server (with […] |
Automate SQL query to send excel spreadsheet via email - I have this SQL query that runs perfect. I now would like to automate it as a stored procedure that emails the results in an Excel spreadsheet. Any pointer? Thanks for any help you can provide. Here is the query: select SiteID, case when SiteID = '001' then 'Omaha Terminal' else 'Geneva Terminal' end as […] |
update target table when there is any changes in source table columns - Good Morning, I have a question regarding Update statement between two tables (stage_Table, Final_Table). Here Stage_Table is daily refreshes (truncate and load from feed) Fianl_table contains full data that includes everyday new records and changes over time here in final_table we have two columns that are part of Primary key (Col1, Col2) in the both […] |
Development - SQL Server 2014 |
Dashes in uniqueidentifier - Are the dashes in the UniqueIdentifier always in the same index position? I have an Asp.Net mvc application where I pass a uniqueidentifer in the querystring as one of the parameters. Normally this is not an issue to have the dashes in it. However, In one solitary instance where I am creating a Pdf document, […] |
Works fine in SSMS - Zero records in agent job - xp_dirtree - Hi, If I run this in SSMS it returns 7000 file names (works great): -- ############################################################################## -- BEGIN - Dump entire file tree of the documents folder into a SQL table -- ############################################################################## IF OBJECT_ID(N'tempdb..#dirs') IS NOT NULL BEGIN DROP TABLE #dirs; END; IF OBJECT_ID(N'tempdb..#directoryTree') IS NOT NULL BEGIN DROP TABLE #directoryTree; END; DECLARE @BasePath […] |
Sudden Duplicate rows - Hello My query has been running for ages without a hitch but yesterday , Some totals on one of the customers exactly doubled in value , I noticed that the rows had doubled in the query instead of 22 rows there were 44. but when I stripped out the query , I got 22 rows […] |
SQL 2012 - General |
Creating a table using an existing partition scheme - I have a partition scheme created and just need to create a table using it, but i need to use syntax for adding the indexing and primary key at the same time if possible. Can this be done? "PS_Year_Partition" is my partition scheme name: CREATE TABLE [dbo].[CallLogCommonPartitioned]( [CALL_ID] [varchar](255) NOT NULL, [DATE] [date] NOT NULL, […] |
SQL Server 2019 - Administration |
SQL Server Availability Group Database Backup - When performing Full Backup and Log Backup of an Availability Group database. How is the log chain not broken when the Availability Group fails over to the Secondary node in a two node Cluster? As I see it we have a 2 node cluster with Full Backup and Log Backup running on Node A. Then […] |
SQL Server 2019 - Development |
Extracting out elements from XML String based on condition in tag - Hi there i want to extract data from XML string based on certain criteria My xml is as follows: declare @DataSheetXML xml = ' RadioStats_00 16 0 false 0 th 11 ad779x_5 ad779x_5 16 0 sixteen_bit_raw false 0 Temperature instrumentation decode_thermistor_V1 temperature Degrees […] |
SQL Azure - Administration |
Copy database from another with Managed Instance - Hi I have the need to programmatically create a new database as a copy of an existing one, within the same Azure Managed Instance. I have searched for hours and cannot find a way to do it! This need will arise frequently, hence the need to do it programmatically. I presume it has to be […] |
Reporting Services |
I need help with the NuGet package Microsoft.SqlServer.Types - The NuGet package Microsoft.SqlServer.Types and the Microsoft.SqlServer.Types.dll are the bane of my existence at my current job. I have struggled with them both, for at least 3 years. I've tried to contact the owners of the NuGet package on and off over the last 3 years. It has never worked; they have never replied. So, […] |
General |
The Best of SQLServerCentral.com ebook broken links - Hi all, the links to the aforementioned ebook seems to be broken:( I would appreciate if anyone could help me on my way to finding these awesome resources - any of them, particularly the earlier ones, as I am new! |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |