comp.databases.ms-sqlserver

The best way to use the Database Engine Tuning Advisor

Started on 27 September 2007 17:58
Last reply by Tommy Hayes on 02 Oktober 2007 13:07
[ Posts: 4 ] [ Views: 289 ]

strategies for paging

Started on 28 September 2007 12:12
Last reply by Nick Chan on 02 Oktober 2007 07:23
[ Posts: 4 ] [ Views: 325 ]

The Two Standards of the Sql CTE

Started on 02 Oktober 2007 04:04
Last reply by Rog11228 on 02 Oktober 2007 04:04
[ Posts: 0 ] [ Views: 322 ]

Do you know what the Sql CTE really is?

Started on 02 Oktober 2007 04:01
Last reply by Rog11228 on 02 Oktober 2007 04:01
[ Posts: 0 ] [ Views: 279 ]

web database question

Started on 01 Oktober 2007 08:21
Last reply by Erland Sommarskog on 01 Oktober 2007 23:55
[ Posts: 2 ] [ Views: 285 ]

Simple recovery model affect performance?

Started on 01 Oktober 2007 19:03
Last reply by Erland Sommarskog on 01 Oktober 2007 23:44
[ Posts: 1 ] [ Views: 340 ]

How Do I give EXECUTE Permissions on Stored Procedures?

Started on 20 September 2007 16:14
Last reply by Erland Sommarskog on 01 Oktober 2007 23:40
[ Posts: 7 ] [ Views: 750 ]

Reports of users

Started on 01 Oktober 2007 18:32
Last reply by zach on 01 Oktober 2007 18:32
[ Posts: 0 ] [ Views: 284 ]

Database Security

Started on 01 Oktober 2007 17:02
Last reply by tatata9999 on 01 Oktober 2007 17:02
[ Posts: 0 ] [ Views: 281 ]

Alternate to cursors

Started on 01 Oktober 2007 09:12
Last reply by Roy Harvey on 01 Oktober 2007 16:55
[ Posts: 1 ] [ Views: 279 ]

Problem accessing remote sql server

Started on 30 September 2007 21:00
Last reply by Erland Sommarskog on 01 Oktober 2007 09:20
[ Posts: 8 ] [ Views: 431 ]

replication

Started on 29 September 2007 19:38
Last reply by aleu on 01 Oktober 2007 02:44
[ Posts: 4 ] [ Views: 313 ]

Apparent DB engine bug in SQL Server 2005

Started on 01 September 2007 01:03
Last reply by Erland Sommarskog on 29 September 2007 18:13
[ Posts: 13 ] [ Views: 468 ]

dumb question

Started on 29 September 2007 02:43
Last reply by Tony Rogerson on 29 September 2007 11:20
[ Posts: 2 ] [ Views: 314 ]

find unique identifier through multiple tables

Started on 22 September 2007 11:34
Last reply by hugues.morel on 29 September 2007 09:13
[ Posts: 7 ] [ Views: 385 ]

Select Into across Linked Servers

Started on 27 September 2007 17:38
Last reply by Erland Sommarskog on 28 September 2007 23:43
[ Posts: 1 ] [ Views: 1640 ]

Network Packet Size

Started on 27 September 2007 17:57
Last reply by Erland Sommarskog on 28 September 2007 23:35
[ Posts: 1 ] [ Views: 409 ]

Partition Optimization

Started on 13 September 2007 20:56
Last reply by Erland Sommarskog on 28 September 2007 23:05
[ Posts: 5 ] [ Views: 619 ]

Users Logged In

Started on 28 September 2007 18:25
Last reply by RogueIT on 28 September 2007 20:52
[ Posts: 3 ] [ Views: 321 ]

Comparing two tables

Started on 28 September 2007 15:28
Last reply by JJ297 on 28 September 2007 18:13
[ Posts: 3 ] [ Views: 324 ]

I want to return a string to a wrapper from a subordinate stored procedure

Started on 27 September 2007 21:36
Last reply by BobC on 28 September 2007 16:56
[ Posts: 3 ] [ Views: 294 ]

nt authority\system?

Started on 28 September 2007 16:45
Last reply by Louis on 28 September 2007 16:45
[ Posts: 0 ] [ Views: 294 ]

TDS and character encoding

Started on 30 August 2007 16:25
Last reply by Roy Harvey on 28 September 2007 15:34
[ Posts: 30 ] [ Views: 612 ]

isqlw won't start

Started on 27 September 2007 12:32
Last reply by Erland Sommarskog on 27 September 2007 23:48
[ Posts: 2 ] [ Views: 297 ]

Set default schema in code - possible?

Started on 27 September 2007 15:44
Last reply by Erland Sommarskog on 27 September 2007 23:46
[ Posts: 1 ] [ Views: 262 ]

a small SQL Puzzle

Started on 26 September 2007 20:37
Last reply by Fiori on 27 September 2007 08:06
[ Posts: 2 ] [ Views: 322 ]

How do I view table information such as constraints?

Started on 19 September 2007 10:40
Last reply by ben_cameron00 on 26 September 2007 10:43
[ Posts: 2 ] [ Views: 281 ]

Moving DB from one drive to another

Started on 25 September 2007 01:04
Last reply by giorgi.piero on 26 September 2007 02:16
[ Posts: 9 ] [ Views: 393 ]

Clustered index on the identity column or a datetime column

Started on 25 September 2007 15:57
Last reply by Gert-Jan Strik on 25 September 2007 23:17
[ Posts: 3 ] [ Views: 1871 ]

SQL Query from Access to SQL Server

Started on 25 September 2007 12:00
Last reply by Erland Sommarskog on 25 September 2007 23:00
[ Posts: 1 ] [ Views: 306 ]

autoincrement question sql 2005 server

Started on 25 September 2007 15:06
Last reply by Erland Sommarskog on 25 September 2007 22:56
[ Posts: 2 ] [ Views: 340 ]

Is it worth partitioning?

Started on 25 September 2007 12:37
Last reply by giorgi.piero on 25 September 2007 19:41
[ Posts: 3 ] [ Views: 283 ]

BIRT + Yellowfin + ANN mashup make Advanced Business Intelligence

Started on 25 September 2007 13:35
Last reply by YellowFin on 25 September 2007 13:35
[ Posts: 0 ] [ Views: 295 ]

Retrieve ONLY first/max

Started on 18 September 2007 06:03
Last reply by mark on 25 September 2007 09:17
[ Posts: 8 ] [ Views: 2014 ]

PHP code to Stored Procedure

Started on 22 September 2007 08:57
Last reply by Dan Guzman on 25 September 2007 03:43
[ Posts: 4 ] [ Views: 2149 ]

SET NO_BROWSETABLE ON ?

Started on 29 August 2007 16:19
Last reply by Erland Sommarskog on 25 September 2007 00:19
[ Posts: 10 ] [ Views: 1749 ]

Comparing databases

Started on 18 September 2007 23:25
Last reply by dvdtknsn on 24 September 2007 21:41
[ Posts: 4 ] [ Views: 318 ]

Would you like to have access contents about .net totally free?

Started on 24 September 2007 20:04
Last reply by jeff on 24 September 2007 20:04
[ Posts: 0 ] [ Views: 481 ]

subtraction of different precision values

Started on 24 September 2007 19:17
Last reply by Roy Harvey on 24 September 2007 19:50
[ Posts: 2 ] [ Views: 287 ]

ANN: Database Workbench 3.0 released

Started on 24 September 2007 15:38
Last reply by Martijn Tonies on 24 September 2007 15:38
[ Posts: 0 ] [ Views: 253 ]