Difference between Delete and Truncate Command
Although the Delete and Truncate Commands logically does the same work of deleting the rows from the table but still...
2009-12-17
1,254 reads
Blog Posts
Holidays and Parties, Gift, Expectations, and Wishes
Most companies do something at the holidays, although it seems to be less with each year, and certainly this holiday...
2009-12-17
1,006 reads
How to Copy Query Results From SQL Server 2005/2008 into Excel
I often work with DBAs who need to copy the results of a T-SQL query from SQL Server Management Studio...
2009-12-17
5,039 reads
How to Shrink TempDB in SQL 2005
Introduction
From time to time you find yourself needing to shrink some space out of TempDB. Shrinking database files is never...
2009-12-17
3,035 reads
Reporting Services Licensing
Licensing models can sometimes make database modeling seem trivial. Per processor or per seat? Single core, dual-core, multi-core processors? Multiple...
2009-12-17
2,808 reads
Securing Log Shipping
There was a post recently where someone was asking about securing log shipping to comply with HIPAA requirements. It struck...
2009-12-17
1,227 reads
Using Google Docs for Note Taking
I've admittedly been a terrible note taker growing up. Throughout most of school, I've always been able to remember everything...
2009-12-17
2,122 reads
Where’d the Data Go?
The Reported Problem
A few weeks ago I was contacted by a former employer because an SSRS report I had written...
2009-12-17
404 reads
Machine SID Doesn’t Matter
Ran across this post from Mark Russinovich titled The Machine SID Duplication Myth that seems to debunk the idea that...
2009-12-16
781 reads
My Greatest Weakness
I was tagged by Mike Walsh in the latest meme to circle the SQL Server community, which is what is...
2009-12-16
1,631 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