Vote for Mr. LaRock
It is rapidly coming up on election time at the Professional Association of SQL Server users (PASS). Once more, a person...
2009-09-29
1,563 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
Recap of Cape Cod .NET User’s Group
I presented last night at the Cape Cod .NET User’s Group. What a great bunch of people. About 20 people...
2009-09-24
709 reads
PASS Virtual Chapters
If you’re not a member of the Professional Association of SQL Server users, PASS, why not? No, I’m sorry. I...
2009-09-23
847 reads
Presentation Skills from Brent Ozar
If you present at any level, read this. If you’re thinking about presenting, read this. If you’d like to start...
2009-09-23
1,070 reads
Cape Cod .NET Users Group
Tomorrow night, Wednesday, September 23, I’m going to present on “Best Practices for Working with SQL Server Execution Plans” for the...
2009-09-22
835 reads
Gila Monster on Estimated vs. Actual Row Counts
I don’t generally do lots of blog aggregation and cross post linking & stuff. It’s just not something I’m that into....
2009-09-22
1,265 reads
Identifying Frequently Running Queries
It’s not enough to look at the longest running query. What if you have two queries, one runs for 5...
2009-09-21
951 reads
More Free Training
Quest Connect 2009, taking place in October 21 for 24 hours, looks like it’s going to have 64 different sessions, live...
2009-09-15
691 reads
No Join Predicate
You could be looking at an execution plan on a query and see this message: Warning, No Join Predicate. With...
2009-09-15
3,079 reads
Don't Build a Monitoring System
Should you buy or build a monitoring system for your SQL Server? Todays' guest editorial from Grant Fritchey talks about the resistance to recommendations that many people seem to have.
2009-09-14
907 reads
Blogs
A New Word: Ghough
By Steve Jones
ghough – n. a hollow place in your psyche that can never be filled;...
T-SQL Tuesday: Encryption and Data Protection
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Parameterize your Databricks notebooks with widgets
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
Forums
Need help on query within 2 column, generate another column
Hi, This is my table and data CREATE TABLE [dbo].[rpt_AR_StatementOfAcct_100]( [Id] [int] IDENTITY(1,1) NOT...
SELECT blocking DML and DDL
Hi All. I am seeing a scenario where SELECT is blocking a TRUNCATE statement...
query filling up tempdb
Hi All, Need some help in tune a function which is reading TB's of...
Ask SSC