Converting Old Running Total Code to Window Fun ctions (2024-09-30)

Click here to subscribe to Sqlservercentral.com

2 months ago

Html
Text

Problems displaying this newsletter? View online.

Featured Contents

Converting Old Running Total Code to Window Functions

Steve Jones - SSC Editor from SQLServerCentral

This article looks at the old style of calculating a running total and how to convert that to code that uses a window function.

SQL Index Rebuild vs Reorganize Comparison

Additional Articles from MSSQLTips.com

This tip covers the differences and similarities between SQL Server index rebuild and index reorganize operations.

From the SQL Server Central Blogs - Monday Monitor Tips–Finding CUs for My Instance

Steve Jones - SSC Editor from The Voice of the DBA

How can I quickly get a CU patch for a system that’s out of date? I’ll discuss that situation. You might think you get to patch every instance every...

From the SQL Server Central Blogs - Why CFOs Can’t Afford to Delay BI Adoption

Joyful Craftsmen from Joyful Craftsmen Blog

The post Why CFOs Can’t Afford to Delay BI Adoption appeared first on Joyful Craftsmen.

Deciphering Data Architectures

Additional Articles from SQLServerCentral

Data fabric, data lakehouse, and data mesh have recently appeared as viable alternatives to the modern data warehouse. These new architectures have solid benefits, but they're also surrounded by a lot of hyperbole and confusion. This practical book provides a guided tour of these architectures to help data professionals understand the pros and cons of each.

Question of the Day

Today's question (by Steve Jones - SSC Editor):
	Migration Assistant Issues
If I run the Data Migration Assistant to check for an upgrade from SQL Server 2008 to SQL Server 2022, which categories of issues are pointed out as potential items that can affect an upgrade? (choose 3)
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)

Enable a Disabled Index

I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?

Answer: ALTER INDEX LoggerCI on dbo.Logger REBUILD

Explanation: The ALTER INDEX command with REBUILD is used. Ref: Enabling Indexes and Constraints - https://learn.microsoft.com/en-us/sql/relational-databases/indexes/enable-indexes-and-constraints?view=sql-server-ver16

Discuss this question and answer on the forums

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

Error 28054 related to master key root cause and solution required - I am getting the following error in SQL Server Error Log randomly on few days. I want to know the root cause for this error so that we can decide on applicable solution for this particular error. Service Broker needs to access the master key in the database. Error code:32. The master key has to […]

How to attach Database created in higher version to lower version of SQL Server - I have attempted to attach a database created in a higher version of SQL Server to a lower version, but I encountered errors. I also tried the backup and restore method, which resulted in errors as well. According to the following link, I explored several options but was unsuccessful: https://www.mssqltips.com/sqlservertip/2810/how-to-migrate-a-sql-server-database-to-a-lower-version/ 1. Generate Scripts Wizard in […]

SQL Server 2016 - Administration

application not connecting to secondary - Hi the application which has the connection string of the listener configured connects to node S01 but when failed over to S02 it does not connect there are no applicable error in the SQL logs and windows logs please let me know

Development - SQL Server 2014

Query to return all data that has same site, section and date - I have a query Select Id, WOCode, Site, Section, CompletionDate from work orders where type = 'BRE'. I want to be able to return list of all WOCode that has same Site,Section and CompletionDate. The date field will be date only with no time

SQL Server 2019 - Administration

sql monitoring tool - Has anybody had any experience with Nagios as a SQLServer monitoring tool. What were the pros and cons you had faced while using it. Please advise.

Failed restore database - Hi All , I have issue restoring small database . SQL version : SQL 2014 In the server , At first I took a backup of database ( bak file ) and compressed it . Then I copied ( standard copy ) to my local laptop from server , after that I copied back to […]

SQL Server 2019 - Development

max and min dates - Hi I am trying to get the first and last days for the following where date_next_compare is less than 28 but having more than that would mean the max date for that range. Sorry if isn't clear. I currently have this: I want to see two rows like below. I tried doing min and […]

Pivot Mistake - Hi all, I have this query where I make a pivot to extract the data segmented by Hours: select ‘Amount’ as Amount, [0] ,[1] ,[2] ,[2] ,[3] ,[4] ,[5] ,[6] ,[7] ,[8] ,[9] ,[10] ,[11] ,[12] ,[13] ,[14] ,[15] ,[16] ,[17] ,[18] ,[19] ,[20] ,[21] ,[22] ,[23] from (select sum(efeneg) ‘Amount’,left(hormsg,2) ‘Time’,left(hormsg,2) ‘Time’,left(hormsg,2) ‘Time’. from […]

open query via linked server to db2 is showing terrible performance - Hi this post is mostly about cross server concepts vs a query being sent to and run on the target server and then the data simply coming back over the network. but any feedback is appreciated. we have a sql server linked server thru which the db2 erp query (view) shown below is sent to […]

General

What is Azure Data Studio or GitHub asking me? - I have an Azure Data Studio question (or maybe it's a GitHub question, I'm not sure), but I couldn't find a forum here to ask it. So, please excuse my asking it here. I am busy writing a T-SQL script, using Azure Data Studio. I committed my changes locally, then I tried pushing them to […]

How do data visualization consultants overcome the challenge of integrating? - Integrating multiple data sources is challenging due to differences in data formats, structures, and quality. Data visualization consultants must first establish data connections and ensure consistent data formatting. This often involves using ETL (Extract, Transform, Load) processes to clean and combine data. They must also handle data refreshes and ensure that integrated data is up-to-date. […]

SQL Server 2022 - Administration

SQLExternalMonitoring what is it in sp_who2 result - If I run sp_who2, one of item in the list is showing using program SQLExternalMonitoring , what is it? it uses quite a bit cpu and ram. 70 sleeping NT AUTHORITY\SYSTEM SNOCSMASQP01 . master AWAITING COMMAND 170846212 57458731 09/26 10:31:41 SQLExternalMonitoring 70 0 Thanks,

Linked Server to SAP HANA database. - Greetings all. It's been a very long time, but I'm back. Does anyone have experience with setting up a linked server to a SAP HANA database? I have hanaclient-2.8.20-windows-x64 installed and a DSN created using the HDBODBC driver that comes with the client install. I am able to use the DSN to connect with generic […]

SQL job & SSIS package excution - Hi SQL experts, We have installed SQL Server with 2022 and using this as SSIS server. SSIS DB is the only one database on this server. We deployed a SSIS package, which is scheduled to run every 1 hr through SQL agent job. The job is failing sometimes & running successfully other times. The job […]

SQL Server 2022 - Development

SQL Query Optimizer Supporting Parameterized Query and WHERE Clause Optimization - I am looking for a SQL query optimization tool that can enhance my query execution times. I have already tried EverSQL and SQL Tuning, but they are not meeting my requirements for the following reasons: 1. Parameterized Queries: Both tools seem to struggle with parameterized queries and do not optimize them correctly. 2. WHERE Clause […]

This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Share on

Other newsletters from Sqlservercentral.com

Anything is possible, if you put your mind to i t. Like reading all of these blogs! Sqlservercentral.com
Yesterday at 08:22
Improving Performance for Some LIKE “%stri ng%” Searches (SQL Spackle) (2024-11-29) Sqlservercentral.com
Last Friday at 08:09
Simplify Data Loading with Fivetran (HVR): Data Engineering with Fabric (2024-11-27) Sqlservercentral.com
Last Wednesday at 08:03

More newsletters from Sqlservercentral.com

Converting Old Running Total Code to Window Fun ctions (2024-09-30)

Share on

Other newsletters from Sqlservercentral.com

Related newsletters