SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Adding rows od data together

  Hi everyone - hope someone can help. I have a table containing around 1,000 rows. Each row consists…

  ByronOne

  8 replies

  14 years, 10 months ago

  By: ByronOne

• retrieve views containing reference to a specific column

  How one might one retrieve a list of views containing a reference to a specific column (even if tha…

  KoldCoffee

  11 replies

  14 years, 10 months ago

  By: KoldCoffee

• Multiple Tables

  I have several tables with same columns and i want to extract same information from all tables. can…

  amithpdn

  3 replies

  14 years, 10 months ago

  By: Syed Jahanzaib Bin hassan

• Executing stored procedure parameter strings without quotes?

  Greetings all, So the default shortcut keys to use, Alt+F1 for sp_help for instance (I am running …

  shannonjk

  1 replies

  14 years, 10 months ago

  By: Latheesh NK

• tempdb.mdf on 2008 grown out of control than 2005.

  :hehe:Hi Guys, After reading so many post, I am still in situation where my tempdb.mdf file grown …

  keyun

  11 replies

  14 years, 10 months ago

  By: Otis P. Driftwood

• Making where clause dynamic in tsql

  Hi, I have three tables T1 with columns: JoiningYear,ID, Type ID, DeptID T2 with columns: TypeID, T…

  punia

  1 replies

  14 years, 10 months ago

  By: Jeff Moden

• Map Drive in Database Maintenance Plan

  As I am going to schedule Database in maintenance plan for sql server 2000.But the network drive (M…

  guest.kharind

  4 replies

  14 years, 10 months ago

  By: Jeffrey Williams

• Powershell job run through SQL agent doesn't write output

  I have a job that scripts out database objects such as tables, indices and schemas using the script…

  Judy Scheinuk

  13 replies

  14 years, 10 months ago

  By: Judy Scheinuk

• A(nother) discussion on CXPACKET

  I'm using a server with 4 Quad-Core processors, 96GB of relatively dated RAM, and a 2-disk RAID arr…

  TheGreenShepherd

  1 replies

  14 years, 10 months ago

  By: Evil Kraig F

• Log reader

  I am looking into buying a log reader, can anyone of you suggest any that you have used and like it…

  Guras

  2 replies

  14 years, 10 months ago

  By: Greg Charles

• Executing a BCP command and see the following error: SQLState = 08001, NativeError = 0

  Hello to all, This is a rehash of an issue that was first noted in a SQL 2005 posting but I didn't …

  leosinclair

  1 replies

  14 years, 10 months ago

  By: Orlando Colamatteo

• Maintenance Package Failing

  I was asked to help out creating maintenance plans on a server that I did not build. When I went t…

  DBAgal

  1 replies

  14 years, 10 months ago

  By: Shawn Melton

• copy table to another database, server

  I would like to copy a table from one databaes on QA to production. What are the best ways to do it…

  sqlfriend

  1 replies

  14 years, 10 months ago

  By: Ninja's_RGR'us

• I want to configure Mirroring Between these two Servers:

  I want to configure Mirroring Between these two Servers: First: Windows Server 2003 Standard 32 bi…

  forsqlserver

  1 replies

  14 years, 10 months ago

  By: gsc_dba

• Does anybody know the list of execution plans which include FULL-TABLE SCAN

  Hi all, Does anybody know how do i list of (cached or previously run)execution plans which include …

  thinknight

  7 replies

  14 years, 10 months ago

  By: Ninja's_RGR'us