Here's a few of the new posts today on the forums. To see more, visit the forums.
|
| SQL Server 2017 - Administration |
| Application query time out - I have an application that is attempting to perform a function (modifying records, so I'm assuming an update query) under a certain user's session and it is timing out. Is there a way to easily monitor what is happening in the database to examine what the issue might be, something to get the exact query […] |
| SQL Server 2016 - Administration |
| SQL Server and CloudStrike - Has anyone had issues with CloudStrike Anti-Virus on their SQL Servers? I've had a client install CloudStrike, and within 30 minutes the SQL Server became unresponsive and stopped accepting new user connections. The server has been running without issues for about 2 years. We had to do a forced Service Shut down from an existing […] |
| SQL Server 2016 - Development and T-SQL |
| best way to extract name and number - I have data in a field called user_name that consistently follows this format: (t) Joseph Kelly -14784 (tb) Shenna Brown -15488 (tb) Paul Ledford -15358 (b) Quadra Tomson -15316 (t) Tracy Edwards -15218 I can get the number out easily with "SUBSTRING([user_name], CHARINDEX('-',[user_name])+1, 25) as EmployeeID", e.g.: 14784, but I'm having trouble using the same […] |
| SQL 2012 - General |
| how to identify BottleNeck by using the data of sys.dm_os_performance_counters - There are many many data to show the SQL Server current performance, May I know how to use these counters to observe the SQL Server's performance? that is to say, which parameters show the IO bottleNeck and Disk bottleNeck?RAM bottleNeck etc ? it means the cntr_value exceed which value there will be a bottleneck, thanks! |
| how to solve error Conversion failed when converting the nvarchar value '24VAC/D - I work on SQL server 2014 I get error when run statement below error say Conversion failed when converting the nvarchar value '24VAC/DC' to data type int. I got error when execut dynamic sql EXEC (@SQL) so how to solve this error please data sample IF OBJECT_ID('dbo.TAllfeatures') IS NOT NULL DROP TABLE dbo.TAllfeatures IF OBJECT_ID('dbo.TCondition') […] |
| SQL Server 2019 - Development |
| SQL Query Help on Time based query - I have a following table (Contains script to generate the sample table with data): CREATE TABLE [dbo].[Test]( [Schedule_Start_Date] [varchar](8) NULL, [UserID] [int] NULL, [Code] [varchar](10) NULL, [Start_Time] [time](7) NULL, [Duration_Min] [int] NULL ) ON [PRIMARY] GO INSERT [dbo].[Test] ([Schedule_Start_Date], [UserID], [Code], [Start_Time], [Duration_Min]) VALUES (N'20211030', 1562, N'Shift', CAST(N'10:00:00' AS Time), 720) GO INSERT [dbo].[Test] ([Schedule_Start_Date], […] |
| Query help - create table assessments ( id integer not null, experience integer not null, sql integer, algo integer, bug_fixing integer, unique(id) ); INSERT INTO assessments VALUES(1, 3, 100, NULL, 50) INSERT INTO assessments VALUES(2, 5,NULL,100,100) INSERT INTO assessments VALUES(3,1,100,100,100) INSERT INTO assessments VALUES(4, 5,100,50,NULL) INSERT INTO assessments VALUES(5,5,100,100,100) I need the query to return xp | max […] |
| Query Performance Tuning - Hello All, I have a temp table inside my procedure and its taking lot of time. Could anyone suggest how to optimize this.. Below is my piece of code. declare @User table ( UserName varchar(200), InstalledDate varchar(max) ) insert into @User select main.UserName, left(main.installs,len(main.installs)-1) as "Installs" From ( select distinct ins2.UserName, ( select convert(varchar(200),ins.FirstSeenDate)+', ' […] |
| Data Masking - Hello All, I'm working on a project that the manager would like to mask some sensitive data. I know that there is a dynamic data masking function currently on the sql server 2019, but as far as I researched looks like it need to be done on a table column right? On my case the […] |
| SQL Server 2008 - General |
| Table Date field format - I created a date field [Datte] in SQL v2008. I then link with MS Access. No problem. Done this many times. However, this time, when I open the table in MS Access, the date displays as: 2021-03-15 (yyyy-mm-dd) All my other tables display like I want it: 03/15/2021 (mm/dd/yyyy) The field attribute is date, not […] |
| Reporting Services |
| ReportingService2010 soap call to set report credentials - I have written a routine to speed up the upload and download of reports from our reporting server. The problem is that the reports do not retain their credentials when you download them. So I've tried to update them after uploading the report, but get an error when the report is run. An error has […] |
| Get Full Name and Last Name in Report - Hello, i have tried multiple expressions from websites and couldn't get the real answer. What is the full expression that gives me the First and Last Name in SSRS expression: For ex: John Andrew Brown Hill = John Hill. |
| Help with Column Visibility Expressions - I have a parameter in my report labeled as PaySource. PaySource has 3 values associated to it, a Value of 0 = "Total", 1 = "Patient" and 2 = "Insurance". In my report, I have 3 columns - Patient, Insurance, and Total. I need help with my Column Visibility Expression on each of these columns. […] |
| SSRS 2012 |
| Error Report - Hi All When i access to report server and i try to open report JV directly i get error, see att file, and when i acces with Modify in generator, i can run report |
| General |
| How do I use Workspaces in Azure Data Studio? - I've been working with Azure Data Studio (ADS) for maybe two years, but I've only yesterday learned about something called "workspace" in ADS. I ran into problems when trying to commit SQL code to a Git repo. ADS showed me two unrelated Git repos and I don't think that ADS knew which repo to put […] |
