What’s Using Space in Tempdb?
It happens, not often, but I do regularly see people talking about their tempdb growing too large. Often that means...
2009-11-30
14,996 reads
When it rains…
It pours.
I come back from 4 days unwired, a bunch of writing done, to a laptop that’s head, a site...
2009-11-30
1,427 reads
SQL Server XQuery For Idiots
I’m still struggling with learning XQuery. My latest little revelation was small, but vital.
The difference between:
@inXML.nodes('/rss/channel/item')and
@inXML.nodes('/rss[1]/channel[1]/item')Is the difference between a...
2009-11-30
1,563 reads
XQuery For Idiots
I’m still struggling with learning XQuery. My latest little revelation was small, but vital.
The difference between:
@inXML.nodes('/rss/channel/item')and
@inXML.nodes('/rss[1]/channel[1]/item')Is the difference between a...
2009-11-30
1,760 reads
TechNet WebCast: SQL Server Locking & Blocking
Next Monday, I’m presenting a TechNet WebCast for Microsoft Thrive Live! The subject: SQL Server Locking & Blocking Made Simple. Here...
2009-11-30
1,510 reads
My first useful powershell script – capturing performance counters
After playing around with powershell a bit, I managed to do something quite useful. There are a multitude of ways...
2009-11-30
1,784 reads
Unwired
I didn’t have Internet access for 4 days while we were in the mountains. Actually I could have purchased it,...
2009-11-30
1,469 reads
Maintaining Security and Performance Using Stored Procedures Part II – Signing
Well, it has been a couple of weeks since my last blog post and over a month since Maintaining Security...
2009-11-30
1,662 reads
SQL Saturday Dallas – Registration and Call for Speakers is Open!
I’m happy to announce that SQL Saturday Dallas is officially scheduled, and the registration and call for speakers is open. ...
2009-11-30
1,563 reads
OT: Maximizing My Time, Using Technology
Well I've taken the plunge. I have finally broken down and decided to dictate blog post, articles, and other documents....
2009-11-30
1,573 reads
Blogs
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCU JOMBANG Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
Layanan BCA KCP Pemalang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Jend. Sudirman No.6, Mulyoharjo, Kec. Pemalang, Kabupaten Pemalang, Jawa Tengah 52313
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers