SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• SQL TOOLS

  Hi all,does anyone know of a free SQL tool that can scan a group of machines and expose the follwoi…

  davidshephard

  6 replies

  13 years, 10 months ago

  By: davidshephard

• Max() conundrum

  I have a table (ID identity,ProjectID foreign key,MICAPID foreign key,ODD datetime...) called tblxr…

  Jim

  4 replies

  13 years, 10 months ago

  By: Jim

• Are unions able to be queried?

  select distinct firstname,lastname,address,Null as address2,city,state,zipcode,country,phone,email,…

  cbrown 66440

  2 replies

  13 years, 10 months ago

  By: cbrown 66440

• Creating a new column based on stated criteria

  Hello all, I'm having trouble trying to get the required results with the following SQL code: SELEC…

  matt_scott1984

  5 replies

  13 years, 10 months ago

  By: matt_scott1984

• production web application performance degradation due to database issues

  I am using sql server 2005.My application runs very slow since past few weeks. It was running good …

  Pink123

  4 replies

  13 years, 10 months ago

  By: PaulB-TheOneAndOnly

• managing large tables

  I'm predominantly from an oracle background so not particularly familiar with sql server, though th…

  stonysleep

  4 replies

  13 years, 10 months ago

  By: Gail Wanabee

• How to get Update table date

  Hi All, Is there any function in sql to find out update date of table.

  vaibhavraut88

  2 replies

  13 years, 10 months ago

  By: tyson.price

• connecting to database

  Hi ,please i need help if you can,i like connecting to database exist in PC in network has ip adres…

  achref.dhahri

  4 replies

  13 years, 10 months ago

  By: achref.dhahri

• SQL Server 2008 R2 File/Filegroup Restores

  Our production DB has 4 total files associated with it: 1 File_A - Primary File Group- 15 GB 2 Fil…

  dftharpe

  1 replies

  13 years, 10 months ago

  By: Gail Shaw

• self Join [Help Required]

  Hi, i need help regarding self join... i have a table 'table1' which contains columns: 1) id--uniqu…

  arslan_a2z

  15 replies

  13 years, 10 months ago

  By: VSP

• how can i get a table to go inside another table

  i have a table (1) that i imported in DTS, just one column varchar 255 (name) about 400k records i …

  danmc58

  2 replies

  13 years, 10 months ago

  By: PaulB-TheOneAndOnly

• Scheduled job failure notification

  I have a scheduled job which runs every 5 minutes. Last night the job continually failed due to a …

  GeoffAUS

  4 replies

  13 years, 10 months ago

  By: GeoffAUS

• Please Help me

  I was completed my sql server dba course in one of the worst institute in hyderabad. Please provide…

  sqldba2k8

  2 replies

  13 years, 11 months ago

  By: Gail Shaw

• Issue with trigger and external DSN connection

  Hello ! I'm new to this forum ;I'm new to SQL Server 2005 programming to. I guess I could find some…

  raphael.kong

  17 replies

  13 years, 11 months ago

  By: raphael.kong

• DB Mail queued, not sending

  All, I am a newbie to DB mail, just started using it at my current company, and am having an issue…

  as2higpark

  12 replies

  13 years, 11 months ago

  By: as2higpark