SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• How to configure sql server Agent?

  How to configure sql server Agent?

  RKGoriparthi

  4 replies

  15 years, 10 months ago

  By: Paul White

• what is the De-Normalization process?

  what is the De-Normalization process?

  RKGoriparthi

  7 replies

  15 years, 10 months ago

  By: Paul White

• what is sql scheduler?how e can use sql scheduler?

  what is sql scheduler?how e can use sql scheduler?

  RKGoriparthi

  5 replies

  15 years, 10 months ago

  By: Paul White

• Multiple Tables on same side of "On" clause

  Hello All, I have a query that uses 6 joins to produce a results set. It is in the form of: Select…

  lmeinke

  2 replies

  15 years, 10 months ago

  By: Paul White

• How to convert some Access SQL into TSQL?

  Hello I am trying to recreate a process that I had written in Access SQL into TSQL to speed up the …

  george.greiner

  15 replies

  15 years, 10 months ago

  By: george.greiner

• How to query two tables having composite primary key

  CREATE TABLE T1 (idno varchar(30) NOT NULL, seqno varchar(30) NOT NULL, Last_Name varchar(30), F…

  ragunaathan

  5 replies

  15 years, 10 months ago

  By: Dave Ballantyne

• what is the normalization of the database

  what is the normalization of the database

  RKGoriparthi

  1 replies

  15 years, 10 months ago

  By: Florian Reischl

• Advise on moving to SQL 2008

  Our data warehousing systems are currently running in SQL Server 2005 technologies. could you pleas…

  esnkumar

  1 replies

  15 years, 10 months ago

  By: Old McDonald

• SQL Server has encountered x occurrence(s) of I/O requests taking longer than 15 seconds

  I need some pointers to the following error that I'm seeing in the error log at random(occurs rough…

  SQLZ

  2 replies

  15 years, 10 months ago

  By: SQLZ

• T-SQL Performance Question

  Hi, Does anyone know if there is any difference in performance when you put your criteria with your…

  Vicki Peters

  3 replies

  15 years, 10 months ago

  By: Gail Shaw

• Preventing Table Locks: Are cursors a good idea?

  We are creating some new update scripts that will be run on a live database. The scripts will be ru…

  huston.dunlap

  7 replies

  15 years, 10 months ago

  By: Jeff Moden

• compare values between two tables

  I am using SQL 2005. I am trying to compare values between 2 tables. I have two tables like example…

  znkin

  2 replies

  15 years, 10 months ago

  By: GSquared

• Significance of using dbo in create statement

  Hi, I have one query,suppose I create a store procedure in sql 2005 using below statement : create …

  ruchi-761283

  5 replies

  15 years, 10 months ago

  By: mstjean

• SSMS Continously Locks up for short periods

  I'm hpoing this isn't just me. Is anyone else having a problem with SSMS locking up /freezing repe…

  YSLGuru

  9 replies

  15 years, 10 months ago

  By: SwePeso

• Protecting my DDL Trigger

  I have written a DDL trigger to log the changes in the database in a Logtable on a separate databae…

  Atif-ullah Sheikh

  2 replies

  15 years, 10 months ago

  By: Elliott Whitlow