Msg 7395: Unable to start a nested transaction
Happy new year, SQL peeps! I hope everyone had a wonderful holiday. Last week was very quiet at work, but...
2012-01-05
2,959 reads
Blog Posts
PASS Summit Eval – Extended Events
As I mentioned in yesterday’s post, I had two sessions at the PASS Summit this past year in which I...
2012-01-05
741 reads
Safely Restart SQL Agent with Powershell
I recently had to enable tokens in SQL Agent across about 50 instances. Unfortunately, enabling tokens requires a SQL Agent...
2012-01-05
1,715 reads
SQL Server Disable Indexes and Rebuild Indexes dynamically
To generate the ALTER INDEX..DISABLE and the ALTER INDEX..REBUILD statements for all nonclustered indexes for a single table use the...
2012-01-05
1,157 reads
SQL Server Login Auditing
In recent months I have been asked to ensure we are auditing both successful and failed logins, not just failed...
2012-01-05 (first published: 2012-01-03)
2,742 reads
The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.
You may fire up the SharePoint 2010 Management Shell (which allows you to run PowerShell commands to do cool SharePoint...
2012-01-05
2,213 reads
Daemon
At the recommendation of Jorge Segarra (Blog | Twitter), I got the book Daemon. Well, I actually got that about a year ago as a gift – but it...
2012-01-04
Daemon
At the recommendation of Jorge Segarra (Blog | Twitter), I got the book Daemon. Well, I actually got that about a...
2012-01-04
894 reads
Difference between ETL and ELT
ETL is the most common method used when transferring data from a source system to a data warehouse. But there...
2012-01-04
7,565 reads
Have You Planned Which SQL Server Events You Will be Attending in 2012?
2012 is already upon us and I have been busy working on my travel schedule for this year. It is...
2012-01-04
664 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 determine if a DB is currently being used
Hi - I'm looking for advice regarding the best & quickest way to establish...
Data cleansing/conversion tool HPE
Hello. I am looking for a tool Data cleansing/conversion, was recommended HPE any...
System views in a contained availability group
I have a query that runs in a job to check on orphaned users....
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