Making Databases Personal
If you can use a database to create automation routines to help sustain your work life, you can certainly do the same to sustain your personal life. Databases are...
2019-04-09
5 reads
Making Databases Personal
If you can use a database to create automation routines to help sustain your work life, you can certainly do the same to sustain your personal life. Databases are...
2019-04-09
131 reads
T-SQL Tuesday #113 – What Do I Use MY Databases For?
This month’s T-SQL Tuesday blog is brought to us by Todd Kleinhans (b | t) and this month topic is about what you use databases in your personal life. ...
2019-04-09
7 reads
T-SQL Tuesday #113 – What Do I Use MY Databases For?
This month’s T-SQL Tuesday blog is brought to us by Todd Kleinhans (b | t) and this month topic is about what you use databases in your personal life. ...
2019-04-09
3 reads
T-SQL Tuesday #113 – What Do I Use MY Databases For?
This month’s T-SQL Tuesday blog is brought to us by Todd Kleinhans (b | t) and this month topic is about what you use databases in your personally life. ...
2019-04-09
25 reads
Writing Crossword puzzles with a database: T-SQL Tuesday #113
Todd Kleinhans (b/t) is host for T-SQL Tuesday this month and wants us to talk about how we use databases ... Continue reading
2019-04-19 (first published: 2019-04-09)
502 reads
Data Type Precedence and Implicit Conversions
SQL Server needs to make sure data types match when performing operations that involve multiple pieces of data. When the data types do not match, SQL Server has to...
2019-04-22 (first published: 2019-04-09)
705 reads
Data Type Precedence and Implicit Conversions
Watch this week's video on YouTube
SQL Server needs to make sure data types match when performing operations that involve multiple pieces of data.
When the data types do not match,...
2019-04-09
21 reads
Data Type Precedence and Implicit Conversions
Watch this week's video on YouTube
SQL Server needs to make sure data types match when performing operations that involve multiple pieces of data.
When the data types do not match,...
2019-04-09
11 reads
T-SQL Tuesday #113–Personal Databases
This month we have a really interesting question for the T-SQL Tuesday invitation. Todd Kleinhans is the host and asks about personal databases. Do we use them for anything?...
2019-04-09
50 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
Forums
Alamat Kantor BCA KCU Bekasi Telp:08217555651
Hub Via Wa:628217555651 Alamat Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel.,...
Partitioning a table with TEXTIMAGE_ON option
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Question of the Day
The Range of Customers
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers