Over the last 30+ years of working with SQL Server, I have seen a lot of interview questions relating to SQL Server. I have been on both sides of the interview table, sometimes wondering what the person on the other side of the table was asking. As a SQL Server developer do you feel that you were asked good questions …
What is your favorite SQL Server Developer Interview questions? Read more »
Current Stedman Solutions SQL Course Coupon Codes. Save Up to 65% Off our Popular Online SQL Server Courses, a Once a Year Type Savings! 65% Off for April JOINs Month Coupon Code: APRIL-JOINS Leave your JOIN confusion in the past and enroll in our SQL Server JOIN Types Course. Learn More Here 50% Off Our Newest Course! Coupon Code: FEB-RELEASE50 …
When I first created this JOIN Types poster or cheat sheet back in 2013 I didn’t realize there was such a need for it. I originally made this as a tool to explain JOIN types to a fellow coworker. It seemed almost impossible teach JOIN without it. The inspiration to create this tool came from a little bit of frustration. …
Joining tables in SQL Server can be confusing and hinder your performance. I know because I have helped many confused people to understand their JOINs. That is why I created the JOIN Types cheat sheet several years ago, and the JOIN Types class last year. I have recently updated my poster to version 22. I have also made many blog …
Here is a quick CTE that can be used to generate all the dates in a range. This is handy to use when trying to find dates missing from a set, you can outer join to it, or union with it to fill in the blanks. Download my book for FREE when you sign up for my mailing list. Receive …
At Stedman Solutions, we do a lot of work with SQL Server replication, mostly transactional and merge replication. The other day I needed a query to show all the merge replication publication on a SQL Server, not just a single database, but to see it for all databases on the SQL Server. Here is the query that I came up …
One possible cause of the “Cannot resolve the collation conflict” error message is that your database collation doesn’t match the TempDB Collation. Recommendation It is recommended that the collation of your database match the collation TempDB. It is possible that if your collations do not match that you may get errors, or that queries using TempDB will not run correctly.If …
As part of documenting the craziness of this storm I have created a script that I run every 5 minutes that pushes data into a SQL Server database. Here is how it works, in the TSQL code I hit the PSE outage webservice url and pull the count of customer that are without power. I then insert it into a …
One of the feature differences between SQL Server Express Edition and the other paid versions is the ability to schedule jobs or tasks using the SQL Server Agent. Even if you are running SQL Server Express Edition, there is a need to run scheduled jobs. Things like: Backups Index and Statistics Maintenance Shrink DB (Just Kidding, don’t do that) A …
Using OSQL.EXE to run a scheduled task on SQL Server Express Edition Read more »
TL;DR summary: Don’t do it. Stop reading here if you want, but just don’t do it. This post refers to shrinking your database files (mdf, or ndf files), not shrinking the log file. The log file is a completely different conversation, however, shrink database does shrink the log file. Not shrinking your database is one of the more counter intuitive …
DBCC ShrinkDatabase – I want to shrink my database. Read more »