SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Transactional Replication - pick up where left off?

  Hi All, Can anybody offer any advice please? We currently have two SQL instances running on one ser…

  fail.gary

  2 replies

  14 years ago

  By: fail.gary

• Pivot Table Query

  [font="Arial"]Hi guys. I'm brand new to this forum, and for the most part SQL queries. I have bee…

  haleswd

  3 replies

  14 years ago

  By: haleswd

• case statement

  select case when Void = 0 then SUM(weight) end AS totalweight from test when i use this i get resu…

  ranuganti

  1 replies

  14 years ago

  By: Kingston Dhasian

• Before installing SQL Server Developer Edition....?

  Before installing SQL Server Developer Edition on your home PC for the first time, is there anythin…

  lee-hardman

  2 replies

  14 years ago

  By: lee-hardman

• Table-based Functions vs. Views

  This is a quasi-programming question as that is the "why" I'm doing what I'm doing ... but the root…

  Putts

  57 replies

  14 years ago

  By: DiverKas

• Beginner learning, Advise needed - SQL?

  Hi, I am looking to begin a career in SQL, basically i have been working as a business analyst now …

  lee-hardman

  5 replies

  14 years ago

  By: lee-hardman

• Sp_Helptext not working properly

  What is difference between "Sp_Helptext" and "generating script using right click on stored procedu…

  panwar.jt

  4 replies

  14 years ago

  By: MVDBA (Mike Vessey)

• Upgrade a procedure

  Hi i wanted to know if is good to write a procedure like this one CREATE PROCEDURE dbo.MAJStatutDo…

  marclas

  3 replies

  14 years ago

  By: Eugene Elutin

• MSDB Restore

  Hi All I have backed up MSDB and restored it onto another server The builds are exactly the same an…

  SQLSACT

  6 replies

  14 years ago

  By: Pradyothana Shastry

• How to check the columns within the table?

  Hi Friends, I have column names called ID Prefix StreetName StreetType IntPrefix IntStre…

  Charmer

  5 replies

  14 years ago

  By: Charmer

• cant create logins in SQL

  Hey, I have an sql instance created for myself where i am the admin. For some reason i am unable to…

  soniaj

  11 replies

  14 years ago

  By: Perry Whittle

• Difference between seek and scan?

  Hi, what are the major differences between seek and scan in sql server?

  SriSudha

  5 replies

  14 years ago

  By: Koen Verbeeck

• Any way to find last table updated inforamtion

  Hi, Any way to find last table updated inforamtion. I think, we can use triggers or enable auditing…

  pawana.paul

  3 replies

  14 years ago

  By: Ignacio A. Salom Rangel

• ROWID vs Clustered Key

  Hi All, Performance wise is there any difference using (by non-clustered index) ROW ID(for heap) vs…

  Barcelona10

  3 replies

  14 years ago

  By: Lynn Pettis

• Dynamically build connect string for Maintenance Plan Task in SSIS

  I'm trying to execute a Maintenance Plan task on all my instances. I've been successful in executi…

  SQLDCH

  1 replies

  14 years ago

  By: SQLDCH