Recent MS SQL Server Articles

Sort by:

Date Title Author
05/04/12

SQL Server Compression - Pros and Cons

 sqlxl
04/20/12

How to upgrade a MSSQL database from one version to another

 dbaduck
02/05/12

New Functions in SQL Server 2012 (Denali) - 1

 PatelAlpesh
11/20/11

Schedule MS SQL Backups via GUI With SQL Express

 gwickert
11/15/11

Execute SQL Job with Proxy

 PatelAlpesh
02/03/12

Auditing in SQL server

 PatelAlpesh
09/29/11

SQL Search Procedures and Jobs

 ltorres321
01/21/12

Database Copying Wizardry

 mwvisa1
10/19/11

A SQL Tidbit: What week is it?

 mwvisa1
05/09/11

Moving system databases: sqlserverAgent fail to start: Error 435

 mordi
04/21/11

Advantage of using char over varchar data type

 s_niladri
10/19/11

How to allow ODBC to connect to SQL via and external IP

 Bilbo3D
03/14/11

Partition A table using Computed column

 ashilo
01/27/11

MICROSOFT SQL SERVER REBUILD/REORG ALL INDEXES ON ALL DATAB…

 hollecar
05/20/12

Calculating Special Means in Microsoft SQL Server Part 2: Geometric Mea…

 matthewspatrick
05/20/12

Calculating Special Means in Microsoft SQL Server Part 1: Weighted Aver…

 matthewspatrick
06/18/11

Can Foreign key improve performance?

 s_niladri
10/19/11

Disaster Recovery - Replicate databases to Recovery & NoRecovery Mod…

 JagdishDevaku
11/24/10

SQL 2000 SP4 timeout error 1460

 pbcconsulting
01/24/11

Resolving blocking conflicts in SQL Server in user-friendly manner

 vadimrapp1
12/22/10

deleting duplicate records in a database without a primary key

 Ravindra_Gautam
11/04/10

SQL 101 - String Manipulation Functions

 Shannon_Lowder
09/16/10

SQL 101 - Calculated Fields

 Shannon_Lowder
02/03/11

SQL 101 - The Advanced LIKE Clauses

 Shannon_Lowder
09/16/10

SQL 101 – SELECT, Filtering Results (Part 2)

 Shannon_Lowder
11/04/10

SQL 101 - SELECT, Filtering Results

 Shannon_Lowder
10/19/11

SQL 101 - SELECT

 Shannon_Lowder
10/23/11

Writing SQL Server Triggers Part 1:  After Triggers

 chapmandew
11/04/10

SQL Orphaned Username Fix

 supportJunkie
10/19/11

Retrieving Data From Excel Using OPENROWSET()

 ValentinoV
10/19/11

SQL 101 - What is a Database

 Shannon_Lowder
11/04/10

Quickly Disconnect Users From a Database

 Shannon_Lowder
09/16/10

String Manipulation -- CAST and CONVERT

 Shannon_Lowder
11/04/10

String Manipulation -- REPLACE, PATINDEX and Regular Expressions

 Shannon_Lowder
10/19/11

String Manipulation -- REPLACE

 Shannon_Lowder
12/20/10

String Manipulation -- SUBSTRING

 Shannon_Lowder
01/11/12

SQL Server: Table Joins Explained!

 chapmandew
10/19/11

The Difference Between Truncation and Deletion in Microsoft SQL Server

 chapmandew
11/17/10

(MS SQL 2005+) T-SQL Techniques: Logical BOM Explosion

 mwvisa1
12/30/10

Speeding up SQL server, more is less

 pnauta
10/19/11

Is there the best way to find a sub-tree in a self-referencing table?

 lof
10/19/11

How to duplicate a Master-Detail structure using Merge

 lof
05/06/12

Connect to your SQL Server

 angelIII
12/11/10

SQL server Storage system, Selecting the appropriate RAID level

 sysdba
11/04/10

