Partitioning Gotcha
Well, it got me at least! Not long ago someone asked me about partitioned views and as I'm apt to...
2008-04-08
415 reads
SQL Server 2008 Management Studio
I made the decision today to start using SQL Server 2008 Management Studio at work to manage my 2000 and...
2008-04-08
815 reads
Thoughts on Database Mail
I suspect few would argue that database mail in SQL 2005 is a huge improvement over the mail system in...
2008-04-07
307 reads
Heroes Happen Here Charlotte, NC Launch Tomorrow (April 8, 2008)
The Heroes Happen Here launch event for Charlotte, NC is tomorrow. It looks like there are still registration slots open:
Heroes...
2008-04-07
1,010 reads
Link: April Fools Joke on Jonathan Schwarz of Sun
Absolutely worth watching.
http://blogs.sun.com/jonathan/entry/the_video
2008-04-07
518 reads
SQL Compare 7 Beta
Red Gate's schema comparison tool, SQL Compare, is in beta for the newest version, SQL Compare 7. You can find...
2008-04-07
1,202 reads
After Event Party Location Announced for SQLSaturday#3 in Jacksonville
From the SQLSaturday event site:
AFTER EVENT PARTY ANNOUNCED! Our after event party will be held at 7 Bridges Grille beginning...
2008-04-07
575 reads
A Note on sp_updatestats
In SQL 2000 when you run sp_updatestats it's the equivalent of running UPDATE STATISTICS on each table, forcing the update...
2008-04-06
417 reads
SQL Server Forensics Book
I logged into Safari today to download some chapters I want to be able to review when I'm offline. I...
2008-04-05
1,269 reads
Jacksonville SQLSaturday less than a month away!
The SQLSaturday in Jacksonville, Florida, will be held May 3, 2008. I'm on track now to give two security based...
2008-04-05
535 reads
Blogs
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers