comp.databases.ms-sqlserver

Slow Execution Performance

Started on 25 Oktober 2007 04:36
Last reply by Erland Sommarskog on 02 November 2007 23:08
[ Posts: 13 ] [ Views: 392 ]

Millions of Delete Statements

Started on 31 Oktober 2007 23:08
Last reply by Joe Celko on 02 November 2007 17:49
[ Posts: 6 ] [ Views: 304 ]

SQL query question.

Started on 01 November 2007 07:03
Last reply by danny on 02 November 2007 05:57
[ Posts: 4 ] [ Views: 275 ]

get some rows into one column

Started on 30 Oktober 2007 19:08
Last reply by Hugo Kornelis on 01 November 2007 23:28
[ Posts: 10 ] [ Views: 385 ]

Help with SQL query?

Started on 31 Oktober 2007 21:08
Last reply by melissa820 on 01 November 2007 14:19
[ Posts: 4 ] [ Views: 266 ]

I am trying to install and config MySQL ... if there is a FAQ I will read ...

Started on 01 November 2007 05:11
Last reply by mooregr_deleteth1s on 01 November 2007 12:14
[ Posts: 1 ] [ Views: 288 ]

CLR Assembly redeploy problem.

Started on 31 Oktober 2007 10:02
Last reply by Erland Sommarskog on 01 November 2007 09:24
[ Posts: 3 ] [ Views: 361 ]

How to run a query file

Started on 01 November 2007 01:02
Last reply by Roy Harvey on 01 November 2007 02:56
[ Posts: 3 ] [ Views: 288 ]

System Center Data Protection Manager

Started on 01 November 2007 01:20
Last reply by serge on 01 November 2007 01:20
[ Posts: 0 ] [ Views: 264 ]

some error in table definition

Started on 30 Oktober 2007 11:35
Last reply by Erland Sommarskog on 31 Oktober 2007 23:45
[ Posts: 10 ] [ Views: 306 ]

Error message on using union statement with order by using reserved words

Started on 30 Oktober 2007 11:08
Last reply by Joe Celko on 31 Oktober 2007 15:07
[ Posts: 3 ] [ Views: 277 ]

Error message in DTS

Started on 29 Oktober 2007 12:24
Last reply by David Greenberg on 31 Oktober 2007 08:36
[ Posts: 1 ] [ Views: 311 ]

Create Index

Started on 31 Oktober 2007 07:08
Last reply by Jackie Silva on 31 Oktober 2007 07:08
[ Posts: 0 ] [ Views: 284 ]

Open SQL 2005 database question

Started on 30 Oktober 2007 00:05
Last reply by Charlie on 30 Oktober 2007 16:21
[ Posts: 3 ] [ Views: 262 ]

SqlClient connection to SQL 2005 creates 5000 tcp connections!

Started on 30 Oktober 2007 16:07
Last reply by John Rivers on 30 Oktober 2007 16:07
[ Posts: 0 ] [ Views: 279 ]

CONTAINS and wildcard

Started on 29 Oktober 2007 21:59
Last reply by Sharif Islam on 30 Oktober 2007 15:07
[ Posts: 2 ] [ Views: 270 ]

Error message with stored procedure

Started on 29 Oktober 2007 18:50
Last reply by JJ297 on 30 Oktober 2007 12:44
[ Posts: 5 ] [ Views: 308 ]

Problem In SQL Server 2005 Replication On Port 2433

Started on 30 Oktober 2007 09:42
Last reply by shgzs33 on 30 Oktober 2007 09:42
[ Posts: 0 ] [ Views: 313 ]

Two Tables with Left Outer Join & Where Clause

Started on 29 Oktober 2007 07:44
Last reply by pbassutti on 30 Oktober 2007 01:44
[ Posts: 3 ] [ Views: 339 ]

pass Column Name using Parameter in SQL Statement...

Started on 19 Oktober 2007 07:37
Last reply by Tony Rogerson on 28 Oktober 2007 09:18
[ Posts: 5 ] [ Views: 910 ]

Can some explain this to me?

Started on 25 Oktober 2007 13:27
Last reply by Joe Celko on 27 Oktober 2007 02:36
[ Posts: 2 ] [ Views: 265 ]

ODBC Failed [Microsoft][ODBC SQL ...NamedPipes]ConnectionWrite (WrapperWrite()).

Started on 26 Oktober 2007 20:18
Last reply by Erland Sommarskog on 26 Oktober 2007 23:39
[ Posts: 1 ] [ Views: 1893 ]

Get value from query to update another another table

Started on 26 Oktober 2007 22:04
Last reply by Erland Sommarskog on 26 Oktober 2007 23:35
[ Posts: 1 ] [ Views: 331 ]

Uploading image type using TSQL

Started on 26 Oktober 2007 22:12
Last reply by Erland Sommarskog on 26 Oktober 2007 23:34
[ Posts: 1 ] [ Views: 534 ]

SQL Server 2005 SP2 update 2 rollup Performance tank

Started on 25 Oktober 2007 22:23
Last reply by Erland Sommarskog on 26 Oktober 2007 23:28
[ Posts: 3 ] [ Views: 969 ]

Weird speed problem

Started on 25 Oktober 2007 07:13
Last reply by Erland Sommarskog on 26 Oktober 2007 23:12
[ Posts: 7 ] [ Views: 300 ]

MCDBA - SQL Server 2005 Certification?

Started on 25 Oktober 2007 17:46
Last reply by Tom Brown on 26 Oktober 2007 13:05
[ Posts: 1 ] [ Views: 531 ]

design Index problem

Started on 22 Oktober 2007 10:38
Last reply by Erland Sommarskog on 25 Oktober 2007 23:14
[ Posts: 6 ] [ Views: 365 ]

Wrong result Set when using NoLock

Started on 22 Oktober 2007 09:52
Last reply by Erland Sommarskog on 25 Oktober 2007 23:09
[ Posts: 5 ] [ Views: 349 ]

Large Addition to Database

Started on 22 Oktober 2007 03:25
Last reply by DM McGowan II on 25 Oktober 2007 06:49
[ Posts: 9 ] [ Views: 513 ]

Deleting all data

Started on 26 Juli 2007 21:01
Last reply by Joe Hurzeler on 25 Oktober 2007 03:02
[ Posts: 3 ] [ Views: 324 ]

Cannot connect to SQL instance without port information

Started on 06 Juli 2007 00:02
Last reply by Joe Hurzeler on 25 Oktober 2007 01:02
[ Posts: 2 ] [ Views: 347 ]

Access 97/SQL 2000 Problem

Started on 24 Oktober 2007 17:01
Last reply by Pachydermitis on 24 Oktober 2007 23:48
[ Posts: 3 ] [ Views: 558 ]

Multiple rows combined into onerow and onecolumn separated by a special character

Started on 19 Oktober 2007 22:22
Last reply by Erland Sommarskog on 24 Oktober 2007 23:27
[ Posts: 3 ] [ Views: 538 ]

Subquery with invalid column name runs

Started on 24 Oktober 2007 16:42
Last reply by Joe Celko on 24 Oktober 2007 22:46
[ Posts: 5 ] [ Views: 713 ]

Need help Joining tables

Started on 24 Oktober 2007 17:42
Last reply by JJ297 on 24 Oktober 2007 19:24
[ Posts: 4 ] [ Views: 317 ]

find rows within seconds of top of hour

Started on 24 Oktober 2007 15:06
Last reply by Roy Harvey on 24 Oktober 2007 17:15
[ Posts: 1 ] [ Views: 277 ]

Reusing a generated column to avoid over processing

Started on 22 Oktober 2007 15:06
Last reply by Roy Harvey on 24 Oktober 2007 15:24
[ Posts: 2 ] [ Views: 301 ]

view

Started on 22 Oktober 2007 14:26
Last reply by Roy Harvey on 24 Oktober 2007 15:19
[ Posts: 3 ] [ Views: 400 ]

Min() query - 5th level optimization

Started on 23 Oktober 2007 16:05
Last reply by Erland Sommarskog on 23 Oktober 2007 23:40
[ Posts: 1 ] [ Views: 248 ]