SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Using the Over Partion to create an instance count

  Hi, Using the sql statement below in a stored procedure rownum = row_number() over(partition by t.P…

  douglas.allison-1136597

  4 replies

  17 years ago

  By: matt6288

• Estimated execution plan not showing?

  Anyone had an issue when requesting the estimated execution plan which is not showing? Either using…

  Megistal

  2 replies

  17 years ago

  By: Megistal

• SQL2008 Data Compression

  Hi, I've been reading up on Page and Row compression and like most it seems, have been impressed w…

  simon.letts

  2 replies

  17 years ago

  By: Steve Jones - SSC Editor

• How to migrate package from sql server 200 to sql server 2008

  Hi ALL I have migrate my SQL from 2000 (Win 2003 platform) to SQL 2008 (Win Server 08 Itanium) Ther…

  adzuan

  4 replies

  17 years ago

  By: simon.letts

• Sql2008 - SSIS package fails to save - login timeout

  Hi there So, we have a new SQL 2008 server, running on a new Server 2008 64bit machine with 8GB ram…

  Alocyte

  1 replies

  17 years ago

  By: Alocyte

• Running out of space in tempdb

  I came across a weird thing while trying to figure out what the most expensive queries are in our o…

  Jan Van der Eecken

  3 replies

  17 years ago

  By: Jan Van der Eecken

• how can i use sql server 2008 on my dedicated server

  sql server 2008 express allows 4gb space enough for me is it per DB or for the entire sql server ? …

  sukhoi971

  1 replies

  17 years ago

  By: MarkusB

• 3 table Pivoting

  I have 3 tables in my system. Table1: AvailableServices ---------------------------------- Availabl…

  sqlserver2010

  5 replies

  17 years ago

  By: LutzM

• SELECT via RPC with ODBC

  As part of an upgrade project, we are upgrading our intranet from a single SQL 2005 SP3 server to a…

  david_okeefe

  11 replies

  17 years ago

  By: sgmunson

• sys.credentials does not exist. Why?

  Hi. I have instaled SQL Server 2008, with all of its components, but the system catalog views doesn…

  joni nemonic

  4 replies

  17 years ago

  By: joni nemonic

• DTS to SSIS 2008

  Hi, I have installed a SQL2008 Ent Edition on a test server as a named instance on a server which …

  simon.letts

  2 replies

  17 years ago

  By: simon.letts

• SQL Server 2008 R2 Free upgrade

  I just started reading about the R2 release, and I was wondering if that will be a free upgrade tha…

  tluker

  3 replies

  17 years ago

  By: Grant Fritchey

• SQL 2008 Auditing: CDC Vs Apex SQL Audit

  Guys, I trying to implement auditing for the sql server 2008 database. I have looked at Change data…

  am-244616

  2 replies

  17 years ago

  By: David Sorauer

• SQL Server 2008 Error: the server version is not supported. the target server must be sql server 2000 or later.

  Hi, I am getting the error "the server version is not supported. the target server must be sql ser…

  sri76

  2 replies

  17 years ago

  By: abba-602531

• convert sql 2008 developer edition to standard edition(question)

  Does anyone know if you can convert sql 2008 developer edition to 2008 standard edition without doi…

  Mickle

  2 replies

  17 years ago

  By: Mickle