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
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
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
852 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,071 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,267 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
952 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,108 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
927 reads
Editorial on SQL Server Central
My first one over there. It’s discussing whether or not you should do two things, build your own monitoring tool,...
2009-09-14
807 reads
Blogs
How Long Will It Take to Learn SQL? The Truth Might Surprise You
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
Flying Halfway Around the World to Australia
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
Dealing with Change – Two Resources
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Forums
Pivot query
Hi, I have the following table: CREATE TABLE [dbo].[UnitProdFinal]( [YearMonth] [int] NULL, [SerialNumber] [varchar](50)...
Table with FK(s) to other columns within the table
Hello All, I have recently joined a project, where main, core tables with millions...
Question of the Day
Using Table Hints in a Query
How many table hints can I include in a query?
See possible answers