Oracle 12.1.0.2 can throw an ORA-01438 when importing an interval partitioned table. In this post, David Fitzjarrell suggests a work-around until Oracle patches the bug.
2015-12-25
3,295 reads
SQL Server Data Tools (SSDT) provides, via the DacPac, interesting support for verifying not only those references within the database, but also those to other databases even if they are on other servers. Although it is adds an extra level of complexity to deployments, it can increase the probability that deployments will succeed without errors due to broken references or binding errors. Ed Elliot investigates.
2015-12-24
5,389 reads
Sometimes the stress of interdepartmental friction withing organisations, can get on top of you, especially between the business and IT when the going gets tough. Simple-Talk's answer is a board game to put it all into perspective. Instead of getting carried away, play the board game instead and reach catharsis.
2015-12-24
3,352 reads
The Power BI desktop designer contains a rich set of advanced mathematical functions. In this article, John Miner shows how you can combine these functions together in a computed column to solve numerical business problems.
2015-12-23
3,924 reads
Enterprise Edition customers enjoy the manageability and performance benefits offered by table partitioning, but this feature is not available in Standard Edition. Aaron Bertrand explains his idea for achieving at least some of partitioning's upsides on any edition.
2015-12-22
4,341 reads
The Data-lake is basically a large repository of data for 'big data' analytic workloads, held in its original format. The Azure Data Lake adds Data Lake Analytics, and Azure HDInsight. Although the tools are there for Big Data Analysis, it will require new skills to use, and a heightened attention to Data Governance if it is to appeal to the average enterprise. Rob Sheldon takes a look.
2015-12-21
3,485 reads
Cursors are considered by many to be the bane of good T-SQL. What are the best ways to avoid iterative T-SQL and to write queries that look and perform beautifully? This first part in an ongoing series of cursor-killing handles inter-row analysis.
2015-12-18 (first published: 2014-05-27)
22,685 reads
You make an example database, like NorthWind or WidgetDev in order to test out your deployment system and the next thing you know you're worrying about constraints, backup and security. Then you add an index to the production system and feel a pang of guilt. What would the Devs say? Somehow databases take on lives of their own, populated by the lost souls of users, Developers and DBAs. Has the Redgate DLM Team's practice Forex database somehow come alive?
2015-12-18
3,479 reads
Execute these stored procedures to backup all your database daily and your transaction logs several time daily. Save space by using the overwrite feature.
2015-12-17
5,158 reads
Aaron Bertrand takes a look at the changes in store for In-Memory OLTP (the feature formerly known as "Hekaton").
2015-12-17
5,473 reads
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Jl. Ir. H. Juanda 3 No.34, Kb. Klp., Kecamatan Gambir, Kota Jakarta Pusat, Daerah...
Jl. Kramat Jaya Raya No.10 Blok F1, Semper Bar., Kec. Cilincing, Jkt Utara, Daerah...
Jl. Mangga Dua Square lantai LG Blk. A No.144, RT.11/RW.6, Kota Tua, Ancol, Kec....
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