Ask SqlServerCentral - SQL Server Q&A from the SQL Server Central community

0

votes

0

answers

421

views

Transitioning Crystal formulas/variables to SQL statement

Mar 16 '10 at 11:42 AM BonAboard 11

t-sql select

2

votes

3

answers

2.2k

views

Startup Options to Tune A Data Warehouse

Mar 16 '10 at 10:03 AM Blackhawk-17 10.5k

sql-server-2008 data-warehouse 64-bit startup-options trace-flags

0

votes

3

answers

413

views

IS My Query Affecting Performance?

Mar 16 '10 at 09:45 AM graz ♦ 525

performance joins

0

votes

0

answers

273

views

MSDE 1 TO MSDE 2000 UPGRADE

Mar 16 '10 at 09:30 AM Trutter 1

sql-server-2000 upgrade

3

votes

1

answers

1.8k

views

Replication and indexes

Mar 16 '10 at 07:55 AM Steinar 1.7k

sql-server-2005 sql-server-2008 replication indexing

6

votes

4

answers

2.5k

views

Permutations in T-SQL

Mar 16 '10 at 05:14 AM Matt Whitfield ♦♦ 29.2k

t-sql challenge set-based

1

votes

3

answers

1k

views

nested trigger problem

Mar 16 '10 at 04:13 AM Matt Whitfield ♦♦ 29.2k

trigger

0

votes

1

answers

687

views

delete from audithis where datediff(day, dateadd(second, sttotal, '1/1/1970'), getdate()) > 30

Mar 16 '10 at 03:30 AM Shashwati Saha 1

sql-server-2000 query

0

votes

1

answers

271

views

sales and customer table question

Mar 16 '10 at 02:43 AM SA 1

sql-server-2008

4

votes

2

answers

1.5k

views

Best practices to ensure query results data correctness

Mar 15 '10 at 06:48 PM 4efe27c0 85

reporting data

1

votes

3

answers

2.2k

views

How to replace Not Exists in query.

Mar 15 '10 at 06:03 PM Bhaskar 333

t-sql

2

votes

7

answers

8.1k

views

Why does Sql Server recommends creating an index when it already exist?

Mar 15 '10 at 05:09 PM Pierre-Alain Vigeant 25

sql-server-2008 indexing query-analyzer

0

votes

1

answers

697

views

Single quote or apostrophe saving problem

Mar 15 '10 at 04:53 PM Ade 1

sql-server-2000

1

votes

1

answers

1.2k

views

Mirror - High Protection

Mar 15 '10 at 04:29 PM Felipe 262

database-mirroring

4

votes

2

answers

2.9k

views

Can you use a CTE inside a transaction block?

Mar 15 '10 at 04:24 PM Slick84 1.3k

transaction cte

1

votes

1

answers

404

views

Is SQL 2008 Express installed wth SQL 2008 Developer?

Mar 15 '10 at 04:23 PM Rod 801

sql-server-2008 sql-server-express

1

votes

3

answers

6.8k

views

Is it possible to use MAX in update statement?

Mar 15 '10 at 01:29 PM Slick84 1.3k

t-sql

2

votes

2

answers

3.8k

views

How do you stop a sql server 2005 database from restoring?

Mar 15 '10 at 01:02 PM Mike 3 23

restore

1

votes

1

answers

1.3k

views

Totals across a rows columns and potentialy multiple rows

Mar 15 '10 at 11:19 AM Pavel Pawlowski 20.3k

sql-server-2005 t-sql sql-server-2000 totals

3

votes

1

answers

1.1k

views

SQLDeveloper Not Handling Virtual Column

Mar 15 '10 at 10:52 AM Leigh Riffel 154

developer ddl

2

votes

5

answers

461

views

Table level Backup

Mar 15 '10 at 09:56 AM Venkat 1 31

backup

0

votes

2

answers

656

views

SQL question on duplicate records - HELP! - THANKS!!

Mar 15 '10 at 09:39 AM graz ♦ 525

delete-duplicates

0

votes

4

answers

664

views

moving data values from text file to database

Mar 15 '10 at 09:36 AM graz ♦ 525

sql-server-2008 bulk-insert

0

votes

1

answers

241

views

in sql: how do i convert a string to an int and filter on the result. I get Conversion failed

Mar 15 '10 at 09:34 AM graz ♦ 525

sql-server-2005

0

votes

1

answers

1.8k

views

error 9001: tempdb log is not available

Mar 15 '10 at 09:33 AM graz ♦ 525

sql-server-2000 dbcc temporary-tables

0

votes

1

answers

1.4k

views

Sql Transaction Has completed;its is no longer usable.

Mar 15 '10 at 09:31 AM graz ♦ 525

sql-server-2000 transaction error-handling

1

votes

2

answers

582

views

SQL Server 2008 on 64bit Windows Server

Mar 15 '10 at 07:45 AM MC_DW 11

sql-server-2008 sql

0

votes

1

answers

357

views

Stored procedures and parameters

Mar 15 '10 at 07:05 AM Fatherjack ♦♦ 38.8k

stored-procedures closed

0

votes

2

answers

1.7k

views

Where excatly we can use cursor in T-SQL programming??

Mar 15 '10 at 07:04 AM Fatherjack ♦♦ 38.8k

t-sql closed

0

votes

0

answers

1.2k

views

Encrypt/decrypt all the columns in the table.

Mar 15 '10 at 07:03 AM Fatherjack ♦♦ 38.8k

encryption closed

Transitioning Crystal formulas/variables to SQL statement

Startup Options to Tune A Data Warehouse

IS My Query Affecting Performance?

MSDE 1 TO MSDE 2000 UPGRADE

Replication and indexes

Permutations in T-SQL

nested trigger problem

delete from audithis where datediff(day, dateadd(second, sttotal, '1/1/1970'), getdate()) > 30

sales and customer table question

Best practices to ensure query results data correctness

How to replace Not Exists in query.

Why does Sql Server recommends creating an index when it already exist?

Single quote or apostrophe saving problem

Mirror - High Protection

Can you use a CTE inside a transaction block?

Is SQL 2008 Express installed wth SQL 2008 Developer?

Is it possible to use MAX in update statement?

How do you stop a sql server 2005 database from restoring?

Totals across a rows columns and potentialy multiple rows

SQLDeveloper Not Handling Virtual Column

Table level Backup

SQL question on duplicate records - HELP! - THANKS!!

moving data values from text file to database

in sql: how do i convert a string to an int and filter on the result. I get Conversion failed

error 9001: tempdb log is not available

Sql Transaction Has completed;its is no longer usable.

SQL Server 2008 on 64bit Windows Server

Stored procedures and parameters

Where excatly we can use cursor in T-SQL programming??

Encrypt/decrypt all the columns in the table.

Recent tags

Recent Badges