You've just become responsible for a database, only to find that the log file is growing out of control. Why is it happening and what do you do to correct it?
2013-04-30
5,146 reads
Learn about a simple way to run uniform tasks in parallel using self-deleting jobs.
2013-04-29
7,334 reads
2013-04-29
2,238 reads
Marcin Policht explores some of PowerShell's SSIS-specific automation capabilities by demonstrating the process of configuring an already deployed package in order to carry out a parameterized package execution.
2013-04-29
2,381 reads
Check and foreign key constraint do not degrade performance but actually improve it.
2013-04-26 (first published: 2010-10-21)
26,736 reads
SQL Relay is an annual community-run series of SQL Server training events across the UK. SQL Relay will run 8, 1-day conferences over the course of 2 weeks starting June 17th. Speakers from Microsoft, global IT companies, and a host of MVPs, are covering topics on DBA, business intelligence, and development.
2013-04-26
3,302 reads
Starting with SQL Server 2005, developers have had recursion available as a T-SQL language feature. This article describes recursion and its SQL Server implementations, complete with examples. It also includes SQL Server functions and a stored procedure that unpacks, or parses, an integer into its multiple-of-two components.
2013-04-26
3,186 reads
Ever need to automatically stop a long running job? Ever need to find which named Schedule is the currently running version of your job? There's simple code that'll let you find out.
2013-04-25
6,141 reads
What should you do if your first, most intuitive solution to a problem ends up scanning the data more than is necessary, resulting in poor performance? Have you missed a new SQL Server feature that can remove inefficiency from your technique? Alternatively, do you need a little help, and some lateral thinking, to open the path to a different approach? Sometimes, the answer is "both".
2013-04-25
6,949 reads
SQL Monitor comes with plenty of metrics, but there are always going to be things that you want to measure that can't be done 'out of the box'. Taking database mirroring as an example, Grant shows that custom metrics can be used to monitor and alert whatever aspect of SQL Server or database that you need.
2013-04-24
2,948 reads
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...
Jl. Transyogi Cileungsi-Cibubur. 3-4 RT 002/003, Cileungsi, Kec. Cileungsi, Kabupaten Bogor, DKI Jakarta 16820
Jl. Raya Bandung - Garut No.KM 21, RW.5, Mekargalih, Kec. Jatinangor, Kabupaten Bandung, Jawa...
Jl. Raya Laswi No.212 A, Majalaya, Kec. Majalaya, Kabupaten Bandung, Jawa Barat 40382
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