64 bit
Today we have a guest editorial from November 26, 2005. Steve Jones talks about the transition to 64 bit architectures.
Monitoring Table Size Growth in SQL Server
This article demonstrates how to monitor table size growth in SQL Server.
Viewing RING_BUFFER_OOM Errors
Onion Ring Buffer?
A client asked a co-worker to take a look at a query for reviewing RING_BUFFER_OOM messages in sys.dm_os_ring_buffers. ...
Hidden SSIS Features: Word Wrapping Your Annotations And More
Provides undocumented adjustments to package XML to enable Annotation Word Wrapping and other features.
The Institute for Backup Trauma
Today we have an editorial reprinted from April 27, 2005. Steve Jones is on vacation, so we are reprinting this look at backup strategies and media.
The Twelve Days of SQL
As we approach the holidays, Steve Jones talks about the latest blog theme, and how nice it is to see these types of things from the community.
Can You Dig It? – Missing Indexes
She can dig it!
D Sharon PruittWhen I started using XQuery to dig into the plan cache, it was just searching...
Get script for every action in SQL Server Management Studio
I am always conscious to keep a record of all operations performed on my database servers. Operations through T-SQL in an SSMS query pane can easily be saved in query files. For table modifications through SSMS designer I have predefined setting to generate T-SQL scripts. However there are numerous database and server level tasks that I use the SSMS GUI and I would like to have a script of these changes for later reference. Examples of such actions through the SSMS GUI are backup/restore, changing compatibility level of a database, manipulating permissions, dealing with database or log files or creating/manipulating any login/user. I am looking for any way to generate T-SQL code for such actions, so that it may be kept for later reference
SQL Server 2005 SP4 Has Been Released
Microsoft completed SQL Server 2005 Service Pack 4 recently and made it available at the end of last week.
A faster way to prepare dimensional databases
When you are obliged to create a dimensional database for an SSAS cube, how can you do it as fast as possible?
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
The Goldilocks problem – Materialized Views
I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but...
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
How We Handled a Vendor Retry That Loaded Twice in Snowflake
Comments posted to this topic are about the item How We Handled a Vendor...
Cognitive Coverage
Comments posted to this topic are about the item Cognitive Coverage
Question of the Day
Getting the Average
I have this data in the dbo.Commission table in a SQL Server 2022 database.
salesperson commission Brian 12 Brian 16 Andy 7 Andy 14 Andy 21 Steve 20 Steve NULLAll the data is a varchar, and I decide to run this query to get the totals for each salesperson.
SELECT SalesPerson
, AVG(TRY_PARSE(Commission AS int)) AS TotalCommission
FROM commission
GROUP BY SalesPerson
GO
What average commission is calculated for Steve? See possible answers