SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Confused by table size

  I have a table in a database I inherited that has an mdf file of 25GB, with ~870MB space available.…

  mgrubbs 50094

  9 replies

  13 years, 3 months ago

  By: Gazareth

• Multiple Rows in One Resultset

  Hi All, Let's say I have a table like the following: row1row2row3row4 0600 00300 4000 0…

  clay.calvin

  7 replies

  13 years, 3 months ago

  By: clay.calvin

• quotation and punctuation in sql server

  Does anyone have some rules by which quotation in SQL Server works? An example: Select Year, Max(Ca…

  r_slot

  4 replies

  13 years, 3 months ago

  By: gorthog

• CASE Statement not working

  Hello- I'm in the process of building a script with a CASE statement and for some reason I cannot g…

  igloo21

  6 replies

  13 years, 3 months ago

  By: gorthog

• search by text? need insight

  Hello Gurus, I am little perplexed with this search thing, hoping for your help. here is what I hav…

  SQL_path

  12 replies

  13 years, 3 months ago

  By: Sean Lange

• query plan(s)

  Hi all, I have a job that took a pretty long time last night compare to a day ago. It was hours vs …

  RightOnTarget

  2 replies

  13 years, 3 months ago

  By: Gail Shaw

• How to import data from .csv file into a table in sql server using bcp in/out

  Hi experts, I have a .csv file from which i have to do bcp out and bcp in, in command prompt and st…

  arthi.anan

  4 replies

  13 years, 3 months ago

  By: OTF

• BCP Command

  I am fairly new to SQL have been trying to automate a task that I currently run manually. I am tryi…

  justin_post

  9 replies

  13 years, 3 months ago

  By: Lowell

• SQl Joins

  Hi, I am new to SQL. I have question regarding joins. Let us say i have 3 different tables Table Wo…

  prashantvp79

  19 replies

  13 years, 3 months ago

  By: Jason-299789

• Adding record to db using stored procedure and identity counter.

  While I've been using MS SQL for years, never really learned it. Using test environment SQL 2005, W…

  britinusa

  7 replies

  13 years, 3 months ago

  By: GSquared

• connecting sql server over the internet

  Hi all, i'm new to sql server 2008 and i would like help with connecting two pc's over the interne…

  peterjb44

  3 replies

  13 years, 3 months ago

  By: Joie Andrew

• MAX Function Problem

  I need to query a table that has three columns 1st RecordID (Primary Key, Unique), 2nd ItemID (non-…

  CoryJ72

  11 replies

  13 years, 3 months ago

  By: CoryJ72

• SQL Server Database Mail extra profile

  I just installed database mail on SQL Server 2008 Enterprise Edition. While doing the install I co…

  jralston88

  1 replies

  13 years, 3 months ago

  By: Ignacio A. Salom Rangel

• SQL Server 2008 R2 Express Sync

  Hello I have been tasked with finding a method of synchronizing offsite branches to the HQ. It wi…

  eplus

  1 replies

  13 years, 3 months ago

  By: Ignacio A. Salom Rangel

• sqlserver 2005 express installation

  Hi, I have installed sql server 2005 express management studio. After the successful installation, …

  arkiboys

  2 replies

  13 years, 3 months ago

  By: arkiboys