Get SQL Server Physical Cores, Physical and Virtual CPUs, and Processor type information using Transact-SQL (T-SQL) script
Today, I received email from one of my blog follower asking if there is any DMV or SQL script, which...
2014-01-22
1,354 reads
Basit's SQL Server Tips
Cumulative Update # 8 for SQL Server 2012 Service Pack 1 is now available!
The 8th cumulative update (CU8) for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft...
2014-01-22
499 reads
Monitor availability groups and availability replicas status information using T-SQL
Just a quick blog post to share a query, which I wrote to monitor availability groups and replicas and the...
2014-01-20
1,771 reads
SQL Server monitoring and optimization
To optimize the performance of your database, you need to monitor and tune. You determine the performance baseline, how SQL...
2013-12-18
947 reads
Nine T-SQL best practices
SQL Server databases are the backbone of many enterprise applications, and good Transact-SQL (T-SQL) code is the best way to...
2013-12-16
945 reads
How to work around Azure database migration limitations
Microsoft Windows Azure SQL Database, commonly known as SQL Azure, is a relational database in the cloud that is part...
2013-12-14
603 reads
Understanding SQL Server Query Optimization – Part 3
A critical part of database design and management is index design. Index design involves balancing space requirements and the resource...
2013-12-14
493 reads
Understanding SQL Server Query Optimization – Part 2
An execution plan is the sequence of operations SQL Server query optimizer performs to run the statements. The SQL Server...
2013-12-14
1,255 reads
SQL Server Encryption Options
Many database servers store confidential data, which must be protected from unauthorized access when it’s transmitted across the network and...
2013-12-14
672 reads
Bulk Transfers: Some guidelines
Bulk transfers are a common way of importing large amounts of data into, or exporting large amounts of data out...
2013-12-14
537 reads
Blogs
Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
Counting Groups with Window Functions: #SQLNewBlogger
By Steve Jones
I looked at row_number() in a previous post. Now I want to build on...
The query processor ran out of internal resources and could not produce a query plan – When You’ve Managed to Confuse SQL With a Crazy IN Clause.
Recently I received a cry for help over Teams. The issue was that an...
Forums
How to merge two tables with unlike fields
How to merge two tables with unlike fields. I have two table with one...
Visual Studio 22 / SSIS Project / (Project) Connection problem
Hello, First of all, I find it odd/annoying that I can't exclude a Project...
How to determine if a DB is currently being used
Hi - I'm looking for advice regarding the best & quickest way to establish...
Question of the Day
The LAGging NULL
I have this data in a SQL Server 2022 table:
player yearid team HR Alex Rodriguez 2012 NYY 18 Alex Rodriguez 2013 NYY 7 Alex Rodriguez 2014 NYY NULL Alex Rodriguez 2015 NYY 12 Alex Rodriguez 2016 NYY 9If I run this code, what are the results returned in the hrgrowth column?
SELECT player , yearid , hr , hr - LAG (hr, 1, 0) IGNORE NULLS OVER (ORDER BY yearid) AS hrgrowth FROM dbo.playerstats;See possible answers