Sql-server

How do you create a non clustered index?

Sep 28, '12 t-sql·sql-server·database·indexing

Kev Riley commented

how to select Bottom( N) rows in a table through single query.

Jan 24, '13 t-sql·sql-server

jason_clark03 answered

What is the basic difference between clustered and a non-clustered index?

May 10, '16 sql-server·indexes

DaveC edited

Can I tell when a stored procedure was last executed or who executed it?

May 15, '18 sql-server·stored-procedures·administration·cache·procedure-cache

WalterMeester answered

The ‘FIFO Stock Inventory’ SQL Problem Wiki

Feb 27, '15 t-sql·sql-server·puzzle·speed-phreak·competition

KenJ commented

Set a database to read-only mode in SQL

Mar 4, '13 sql-server

Is WHILE loop better than CURSOR?

Nov 23, '12 sql-server·tsql

thatismatt edited

Should my primary key be clustered?

Oct 15, '09 sql-server·ssms·indexing·database-design·primary-key

Melvyn Harbour 1 edited

How to select records with LETTERS in an nvarchar field that should only be numbers?

Oct 21, '09 t-sql·sql-server

DaveC edited

Obtaining the Number of working days in a month

May 16, '18 t-sql·sql-server·calendar

bpodfw answered

SQL user without a login or WITHOUT LOGIN

Aug 28, '14 sql-server·security·login

Ian Roke asked

What are the pros and cons of using a temporary dates table instead of a permanent one?

Feb 19, '10 t-sql·sql-server·cte·recursion

scoan answered

The 'Subscription List' SQL Problem Wiki

Dec 26, '14 t-sql·sql-server·puzzle·speed-phreak·competition

Melvyn Harbour 1 edited

SSIS SMTP Connection Manager

Oct 23, '09 ssis·sql-server·smtp

Melvyn Harbour 1 edited

ODBC Connection string to SQL database stopped working

Oct 19, '09 sql-server·odbc·connection-string