SQLServerCentral Article

SQL Server 2000 Table Hints

As you advance in your skills as a Transact-SQL developer or SQL Server database administrator there will come a time when you need to override SQL Server's locking scheme and force a particular range of locks on a table. This article by Randy Dyess shows you how to optimize your queries using table hints.

Technical Article

DBA Certification – Is It for You?

"Certification mania" has hit IT, big-time. Many employers look for certification in potential employees and especially in IT contractors. If you're a data administrator or DBA, you have to consider: could DBA certification enhance my career? Would it deepen my knowledge and increase my value to my company?

SQLServerCentral Article

Auditing Your SQL Server Environment Part I

Ever been placed into a new environment and couldn't
find an ounce of documentation? This article is the first in a series that will help you make an audit of your new environment
and determine if any SQL Server login does not have a password, has a password the same as the login name or a password that is only one character long.

Blogs

Using ThinOptics to Read Data

By

As I’ve aged, I find myself struggling to read many things in my life....

PostgreSQL Events – A Newbies Perspective: #PGSQLPhriday 014

By

For this month’s #PGSQLPhriday 014 blogging event, Pavlo Golub has asked a pretty simple...

Set-Based vs Row-Based Database Code

By

In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles...

Read the latest Blogs

Forums

Reduction of installation time of sql server 2008 R2 Express

By IT researcher

The installation of SQL Server 2008 R2 Express on a virtual machine takes around...

Creating Aggregates

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating Aggregates

Getting Started with DDL statements of Cassandra Query Language

By Shivayan Mukherjee

Comments posted to this topic are about the item Getting Started with DDL statements...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers