| Here's a few of the new posts today on the forums. To see more, visit the forums. |
| SQL Server 2017 - Administration |
| SQL Service "services" recovery option - Good day all. Quick question. Has anyone, under Services > Recovery for SQL Server, set the following and does anyone have any issues or recommendations. I personally have never set this for SQL Service (or any service) and am wondering if any issues. |
| Visual Studio 2017 Community Edition license expired error - Hello experts, I've run into an issue that many others on the internet seem to report: Although it is free, VS 2017 Community Edition starts presenting a license expired error after 30 days. The main workaround has been to sign into a Microsoft account. However, that workaround doesn't work for computers that are not allowed […] |
| 824 errors - Hi All, Today we are seeing 824 errors on one of the database. When I ran checkdb I am seeing below errors. Note: The database hosted on a 3rd part storage appliance called Actifio. Use master Go DBCC CHECKDB (CDP) WITH ALL_ERRORMSGS, NO_INFOMSGS; GO Msg 1823, Level 16, State 6, Line 3A database snapshot cannot […] |
| Continuous replication from SQL Server to Google's BigQuery - Hello everyone, I have a need for enabling a continuous flow of data from a SQL Server production server to the Google's BigQuery. There are a lot of commercial tools for such purpose and most of them use CDC-based methods for propagating changes, examples: Striim (https://www.striim.com/striim-for-google-bigquery/) StitchData (https://www.stitchdata.com/integrations/sql-server/google-bigquery/) Has anyone had a proven experience that […] |
| Rebuilding indexes with Maxdop on AGs - I was curious if anyone else has ran into this or has an explanation. We cut over to AGs about a year ago and have noticed a weird behavior when rebuilding or adding indexes. Every time we use a MAXDOP greater than 2, the server bogs down causing a lot of queueing and preventing transactions […] |
| Unused indexes - Hi all, I used such script for finding unused indexes in my DB: Hi all, I used such script for finding unused indexes in my DB: SELECT OBJECT_NAME(IX.OBJECT_ID) Table_Name ,IX.name AS Index_Name --,IX.type_desc Index_Type ,SUM(PS.[used_page_count]) * 8 IndexSizeKB ,IXUS.user_seeks AS NumOfSeeks ,IXUS.user_scans AS NumOfScans ,IXUS.user_lookups AS NumOfLookups ,IXUS.user_updates AS NumOfUpdates ,IXUS.last_system_update ,IXUS.last_user_update AS LastUpdate ,IXUS.last_user_seek […] |
| SQL Server 2016 - Development and T-SQL |
| Update table - DECLARE @Name varchar(80) DECLARE @InsuranceReminderDate datetime DECLARE @body varchar(150) DECLARE @Email varchar(100) DECLARE Messaging CURSOR LOCAL FAST_FORWARD READ_ONLY FOR SELECT distinct C.Name,I.InsuranceReminderDate,C.Email from [dbo].[Customer] C inner join [dbo].[Insurance] I on C.ID=I.ID where convert(date,[I.InsuranceReminderDate]) = CONVERT(date, getdate()) I.MsgSent<>1 OPEN Messaging; WHILE 1=1 BEGIN FETCH NEXT FROM Messaging INTO @Name,@InsuranceReminderDate,@Email; IF @@FETCH_STATUS = -1 BREAK; SET @body […] |
| How to filter out the data? - Hello All, Need your help to filter out the data, please. I couldn't find a better term to describe, but hope the example below will instantly clarify what I need: 1. There is a range of simple physical barcodes, applied on imported products - I am sure you have seen many examples in supermarkets around […] |
| Populate Several fields of new record with values from previous record - Hello Everyone - I am a newbie to SQL scripting so please don't take anything for granted regarding my knowledge of SQL, bearing in mind that I have had very limited exposure to it. That been said let me explain my challenge as best I can. I am developing an application using a RAD tool […] |
| real time logging in production enviornment - Hi, What is the best way to do real time logging of SQL server in production environment without affecting the performance of the same. Logging of events like cause of Time Out errors or state of the sql server after the command to exec a stp was called and before that stp was started to […] |
| Is there anything equivalent to a Last() Function - This is just a theoretical question so I don't have any actual DDL to share but hopefully the example I describe below is adequate enough to convey what it is I'm asking. Is there anything equivalent to a Last(@SearchValue,@PrimaryKey) Function that can be used when other traditional aggregations like MIN() and MAX() are being used […] |
| Query to retried list of names with value and if a value does not exist! - Hello, I have 2 tables : Names and NameProperty. In the table NameProperty The property Food as by default a value of YES. The problem is that the default value YES is not showing as line in the table. If a user put it to NO and then saves it back to YES, only then […] |
| Administration - SQL Server 2014 |
| SQLServer won't start? - Hi Not sure what happened, but hoping someone can point me in the right direction. sqlserver won't start, the event log has this error Faulting application name: sqlservr.exe, version: 2014.120.4100.1, time stamp: 0x5535c7e7 Faulting module name: MSVCP100.dll, version: 6.3.9600.19678, time stamp: 0x5e82c88a Exception code: 0xc0000135 Fault offset: 0x06-000000000ecf40 Faulting process id: 0x19ec Faulting application start […] |
| Powershell |
| Using powershell to strip RTF tags and return text. - Hi, We've been looking to pull the text from a table in a vendor DB that stores in RTF format. I found a solution on a site but am having trouble getting it to work. It seems to work ok if I pass a result straight to it but if I try and use SQL […] |
| Analysis Services |
| Dimension key problem - Hi, I need to modify an existing dimension that calculates that how late (how many days) shipments are. What the actual shipments (like IDs or weights or whatever) are completely irrelevant in this context. It is late by X days (zero or less than zero = not late) and that's it. I have the expected […] |
