May 2010 S3OLV Meeting Recap
On the evening of May 13th, S3OLV held its monthly meeting. We had some really good discussion, and got to...
2010-05-14
688 reads
Jason Brimhall
Exceptional DBA
It is once again that time of year. It is time to nominate the DBA in your life for the...
2010-05-11
921 reads
May UG Meeting
This is just a quick note to remind any interested parties that the May S3OLV meeting will be held this...
2010-05-11
463 reads
T-SQL Tuesday #006: A Blobbing We Will Go
Once again it looks like I was early for the T-SQL Tuesday event. Last month I submitted my entry on...
2010-05-11
872 reads
SQL 2005 TableSpace
In the first post of this series I highlighted and described two stored procedures that are shipped from Microsoft. These...
2010-05-05
4,682 reads
Table Sizes
In SQL Server there are two stored procedures that help one to determine the size of a table. One is...
2010-05-03
856 reads
Marathon Schedule
Finally I am putting down to paper my marathon race list for this season. Some of my favorite races are...
2010-04-30
1,473 reads
BLOB Index Columns
For the April T-SQL Tuesday, I blogged about a report to find information on the BLOBs in a database. I...
2010-04-27
1,215 reads
Index Stats Duplication
I came across a recent posting about seeing multiple entries in sys.dm_db_index_usage_stats for the same index. This kind of behavior...
2010-04-22
2,052 reads
SQL 2008 R2
Really short post here. I just found out that Stacia Misner (blog |blog 2 | @StaciaMisner) and Ross Mistry have released...
2010-04-21
562 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Compare rows within the same table
I have a table. Structure in script below. I have to compare and see...
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers