Questions in topic: sql-server - SQL Server Q&A from the SQL Server Central community

Questions in topic: sql-server

votes

answers

views

When writing scripts should I be putting the schema and square brackets all the time?

Feb 12 '10 at 07:09 AM Ian Roke 1.7k

t-sql sql-server best-practice

votes

answers

5.2k

views

The ‘Call Log’ SQL Problem

Feb 09 '10 at 10:54 AM Peso 1.6k

t-sql sql-server challenge puzzle speed-phreak

votes

answers

883

views

Feature request

Feb 01 '10 at 11:51 AM Håkan Winther 15k

sql-server feature-request

votes

answers

1.3k

views

Redirect named instance to default instance on same box

Jan 27 '10 at 12:14 PM James Moore 178

sql-server

votes

answers

586

views

Faster way to add a sql server instance

Jan 27 '10 at 05:06 AM bonskijr 174

sql-server installation server-instances

-2

votes

answers

265

views

How do i create database links?

Jan 25 '10 at 09:37 AM bongers 4

sql-server

votes

answers

685

views

After restoring, do i need to take a backup?

Jan 12 '10 at 10:03 AM Alan Featherston Lago 97

sql-server backup restore

votes

answers

1.3k

views

Opening Database properties in SSMS fails with lock

Dec 08 '09 at 11:59 AM sp_lock 8.1k

sql-server ssms locking

votes

answers

views

Consolidated list of schedules used by SQL Server Agent

Dec 07 '09 at 08:02 AM Kev Riley ♦♦ 46.1k

sql-server ssms sql-agent schedule

votes

answers

652

views

SQL Server relevant clip arts and icon files

Nov 30 '09 at 01:35 AM Mansour Shoari 435

sql-server

votes

answers

2.7k

views

get biweekly startdate and enddate from one date

Nov 26 '09 at 06:29 AM Arsalan Godil 11

t-sql query sql-server date-functions

votes

answers

1.5k

views

SQL Update using variables

Nov 20 '09 at 01:59 PM Melvyn Harbour 1 ♦♦ 1.4k

sql-server vb

votes

answers

22.4k

views

The ‘FIFO Stock Inventory’ SQL Problem

Nov 14 '09 at 01:55 PM Peso 1.6k

t-sql sql-server puzzle speed-phreak competition

votes

answers

1.4k

views

Is there an easy way to remove all default values for a SQL database?

Nov 07 '09 at 09:22 AM mattruma 21

sql-server script

votes

answers

1.3k

views

SQL Server Auditing Stored Procedure

Nov 07 '09 at 09:08 AM Kev Riley ♦♦ 46.1k

sql-server

votes

answers

285

views

Where can I find a full list of the possible values of SQLCODE?

Nov 05 '09 at 07:42 AM Steve Casey 23

sql-server

votes

answers

884

views

Index Tuning Wizard Fills Application Log With Error Messages

Oct 29 '09 at 12:53 PM onedozenbagels 11

sql-server-2000 sql-server indexing

votes

answers

views

SQL Server query help

Oct 29 '09 at 11:46 AM Kev Riley ♦♦ 46.1k

query sql-server

votes

answers

7.2k

views

Error: Each GROUP BY expression must contain at least one column that is not an outer reference

Oct 28 '09 at 01:48 PM Matt Whitfield ♦♦ 29.2k

sql-server

votes

answers

2.1k

views

Count of distinct values by column

Oct 28 '09 at 12:54 PM James Moore 178

t-sql sql-server

votes

answers

671

views

SQL Server 2005 SP3 at times becomes unresponsive

Oct 27 '09 at 07:47 PM Jan 21

sql-server

votes

answers

1.2k

views

Does a SQL Server Scripts Project work for database development?

Oct 26 '09 at 07:11 PM Steve Jones - Editor ♦♦ 5.1k

sql-server ssms developer project

votes

answers

570

views

Finding out why an install failed?

Oct 26 '09 at 10:44 AM Steve Jones - Editor ♦♦ 5.1k

sql-server installation

votes

answers

2.2k

views

What reference book should every DBA/Dev have?

Oct 25 '09 at 01:37 AM Rob Farley 5.7k

t-sql sql-server subjective documentation

votes

answers

1.1k

views

Index Fill Factor

Oct 23 '09 at 04:11 PM NYSystemsAnalyst 312

sql-server indexing

votes

answers

18.8k

views

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

Oct 23 '09 at 03:23 PM Grant Fritchey ♦♦ 62.4k

stored-procedures sql-server administration cache procedure-cache

votes

