SQL Server HAVING clause on SELECT statements
The SQL HAVING clause is used in conjunction with the GROUP BY clause to filter the results of a query based on the group by… Read More »SQL Server HAVING clause on SELECT statements
SQL Server
Christmas Queries
Here is a sample Christmas-themed query for SQL Server: This query returns the greeting “Merry Christmas!” and the current date. It only selects user tables… Read More »Christmas Queries
Merry Christmas! 2022-12-25 00:00:00.000
Merry Christmas! 2022-12-25 00:00:00.000 This output shows that the query is only returning user tables with an even object ID and the date is December… Read More »Merry Christmas! 2022-12-25 00:00:00.000
Locking and Blocking
In SQL Server, locking and blocking are mechanisms that are used to protect data integrity and consistency by controlling access to data by concurrent transactions.… Read More »Locking and Blocking
What is your naming convention?
I am looking for feedback on your naming conventions for a couple areas relating to naming convention. As Stedman Solutions consultants we work for several… Read More »What is your naming convention?
SQL Server Design and Development Services
One of the services we do a ton of is our Design and Development Service. This involves anything from writing custom TSQL procedures to website… Read More »SQL Server Design and Development Services
SQL Server Mentoring – Do you need a little help?
Sometimes we all need a little help without a long term commitment. That why we created our SQL Server Mentoring service at Stedman Solutions. SQL… Read More »SQL Server Mentoring – Do you need a little help?
SQL Server Worries Survey
Every DBA, owner or CEO etc. have worries regarding their SQL Server. We face challenges everyday with constant evolving business and technology needs. We at… Read More »SQL Server Worries Survey
SQL Server Memory Limits
When working on different client servers, we often times get asked, why all their memory is not being used, and often times we are hitting… Read More »SQL Server Memory Limits
Determining the last time your SQL Server instance was restarted
The following query will show the last time your SQL Server instance was started. I used this just today for planning purposes for doing SQL… Read More »Determining the last time your SQL Server instance was restarted