Upgrade or Wait
Lots of debate and disagreement on my recommendation to wait for SQL
Server 2008 instead of upgrading to SQL Server 2005...
2007-07-11
1,435 reads
Blog Posts
SQL Server 2008
Just when I was about to start a pool for the release date, Microsoft announced today it will release on...
2007-07-10
1,389 reads
The Business of Publishing
Despite my casual approach to the editorials and my job, this is still
something of a business and Red Gate wants...
2007-07-10
626 reads
CTEs and where have I been?
I haven't posted much lately, but it has been a busy few months with many family activities. At work, I...
2007-07-09
433 reads
DDL Triggers and CREATE_LOGIN/ALTER_LOGIN
I've been doing a lot with DDL triggers in the last week or so and pulling out the relevant information...
2007-07-09
1,103 reads
The Perils of NewID for Randomizing Results
NewID() is commonly used in the order by to return the result set in random fashion. No idea whether its...
2007-07-09
873 reads
Wiki For Books Online
Browsing MSDN this morning and saw the note that they now have Wiki support. If done well it could be...
2007-07-09
588 reads
Service Packs and Support
More coming next week in editorials and already a note on the site, but support for both SQL Server 2000...
2007-07-07
633 reads
Cursors to Increase Performance?
I recently had the chance to look over a friends shoulder at a query that needed some tuning work. In...
2007-07-06
704 reads
Latest Service Packs and Books Online
I was reading a new post at SQL Server Magazine titled The More Things Change(full version available to registered users...
2007-07-06
620 reads
Blogs
Microsoft Ignite Announcements Nov 2024
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
When is the perfect moment to build a data strategy in a company?
The post When is the perfect moment to build a data strategy in a...
Forums
Strange connections to SQL Server. Is the server compromised?
There is a server on which SQL Server 2022 is installed. Login [sa] is...
CHECKDB (TEMPDB FULL)
It's been donkeys years since this has happened to me, but I cannot remember...
clean up accounts
EXEC sp_validatelogins <- Can we use this as a start to identify accounts in...
Question of the Day
The Hash Join II
Which of these inputs is the smaller input to a hash join?
See possible answers