answers

1.3k

views

Can I detach a filegroup?

Oct 23 '09 at 02:19 PM Steve Jones - Editor ♦♦ 5.1k

sql-server administration filegroup

votes

answers

2.9k

views

Rights for SQL Server Service Account

Oct 23 '09 at 09:53 AM Steve Jones - Editor ♦♦ 5.1k

sql-server service-account

votes

answers

4.3k

views

Copying database under a different name in MSSQL

Oct 23 '09 at 06:51 AM Henno 21

sql-server-2005 sql-server database

votes

answers

8.6k

views

SSIS SMTP Connection Manager

Oct 23 '09 at 05:34 AM Melvyn Harbour 1 ♦♦ 1.4k

ssis sql-server smtp

votes

answers

11.3k

views

Login failed: Server is in script upgrade mode

Oct 22 '09 at 02:50 PM Raj More 1.7k

sql-server

votes

answers

1.5k

views

Patching instances of SQL Server 2005

Oct 22 '09 at 02:20 PM Steve Jones - Editor ♦♦ 5.1k

sql-server-2005 sql-server service-pack patching

votes

answers

2.8k

views

When is the next version of SQL Server due?

Oct 22 '09 at 01:16 PM Melvyn Harbour 1 ♦♦ 1.4k

sql-server-2005 sql-server-2008 sql-server-2008-r2 sql-server

votes

answers

717

views

Which are the best Microsoft exams to take for a SQL professional?

Oct 22 '09 at 01:15 PM Melvyn Harbour 1 ♦♦ 1.4k

sql-server certification

votes

answers

1.3k

views

Using dot in naming databases in SQL

Oct 22 '09 at 10:38 AM Mansour Shoari 435

sql-server

votes

answers

1.5k

views

What SQL Server subsystems are instance aware?

Oct 22 '09 at 06:47 AM Melvyn Harbour 1 ♦♦ 1.4k

sql-server-2005 sql-server-2008 sql-server

votes

answers

10.5k

views

How do you read / understand an execution plan?

Oct 22 '09 at 05:54 AM Melvyn Harbour 1 ♦♦ 1.4k

sql-server ssms execution-plan profiler

votes

answers

views

Can I turn off logging?

Oct 21 '09 at 05:30 PM Steve Jones - Editor ♦♦ 5.1k

sql-server transaction-log

votes

answers

3.6k

views

What is rollforward when a SQL Server restarts?

Oct 21 '09 at 01:39 PM Steve Jones - Editor ♦♦ 5.1k

sql-server backup recovery

votes

answers

2.2k

views

Enable Dedicated Administrator Connection

Oct 21 '09 at 01:27 PM Steve Jones - Editor ♦♦ 5.1k

sql-server security dac

votes

answers

1.4k

views

Restoring a set of transaction logs

Oct 21 '09 at 12:33 PM Mike 21

sql-server restore transaction-log

votes

answers

2.1k

views

Limited number of concurrent queries

Oct 21 '09 at 10:35 AM Melvyn Harbour 1 ♦♦ 1.4k

sql-server msde

votes

answers

3.5k

views

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

Oct 21 '09 at 09:13 AM Melvyn Harbour 1 ♦♦ 1.4k

t-sql sql-server

votes

answers

1.2k

views

What is the maximum amount of RAM I can use?

Oct 20 '09 at 04:04 PM Steve Jones - Editor ♦♦ 5.1k

sql-server memory

votes

answers

1.2k

views

The Suggested Shopping List Problem...

Oct 20 '09 at 03:55 PM Gustavo 592

t-sql sql-server performance transaction

votes

answers

1.8k

views

Query XML using a cursor style approach

Oct 20 '09 at 12:30 PM thatismatt ♦♦ 210

sql-server xml

votes

answers

1.7k

views

Description value in table designer

Oct 20 '09 at 11:40 AM Melvyn Harbour 1 ♦♦ 1.4k

sql-server ssms table-designer

votes

answers

3.1k

views

What does the Net Address in Activity Monitor represent?

Oct 20 '09 at 11:00 AM Melvyn Harbour 1 ♦♦ 1.4k

sql-server ssms activity-monitor net-address

votes

answers

views

Powershell Register Servers - How do I add a connection property?

Oct 20 '09 at 06:03 AM Melvyn Harbour 1 ♦♦ 1.4k

sql-server powershell programming

votes

answers

792

views

SQL Express Licencing

Oct 19 '09 at 05:58 PM Kev Riley ♦♦ 46.1k

sql-server licensing

272 questions

766answers

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Tags