|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
What is a measure? | |
What is an example of a measure in DAX? | |
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) |
XEvent Events What is an event in Extended Events (XEvents)? Answer: A monitoring point of interest in the execution path of a program Explanation: An event is a point that fires in code. From BOL: "Events are monitoring points of interest in the execution path of a program, such as SQL Server. An event firing carries with it the fact that the point of interest was reached, and state information from the time the event was fired." Ref: SQL Server Extended Events Packages - https://docs.microsoft.com/en-us/sql/relational-databases/extended-events/sql-server-extended-events-packages?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 2017 - Administration |
AWS Database Migration Service causing problem - SQL Server as Source - Hello folks, I have a problem using the AWS Database Migration Service for implementing a transactional replication from SQL Server as a source database engine, a help is highly appreciated. The 'safeguardPolicy' connection attribute defaults to 'RELY_ON_SQL_SERVER_REPLICATION_AGENT'. The tools will start mimicking a transaction in the database for preventing the log to be reused and […] |
Things need to check - Hi, can anyone please suggest what are things needs to check after windows patching and Sql Server Patching on the server. Eg : Services Running like.. |
SQL Server 2016 - Administration |
Uptime history without Monitoring tool - I could able to view the last restart of sql server using dm_os_sys_info. But checking is there a way to see the history of uptime of sql server something like graph?My understanding is that DMV loses the information after the restart of the server. Also looking to see the CPU resources likes historical information . […] |
Development - SQL Server 2014 |
SQL Data Flow Tool - Hi SSC, I'm looking for a tool which helps me achieve the following: Understand what happens inside a stored procedure and in which order Here's a partial example: SET @NoOfRecordsPendingBefore = ( SELECT COUNT(*) FROM RRawData (NOLOCK) WHERE R_Status_ID = @STATUS_REJECTED ) SET @NoOfRecordsInFile = ( SELECT COUNT(*) FROM RRawData (NOLOCK) WHERE R_Status_ID = @STATUS_NOT_PROCESSED […] |
SQL 2012 - General |
SQl Server Security - Dear All In my company using sqlserver Standard edition.As of now we are only maintain all the client database server client premises.but now company will change the business model.they bring partner base sales model.Here after we are not directly contact with clients. We will sell use base licence to Partner. then partner sell to client. […] |
SQL Server 2019 - Administration |
Create a new instance SQL server 2019 - Hi, I'm kinda new to setting up MS SQL DB related stuff. I want to create a new DB instance for SQL server 2019. There's already one instance running. I assume should go with the alternative called "Perform a new installation of SQL Server 2019"? Will this have any effect on the current running instance? […] |
SQL 2008 Enterprise to 2019 ¿Enterprise or Standard? - Hello !! First, let me say im not a DBA expert, and im facing a hard decision We have a DB on SQL 2008 Enterprise. Since SQL 2008 is out of support from MS we decided to move to a newer version (2019) My main question is: Is there any performace difference between Standard and […] |
SQL Server 2019 - Development |
ORDER BY in the OVER clause - I am using the AVG( ) with the OVER clause and within the OVER clause I have a question about ORDER BY. In the attached Excel file, I have two examples, one on each tab. Both tabs show table in the FROM clause in teal green (columns A:F). Also on both tabs, the result of […] |
NVarchar field sizes - Hi, In my database I have a table with product information. The number of records in the table varies from 10.000 to max 50.000. There are approx. 20 text fields that are defined as NVarchar. There are no indexes on these fields. Activities on the table are in most cases less than 1000 times access […] |
T-SQL: Pulling Different Data from the Same Table - Hi: The results of the first code below are attached as the file called "Results". Likewise, the results of the second and third code are attached as "Results2" and "Results3", respectively. The table for both of these codes is FMItem. The first code has a field called IM. This is equal to the FormulaID field […] |
Reporting Services 2008/R2 Administration |
Report Builder & RSReportDesigner.config - I installed SQL Server Report Builder 2008 2.0. When I try to connect to a SharePoint List, I get this error: The selected data extension SHAREPOINTLIST cannot be loaded. Verify that the selected data extension is correctly registered in RSReportDesigner.config, and is installed on the client for local reports and on the report server for […] |
XML |
How to get at value? - Hello, I want to pluck out the values for "" and "" but could not figure out the right syntax (don't know how to reference "<rd:"). Below is the XML code fragment, followed by the select statement. Any help is appreciated. thank you, beth - - - […] |
Integration Services |
API call with no wsdl - I have an API call that passes parameters via the query string and then returns either JSON or CSV. I know I can do it with a script transformation as a source but I wanted to use a web services as a source if possible? I have done some research but it seems that a […] |
Articles Requested |
Allow User to Run Jobs - A common question, but allow a normal (non sysadmin) to run a specific job. I'd like an article that shows 3 jobs in a system. Job 1 - User A can only run this job. User B can run this job Job 2 - User B can this job. Job 3- only the sysadmin can […] |
COVID-19 Pandemic |
Daily Coping 30 Apr 2020 - Take a minute to remember what really matters to you and why. My thoughts: http://voiceofthedba.com/2020/04/30/daily-coping-30-apr-2020/ |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |