If, before deployment, you need to push the limits of your disk subsystem in order to determine whether the hardware’s I/O capacity meets the needs of a database application, if you need performance baselines, or if you want to identify any performance-related issues, then why not use the sqlio utility?
Do you know how often to back up your SQL Server transaction log? Steve Jones has a few thoughts today and notes that you definitely need to know how to restore the log backups.
With the new SQL Server 2014 In-Memory OLTP tables, stored procedures can be natively compiled and can improve performance. Read on to learn more.
Microsoft published a vision for their data platform and SQL Server recently. Steve Jones has a few thoughts on what this means for you. Hint: it's cloudy.
The 'Structured' part of SQL denotes the fact that queries can be nested inside each other in such a way that, wherever you can use a table, you can use a table expression. Such derived tables can provide powerful magic, to which is added CTEs and Lateral Tables.
SQL Server MVP Steve Jones will be hosting a free seminar in San Jose on Friday March 7 2014. Join fellow database professionals to learn best practices and practical tips for SQL Server version control, continuous integration and deployment.
We've made a change to the forums at SQLServerCentral. Learn how you can mark a post as an answer to your question and help others.
We've all been there, trying to improve performance in a panic situation and not making things better.
Not long ago, a crack team of SQL Server experts was flamed for a crime against database normalization they didn't commit. Today, Joe Deebeeay had a problem, no one else could help, so he found these exiled experts. Together Joe and the DBA-Team get to the bottom of high disk I/O.
In this piece, Josh follows up on his earlier article about smoothing DBA/Developer interactions, this time from the side of the developers.
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Ruko Grand Sudirman, Jl. P.B. Sudirman Blok C5-C6, Dauh Puri Klod, Kec. Denpasar Bar.,...
Call CSO; (+62 821°3111°179 Jl. Pesanggrahan Jl. Puri Kencana No.28 29, RT.2/RW.7, Kembangan Sel.,...
Jl. K.H. Wahid Hasyim No.183 A-B, Kb. Kacang, Kecamatan Tanah Abang, Kota Jakarta Pusat,...
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers