SQL Server Needs Tempdb
I saw a post recently where someone noted they had moved tempdb like this:
USE master;
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = tempdev,...
2013-07-15
1,202 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
The Desktop
Steve Jones talks about laptops and desktop machines, and the potential issues that IT professionals have with one or the other.
2013-07-15
140 reads
2013-07-15
183 reads
The Vacation Struggle
It can be hard to take all your time off each year and Steve Jones is in that situation right now. However he reminds us that life is more important than work.
2013-07-12
150 reads
Two Weeks until SQL Saturday #222 in Sacramento
It’s just two weeks until my next trip. It feels like I just got back from London, and one again...
2013-07-12
987 reads
2013-07-12
2,320 reads
Test Your Restores
Test your restores: he first tip in my Hard Earned Lessons of a DBA piece.
I can’t emphasize this enough. I’ve...
2013-07-11
833 reads
Programming
Programming is an important skill, perhaps extremely important for the future. Steve Jones thinks that's true.
2013-07-10
307 reads
Reporting on Data
Reporting is an important skill for many data professionals. Steve Jones has a few things you might consider working on as a data professional.
2013-07-09
268 reads
T-SQL Tuesday #44–Second Chances
It’s T-SQL Tuesday time again. This is the monthly blog party, started by Adam Machanic. If you’d like to participate,...
2013-07-09
1,082 reads
Blogs
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
Forums
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers