SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• How many performance counters is too many?

  I am trying to establish a baseline on a new Sqlserver and am running performance monitor from my l…

  craig-404139

  5 replies

  15 years ago

  By: craig-404139

• Functions to use instead of to_char in SQL Server 2000

  Hi, I need to change the following oracle statement equivalent in SQL Server 2000.Please help me su…

  anitha.chacko

  4 replies

  15 years ago

  By: Steve Jones - SSC Editor

• 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 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 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 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 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 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 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 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 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 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 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 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 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 ago

  By: Bron Tamulis