SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• MCM Free Videos - Demo Scripts from Paul/Kim/Brent/Ben

  http://www.sqlskills.com/T_MCMVideos.asp I read a blog post from 01/2011 from Paul saying the scrip…

  alanspeckman

  5 replies

  13 years ago

  By: aleksey.fomchenko

• Table Partitioning Scenario question.

  Hi Experts, Migrating warehouse from Oracle to SQL Server : Status: In process In Oracle : 6 Schema…

  SQListic

  5 replies

  13 years ago

  By: PaulB-TheOneAndOnly

• Assigning a fieldname with rollup

  I have two tables that have racing data, and I need to add up the number of cancelled races and ma…

  znetznet

  6 replies

  13 years ago

  By: sqldriver

• SQL query to XML ???

  Hi, I',m new to XML and here is what I need to do... I want to create a SQL query to pull data and …

  jbalbo

  6 replies

  13 years ago

  By: Jon.Morisi

• SQL QUERY to find maximum and minimum column value of a primay key column in a year

  Hi Experts, C_KEY ENTER_DATE 1 2008-12-31 00:00:00.000 2 2008-12…

  SQListic

  4 replies

  13 years ago

  By: Calibear

• RSClintPrint

  So we are in the process of converting over from Crystal to SSRS. Things seem to be going fine; ho…

  jordon.shaw

  10 replies

  13 years ago

  By: jcraigue@cox.net

• Checking for index in another database

  Folks: How can i check for the presence of an index in another database ? Lets say I am in DATABASE…

  mw_sql_developer

  3 replies

  13 years ago

  By: ScottPletcher

• display specific string and display that position in sql server

  hi firends i have small doubt in sql server plz tell me how to solve to find the specific charter …

  asranantha

  2 replies

  13 years ago

  By: Sean Lange

• Mega Problems installing SQL Server 2008 R2 Developer

  I normally install SQL Server 2008 R2 Developer without any problems, for example on an unupdated v…

  meridius10

  1 replies

  13 years ago

  By: meridius10

• Use of rownum function in a select

  Hi I need to get the first row from a subselect. Have read a couple posts on this topic, but not su…

  @DJ

  6 replies

  13 years ago

  By: ChrisM@Work

• Generating a counter table in SQL

  Hi All, I am currently looking at a project that requires acounter table - I have done this very ea…

  SteveEClarke

  4 replies

  13 years ago

  By: SteveEClarke

• How to Determine New SQL Box Specs for Migration from 2005 to 2008

  So I've been researching this, but can't get a clear how to on this. I just joined a new job and o…

  //Ravi

  1 replies

  13 years ago

  By: EdVassie

• SQL Client Access Licence requirements

  Hi SQL 2008R2 Std Ed. We are having an internal debate on what does (does not) require a SQL CAL fo…

  J Livingston SQL

  24 replies

  13 years ago

  By: EdVassie

• queries on Logins

  Hi If I execute the stored procedure multiple times on same day, the first time category should not…

  saran.dharsh

  9 replies

  13 years ago

  By: saran.dharsh

• Moving multiple similar access databases to SQL

  I'm planning on moving around 4 or 5 MS Access databases to SQL Server and need some insight on wha…

  jbloes

  2 replies

  13 years ago

  By: jbloes