T-SQL Tuesday #18 – CTEs
To CTE or not to CTE, that is the Question
So my post really has nothing to do with the title....
2011-05-10
693 reads
Blog Posts
T-SQL Tuesday #18 – My CTE
It’s time for T-SQL Tuesday again, and it’s number 18. Hard to believe it’s been a year and a half...
2011-05-10
949 reads
Use ACE Drivers and PowerShell to Talk to Text Files
As a follow up to my SQLRally 2011 Scripting Guy Guest Blog Post which dealt with Excel and Access files,...
2011-05-10
2,341 reads
A quicker way than using count(*)
A quick little tip I found a couple of years ago. Ever use the count(*) syntax and it takes forever...
2011-05-09
564 reads
Minnesota SQL Server Study Group
Study Time!
A few weeks back, I sent a message on the PASSMN LinkedIn group page about expanding the MCM study...
2011-05-09
692 reads
PASSMN May Meeting
If you are going to be visiting Minnesota on May 17th or are there on more permanent basis, you can...
2011-05-09
637 reads
Pragmatic Tools Week: BIxPress
Much like Tim “The Toolman” Taylor had his themed weeks, we’re going to do something similar. This week we salute:...
2011-05-09
663 reads
Speaking at Colorado Springs SQL Server User’s Group on June 15
I will be speaking at the Colorado Springs SQL Server User’s Group, live and in person, on Wednesday, June 15,...
2011-05-09
516 reads
SQL Azure Migration Wizard
There’s a project over on code plex to come up with a mechanism for validating databases and generating the necessary...
2011-05-09
1,310 reads
Sql Saturday #83
Frikkie Bosch opened the day with a short keynote giving an overview of Denali, talking mostly from a marketing point...
2011-05-09
805 reads
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
ALAMAT BCA KCP Telepon Kota Telp:08218154393
WA:08218154393 Jl. Ps. Pagi Raya No.9, RT.2/RW.2, Roa Malaka, Kec. Tambora, Kota Jakarta Barat,...
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers