t-sql
INDEX ON partition_scheme_name, filegroup_name, and default
Consider the CREATE INDEX statement below: CREATE INDEX ix_tableName_columnName ON tableName (columnName) ON { partitionSchemeName (columnName) | fileGroupName
sql202
sql202
SET IDENTITY_INSERT
Let's say you have the following table on two servers, one in development and one in production. CREATE TABLE person ( personID INT IDENTITY(1,1) , firstName
sql202
Disabling Constraints
Constraints are great for maintaining the integrity of the data in your database. I'm not a big fan of running your database without them. It just opens up the
dev
SQL 202 – FILLFACTOR and Indexes
FILLFACTOR specifies the percentage for how full the Database Engine should make the leaf level of each index page during index creation or rebuild. FILLFACTOR
microsoft sql
NULL Values, Blank Values, and Table Design
Have you dealt with NULL yet? A field is referred to as NULL if it has not received a value. To specify the NULL-ability of a column using T-SQL, just add
microsoft sql
Comparing Query Performance
A significant portion of your time as a database programmer or administrator will be to improve the performance of queries. While there are several benchmarks
sql
A Better sp_who2
If you've ever needed to work with sp_who2 to figure out what's going on, then you know it would be nice to be able to sort the results, right? Well, if you use
dba
Incomplete Tables
One of the things I’ve noticed while performance tuning is many of the tables in my current environment are incomplete. They all have columns defined, and
t-sql
Quickly Disconnect Users From a Database
Disconnect All Users of a Database There comes a time in every DBA's life when he or she has many users connected to a database that needs to be detached, placed in single user mode, or simply refreshed. The problem is they keep reconnecting more quickly than you can KILL them off. This is especiall