SQL - Formatting a time (or DateDiff) as hours + mins + secs, etc...

 alainbryden
10/19/11

DST Utilities Table Creation : Using occurrence of a weekday practically!

 mwvisa1
03/14/12

Broaden Your Horizons : Pivot Again!

 mwvisa1
06/24/11

Speedier Execution of Stored Procedures in SQL Server

 Bobaran98
06/27/11

Fun with MS SQL spt_values for delimited strings and virtual calendars

 mark_wills
10/19/11

Converting Active Directory Timestamps in Microsoft SQL Server

 mwvisa1
05/16/12

Managing Fragmentation for the Accidental DBA

 mark_wills
10/08/10

DateSerial Function for Microsoft SQL Server

 mwvisa1
11/04/10

TimeSerial Function for Microsoft SQL Server

 mwvisa1
02/24/12

Pivot Rolling Periods Without Using Dynamic T-SQL

 mwvisa1
10/19/11

Server Side Trace/Profiling Scripts

 vinurajr
11/04/10

Finding stored procedures, tables, columns, constraints, etc., from …

 JagdishDevaku
03/31/12

Grant Execute On SQL Objects

 VMontalvao
01/14/12

Comparing SQL Query Optimisations : Fair and consistent benchmarking

 adathelad
Loading Advertisement...

Top MS SQL Server Experts

  1. jogos

    239,998

    Guru

    0 points yesterday

    Profile
    Rank: Sage

  2. acperkins

    235,949

    Guru

    0 points yesterday

    Profile
    Rank: Genius

  3. lcohan

    183,490

    Guru

    0 points yesterday

    Profile
    Rank: Genius

  4. anujnb

    176,525

    Guru

    0 points yesterday

    Profile
    Rank: Wizard

  5. ScottPletcher

    145,505

    Master

    1,920 points yesterday

    Profile
    Rank: Genius

  6. ValentinoV

    121,329

    Master

    0 points yesterday

    Profile
    Rank: Genius

  7. matthewspatrick

    119,432

    Master

    9,080 points yesterday

    Profile
    Rank: Savant

  8. EugeneZ

    115,990

    Master

    0 points yesterday

    Profile
    Rank: Genius

  9. TempDBA

    107,409

    Master

    1,400 points yesterday

    Profile
    Rank: Sage

  10. angelIII

    100,133

    Master

    0 points yesterday

    Profile
    Rank: Elite

  11. HainKurt

    93,046

    Master

    0 points yesterday

    Profile
    Rank: Genius

  12. mwvisa1

    88,475

    Master

    30 points yesterday

    Profile
    Rank: Genius

  13. dtodd

    88,114

    Master

    0 points yesterday

    Profile
    Rank: Genius

  14. huslayer

    80,892

    Master

    0 points yesterday

    Profile
    Rank: Sage

  15. BCUNNEY

    71,606

    Master

    0 points yesterday

    Profile
    Rank: Guru

  16. ralmada

    69,983

    Master

    0 points yesterday

    Profile
    Rank: Genius

  17. dqmq

    66,272

    Master

    0 points yesterday

    Profile
    Rank: Genius

  18. rajeevnandanmishra

    56,446

    Master

    0 points yesterday

    Profile
    Rank: Master

  19. CodeCruiser

    55,120

    Master

    0 points yesterday

    Profile
    Rank: Genius

  20. dbaduck

    53,688

    Master

    2,810 points yesterday

    Profile
    Rank: Sage

  21. Qlemo

    50,598

    Master

    0 points yesterday

    Profile
    Rank: Genius

  22. Cluskitt

    50,080

    Master

    0 points yesterday

    Profile
    Rank: Wizard

  23. sdstuber

    48,336

    0 points yesterday

    Profile
    Rank: Genius

  24. mark_wills

    47,244

    0 points yesterday

    Profile
    Rank: Genius

  25. ryanmccauley

    44,552

    0 points yesterday

    Profile
    Rank: Sage

Hall Of Fame