See performance gains by using indexed views in SQL Server Your email has been sent A view is a saved T-SQL query in SQL Server. The view definition is stored by SQL Server so that it can be used as a ...

The beauty and joy of a relational database is the concept of relational closure—everything is a table. Beyond the eponymous table, query results are also “tables.” Any query serves as a table to be ...

I've been playing around with the new Microsoft service, currently in preview and it's time to show off what it can do. Have you ever struggled with a database performance problem or ever struggled to ...

When I am working with an Oracle database, I still find myself using SQL*Plus for many quick and dirty database queries. In particular, I often look up constraints in SQL*Plus. In this post, I look at ...

OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...