SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• divide column

  hello friends i have task teacheridtlnametfnameschoolidschoolname 2 john smith…

  surma.sql

  4 replies

  14 years ago

  By: Jeff Moden

• Sorting Table Data Problem.

  I recently uploaded data from a CSV file into a SQL Server Table. The data is formatted with a vch…

  mcertini

  4 replies

  14 years ago

  By: mcertini

• divide column by primary and secondary

  hello friends i have task teacheridtlnametfnameschoolidschoolname 2 john smith …

  surma.sql

  13 replies

  14 years ago

  By: surma.sql

• Changing Data type from char to numeric

  Below is an example table. I'm trying to get the average admission_exam_score, which happens to be …

  DataAnalyst110

  9 replies

  14 years ago

  By: DataAnalyst110

• join

  create table client(client_id int primary key ,client_name varchar(22)) create table contact (conta…

  weston_086

  6 replies

  14 years ago

  By: luckysql.kinda

• Email Notification for Alrts

  We have some mirrored databases in SQL SERVER 2008 and I have created some alerts(Like checking th…

  Aspet Golestanian Namagerdi

  1 replies

  14 years ago

  By: GSquared

• Store Proc runs in 3 secs in SSMS takes 3 minutes when ran from Agent

  This one has me sort of stumped. When I profile this not only does the time increase but so does c…

  ben.rosato

  11 replies

  14 years ago

  By: ben.rosato

• Log Shipping: Log File became too large on the secondary server

  We are using Red-Gate Backup tool for Log Shipping. I have noticed that the log file is increasing …

  Nadya Derzhi

  4 replies

  14 years ago

  By: Nadya Derzhi

• Truncate Log Files

  I am using 2008 R2. The DB is in full recovery mode.The transaction log is full (99.99%) and now I …

  peacesells

  4 replies

  14 years ago

  By: Lynn Pettis

• Why deadlock is happening here for this case

  What all needs to be looked to troubleshoot this deadlock issue.Different value is choosen for iCus…

  Anup Sivadas

  3 replies

  14 years ago

  By: Anup Sivadas

• Do I need a cluster index?

  Hi I have a table with 3 columns, say Col1,Col2 and Col3. Values in these columns repeat, So I can'…

  S_Kumar_S

  3 replies

  14 years ago

  By: Michael Valentine Jones

• Convert minutes to hours

  Hi I have a field in my table which has values in minutes. I need to convert to hours. I am doing t…

  a2zwd

  2 replies

  14 years ago

  By: Sean Lange

• A strange string gets appended to my flatfile output "_x003C_none_x003E_"

  Hi Everyone, Hope all is well. I have noticed an issue last night. One of the SSIS packages that ou…

  Pyman

  8 replies

  14 years ago

  By: Pyman

• Exisiting mirroring endpoints become disconnected

  I have spent the last hour vainly searching for some help with mirroring endpoints. Here is the sit…

  Michael Lee-169622

  2 replies

  14 years ago

  By: Michael Lee-169622

• power shell or batch file script for sql server

  Could someone please provide me the powershell script for the below query. i have two text files, o…

  chinni1978

  4 replies

  14 years ago

  By: Steve Jones - SSC Editor