A Page-Splitting Headache - Page Split Mini-Series
Page splits are a normal occurring process in an OLTP system. However, too many page splits can cause performance issues...
2014-09-03 (first published: 2013-07-08)
9,686 reads
Robert Pearl
Get SQL Server Info - Quick Tip & Script
There
are a number of ways to collect basic information about SQL Server, its
version, edition and other top-level properties. What is...
2014-07-28 (first published: 2014-07-17)
11,337 reads
Congratulations MVPs - Team USA (the other world cup)
While the World
Cup was still going on, and the folks in the USA had a real reason to root
for the...
2014-07-02
1,191 reads
SQLSaturday #294 DBA 4 Dummies - post event commentary...
Had an awesome time at #SQLSat294 in Philly (MS HQ in Malvern, PA to be exact). Was great seeing the...
2014-06-10
1,545 reads
Happy Memorial Day - Freedom is Never Free!
Well, as all folks in the United States know, this weekend we celebrate Memorial Day, Monday May 26, 2014. While...
2014-05-23
1,477 reads
T-SQL Tuesday #54 - Interviews and Hiring
Well, it's that time again! It's TSQL Tuesday #54, and its about Interviews and hiring. I'm writing this free style...
2014-05-16 (first published: 2014-05-13)
3,770 reads
Summer SQL Server & Database Events In and Around NY
Summer SQL Server & Database Events In and Around NY-
Happy May everyone!
Hope those April showers will bring us May flowers! ...
2014-05-01
2,355 reads
DBAs should be on CLOUD 9 - IT Trends
For all the talk and initial fear that the DBA is going the way of the Dodo (pronounced doh-doh) (an...
2014-03-18
2,098 reads
Configuring Native Mode SSRS on local host
OK, so you successfully installed SQL Server and you selected to deploy SQL Server Reporting Services using the default installation...
2014-03-06
17,241 reads
Tonight: NYC Metro User Group Presents Kimberly L. Tripp & Jonathan Kehayias
Tonight: The NYC Metro User Group Presents Kimberly L. Tripp (blog) and Jonathan Kehayias (blog)!
Let's welcome them to NYC! Now at...
2014-02-25
1,213 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers