Adventures in SQL CLR and C#
I’ve toyed with the CLR in SQL Sever 2005 off and on since the first Yukon beta had it enabled....
2009-10-09
2,852 reads
Select count(*)
Today I was reading(I always read Paul Randal).
http://www.sqlskills.com/BLOGS/PAUL/post/Which-index-will-SQL-Server-use-to-count-all-rows.aspx
I learned that whenever you query select count(*) it will select the the...
2009-10-09
1,957 reads
Performance Data Gathering
As a DBA, one of the things I struggled with was gathering all my important system information in one place,...
2009-10-09
795 reads
Next SQL Lunch - Deploying Report Builder 2.0 for Self-Service Reporting
Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=95MQQM&role=attend
Click Here to Add to Outlook Calendar
Click the above Meeting URL around 11:00 AM CST on 10/12/2009 to...
2009-10-09
640 reads
What I did on my vacation
I took a few days off recently to get a break from work. I've rarely taken time off since last...
2009-10-09
666 reads
Baton Rouge October SQL Server User Group
Last night I presented, Monitoring Disk Space using CLR, to the Baton Rouge Area SQL Server User Group. There were...
2009-10-09
738 reads
Final Plug for the Networking Seminar at the PASS Summit
If you’re attending the PASS Summit this year I hope you’ve decided to attend the two hour Networking to Build...
2009-10-08
578 reads
All Offices Should Have A View (Or At Least Windows)
Yesterday was a typical Florida afternoon, sudden down pour of rain, but not a storm. Just slow solid rain for...
2009-10-08
337 reads
SNESSUG September Meeting
We had a good night with 13 people attending. I ran unopposed for president of SNESSUG for my second, and...
2009-10-08
605 reads
PASS Log Reader Awards
Brent Ozar, Andy Warren and Jeremiah Peschka have put together a blogger award called the PASS Log Reader Award. I...
2009-10-08
731 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers