Is it time for SQL Server to have Isolated Transactions?
SQL Server allows nesting of Transactions –in a sense. In truth, there is only one Transaction, with each ‘nested transaction’...
2009-03-10
776 reads
SQLSequel
MVP Summit 2009 -A Most Excellent Adventure
For many of us, one of the high points of being an MVP is attending the annual MVP Summit hosted...
2009-03-07
402 reads
You HAVE to Trust, you MUST Verify -and that may still not be enough!
In Brian Kelly's recent blog post, he makes an excellent case outlining why there are few options but to 'Trust' SQL...
2009-02-20
409 reads
What’s in a Name?
Why do folks continue to use outdated and unnecessary naming conventions? Specifically, the ridiculous ‘tbl’ prefix on tables, and the...
2008-10-23
1,377 reads
When Do You Know That You Know
Why, when you can help others, that's when!
In my role as a senior Moderator with the MSDN SQL Forums, I am often...
2008-10-17
443 reads
Through the Looking Glass: Elegant -or Not?
SQL Server as an EAV Database -Good Idea?
It seems like I am getting more and more inquires from potential clients...
2008-10-03
366 reads
Blogs
Daily Coping 12 Aug 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
My Toolbox - Greenshot
By Zikato
Foreword A picture is worth a thousand words. I use screenshots daily, whether it’s to...
Daily Coping 11 Aug 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
SSMS: Remove highlight in current cell of grid output
I'm trying to capture some screen shots of query results for documentation. I'd like...
Need to rollup some rows to columns
Hello, thanks in advance for any help. I have a query like this: select...
A way to make this dynamic SQL
Team: Is there an easy way to squeez this sql statement to a...
Ask SSC