Re-size TempDB files
Managing TempDB can be a bit tricky at times. Most people know how to increase the size, but what about reducing it? New author Amar Pogaku brings us two techniques for shrinking tempdb.
2009-04-03
29,717 reads
Articles
Congratulations to Grant Fritchey
He was awarded MVP status today, no joke, for his work in the community. According to his blog , it’s not a joke. And it shouldn’t be. Between the excellent book he wrote on execution plans, his work for PASS, and regular contributions on SQLServerCentral.
2009-04-03
1,377 reads
SQL Server UDF to convert integer date to datetime format
This short tip shows how you can convert an integer date, such as those stored in msdb to a real datetime value.
2009-04-03
3,612 reads
Troubleshooting
New author Mike Walsh brings us an interesting analogy on troubleshooting skills that might get you to think differently about how you attack problems.
2009-04-02
6,333 reads
Automatic Full Parallel Processing of Hierarchical SQL Queries
Although adding multiprocessing capabilities to applications is labor-intensive and error-prone, adding multicore capability to SQL query processing can be automatic, benefiting huge numbers of applications with little developer effort.
2009-04-02
2,311 reads
Service Broker Poison Message Handling
Recent installments of our series dedicated to SQL Server 2005 Express Edition have focused on error handling techniques that leverage Service Broker's transactional nature. This article describes Poison Message detection characteristics and presents an example demonstrating its use.
2009-04-02
1,585 reads
The T-SQL Paradigm
This Friday, Steve Jones looks for opinions on what you think of the T-SQL language. Is it well structured or does it really need help?
2009-04-02
566 reads
The T-SQL Paradigm
This Friday, Steve Jones looks for opinions on what you think of the T-SQL language. Is it well structured or does it really need help?
2009-04-02
560 reads
The T-SQL Paradigm
This Friday, Steve Jones looks for opinions on what you think of the T-SQL language. Is it well structured or does it really need help?
2009-04-02
875 reads
2009-04-01
5,233 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers