Understanding the Implications of ANSI SQL92 SET Options
Have you ever experienced a T-SQL query, a stored procedure, view or a trigger returning unexpected results. In this article by Raj Gill, he shows you how ANSI DEFAULTS may be to blame.
Have you ever experienced a T-SQL query, a stored procedure, view or a trigger returning unexpected results. In this article by Raj Gill, he shows you how ANSI DEFAULTS may be to blame.
Microsoft has announced a new certification for system administrators. This is below an MCSE, but includes an elective which may be SQL Server.
Alexander Chigrik presents a few UDFs he has developed for getting meta data about your database objects.
Running a script automatically from SQL Server is easier than you think. Here are a few methods you can use.
This article covers some of the common issues and questions when you cluster SQL Server 2000 and Windows 2000.
Total SQL Analyzer is a new product that can help document your SQL Server. This review examines the product and some of it's features.
The Web Data Administrator is a utility program implemented in ASP.NET that enables you to easily manage your SQL data, wherever you are.
“Could you help me, we deleted the database’s transaction log file and now that...
I had a couple of clients who were moving content from development catalogs to...
I wanted to test a migration of Azure PostgreSQL from simple to flexible. I...
Comments posted to this topic are about the item Diving Deeper into the Import...
Hi all, I need a list of objects (DMV's and probably other objects) that...
Recently I got sql alerts from one of QA servers, every 2 or 3...
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers