The Scary DBA

Blog Post

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,732 reads

Blog Post

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,517 reads

Blog Post

Proof

SQL Rockstar tells me that unless there are photo’s, it didn’t happen. Brad McGehee published some pictures from DevConnections. See,...

2009-11-17

608 reads

Blogs

How Long Will It Take to Learn SQL? The Truth Might Surprise You

By

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

I leave tonight for Australia. I was in London 3 days ago, so this...

Dealing with Change – Two Resources

By

As I look at the state of information technology today, I see one constant:...

Read the latest Blogs

Forums

CDC Custom Alert

By Abdul122

Hi All,   I am writing an alert in a sql agent job, basically...

How to use a scalar function in INSERT stmt?

By mjdemaris

Hello all, I would like to create an INSERT statement and use a UDF...

Initial Config of tempdb

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Initial Config of tempdb

Visit the forum

Question of the Day

Initial Config of tempdb

What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?

See possible answers