SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• How to create a folder in SQL server 2008

  Is it possable to add folders to SQL Server Management Studio under "Tables" folder at the same lev…

  sifunda

  3 replies

  15 years, 5 months ago

  By: Grant Fritchey

• How do you become SSIS/SSRS/SSAS Administrator or Developer?

  How do you become SSIS/SSRS/SSAS Administrator or Developer? Thanks

  YankeesSQL

  11 replies

  15 years, 5 months ago

  By: Lynn Pettis

• The multi-part identifier ... could not be bound

  Hi, I've been receiving this error message when I try to run the following query. Having looked ar…

  garethdyson

  1 replies

  15 years, 5 months ago

  By: ChrisM@Work

• Combining / crunching data?

  Ok this will take some explaining. If I have a table, columns MYKEY, DT, A, B, C, D, E with the fol…

  Atat Rowcount

  5 replies

  15 years, 5 months ago

  By: Atat Rowcount

• Slow running query

  Hi guys, One question, assume a stored procedure is having 10 operations and among them one caus…

  ramuthoutu

  2 replies

  15 years, 5 months ago

  By: ramuthoutu

• Trigger

  What are types Trigger in SQL SERVER 2008? A) Triggers are classified into three main types:- 1. DM…

  vinoth-750003

  1 replies

  15 years, 5 months ago

  By: mathuflower2k6

• simple query cannot be killed

  Hi Guys, For some reason the following query takes 100% CPU of one Core. I cannot kill it.. any one…

  y.loewidt

  1 replies

  15 years, 5 months ago

  By: y.loewidt

• Partition columns for a unique index must be a subset of the index key.

  begin -- Add with nocheck Constraint PRIMARY KEY (non-clustered) ALTER TABLE DemographicGeo WITH NO…

  EasyBoy

  1 replies

  15 years, 5 months ago

  By: DB Dan

• Max DOP > 13 get stuck on one env and works fine on another env

  Hi Guys, I have a bizzare issue. Lately one of our ETL Engines started getting stuck, after some ex…

  y.loewidt

  3 replies

  15 years, 5 months ago

  By: Bhuvnesh

• tally table help

  USE [GamitOlap] GO /****** Object: Table [dbo].[testSales] Script Date: 12/07/2010 13:32:18 ***…

  foxjazzG

  2 replies

  15 years, 5 months ago

  By: Evil Kraig F

• Transaction log shipping questions

  Hi all, i am trying to set up log shippping for the first time and have some questions: We can only…

  e90fleet

  5 replies

  15 years, 5 months ago

  By: e90fleet

• Select * from the result of store procedure

  Is it possible to run code as below? I knew it is not working but how to code to Select * from the …

  adonetok

  2 replies

  15 years, 5 months ago

  By: Michael Valentine Jones

• Restore problem

  I'm trying to restore a SQL2008 database from a device (.bak) I keep getting this message - Msg 310…

  Bron Tamulis

  4 replies

  15 years, 5 months ago

  By: Bron Tamulis

• Can I use the same alias for different tables within one store procedure?

  Can I use the same alias for different tables within one store procedure? For example, does code be…

  adonetok

  3 replies

  15 years, 5 months ago

  By: parthi-1705

• Regular Expressions in Find and Replace in SSMS?

  I have a table def I need to modify. I thought to myself, it sure would be nice if Find and Replace…

  Stamey

  4 replies

  15 years, 5 months ago

  By: Stamey