SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Reference Table or VARCHAR column?

  I am trying to get a developer to change a column in a table that is like so: CREATE TABLE tableA( …

  Jared

  5 replies

  14 years, 1 months ago

  By: Jared

• Getting example database setup - password problem

  I recently purchased this: http://www.mhprofessional.com/product.php?isbn=0071548084 I'm trying to …

  DataAnalyst110

  7 replies

  14 years, 1 months ago

  By: DataAnalyst110

• job monitoring script

  Hello, I have a job(job1) scheduled for every 10 min. i want to setup a new monitoring job ever 1 h…

  sairam6819

  6 replies

  14 years, 1 months ago

  By: sairam6819

• Joins

  Hi, Could you please help me on following joins. 1.Merge Join 2.Hash Join 3.Nested Loop join Please…

  tonyarp05 61903

  4 replies

  14 years, 1 months ago

  By: Gail Shaw

• XML data import

  Hi, I have the following xml data that I need to import into SQL. <?xml version="1.0"?> <…

  fleur.dunbar

  2 replies

  14 years, 1 months ago

  By: fleur.dunbar

• Question about dbcc shrinkfile

  Folks, Please note that this question is for educational purpose, not that I would perform shrink d…

  SimonLiew

  9 replies

  14 years, 1 months ago

  By: SimonLiew

• deleting everything?

  i am just learning how to use SQL Server 2008. i messed up and i want to delete everything i did an…

  irridessa

  2 replies

  14 years, 1 months ago

  By: irridessa

• Database Mail Issue

  Hey all I'm having issues with my database mail at the moment. I've just set up a new SQL Server 08…

  philip.stevens

  3 replies

  14 years, 1 months ago

  By: Koen Verbeeck

• SQL Server 2008 Upgrade or Install R2 version

  I have given a database which doesn't allow to restore to my sql server give me error of database v…

  m.faisal.maqsood

  1 replies

  14 years, 1 months ago

  By: Koen Verbeeck

• a book to help me to know the basics of building a cube in Analysis Services.

  i want to use cube in data mining . but i dont know what is 'cube' . i want to understand the basic…

  Ali ZD

  5 replies

  14 years, 1 months ago

  By: MMartin1

• Want to modify the content of the cols

  for example I have a table, which has ID, Service, Subservice cols. I want to modify or change 'Sur…

  hbanerje

  3 replies

  14 years, 1 months ago

  By: Jeff Moden

• trace file doesn't exist but SQL pulling data

  Here is the scenario. The file log.trc mentioned by a query below doesn't exist on server, but the…

  Luke79

  2 replies

  14 years, 1 months ago

  By: Orlando Colamatteo

• Query between month

  Hi all I use ling2sql and datatabe to fill a report using c#. I have this query below for a single …

  jerome.morris

  12 replies

  14 years, 1 months ago

  By: Lynn Pettis

• Check Constarint

  I have a table with 3 columns A int Null B int Null C int Not Null -- Cloumn 'C' can have only 2 v…

  rohaandba

  5 replies

  14 years, 1 months ago

  By: Lynn Pettis

• Question about tempdb data files filling up

  Hi everyone, Given the setup below, what would happen if the tempdb on the C:\ drive fills up? Wil…

  shahgols

  6 replies

  14 years, 1 months ago

  By: shahgols