SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Help with Triggers

  I have to create 3 triggers for a table - INSERT, DELETE, and UPDATE. The triggers will be used to…

  cmorris1441

  17 replies

  13 years ago

  By: Dird

• Best Solution?

  I have the following issue: 1. I work for a company that has boutique stores in various locations …

  imani_technology

  3 replies

  13 years ago

  By: Steve Jones - SSC Editor

• Installing a named Instance of SQL Server 2012, on a server where it already had SQL Server 2008 R2 Instance.

  Hi Expertts, I got a requirement to install a new SQL Server 2012 on a server where it already had …

  SQListic

  2 replies

  13 years ago

  By: SQLRNNR

• Database Data File Physical Fragmentation From Small Auto-Growth Setting

  To All, I need some advice. I've just started a new job and one of the first problems I've encounte…

  Gail Wanabee

  3 replies

  13 years ago

  By: SQLRNNR

• concatenate

  Can not figure out what I am doing wrong in table on I have FirstName and PhoneNumber and in the se…

  edward_hall76

  11 replies

  13 years ago

  By: Sean Lange

• Subquery

  I have gathered employee data SELECT EmpID, LName, FName, StationID FROM emp.employees Provides me …

  ccmret

  5 replies

  13 years ago

  By: Sean Lange

• Check String for some chacters

  I need to check to see if string contains (,-, / or . and pull out only the numbers from the strin…

  SQL_Surfer

  4 replies

  13 years ago

  By: SQL_Surfer

• Is there a way to find who added data and log file to database

  Hi SQL Guru's, Is there any way to find out who has added any new data file or log to the database …

  Hassans

  4 replies

  13 years ago

  By: SQLRNNR

• Is this data lost?

  Hi, Have a database that is set to recovery model=full. Some data was inserted then immediately d…

  davidgray

  14 replies

  13 years ago

  By: SQLRNNR

• Copy db from server a to server b nightly

  Hello - I have a db on one server, and I'd like to copy it over to a different server every night t…

  dbursey

  7 replies

  13 years ago

  By: dbursey

• Trouble grabbing values for multiple IDs

  Trying to get a total of instances of events and assigning it an alias (SELECT COUNT(id) from Fin…

  znetznet

  1 replies

  13 years ago

  By: Lynn Pettis

• Need an update statement

  /****** Object: Table [dbo].[PhoneTable] Script Date: 4/23/2013 4:55:46 PM ******/SET ANSI_NUL…

  prakashr.r7

  7 replies

  13 years ago

  By: Sean Lange

• Slow performing query!

  The following SQL query isn't scaling very well! Works great on record sets of 10-20 million. Howev…

  Abu Dina

  10 replies

  13 years ago

  By: Abu Dina

• Help with Second highest date

  I have a stored procedure and I am selecting Renewal Date and the Last Renewal date (second last gr…

  maxlezious

  3 replies

  13 years ago

  By: Sean Lange

• double hopping

  can any one explain me what is double hopping

  SQLCracker

  1 replies

  13 years ago

  By: Neeraj Dwivedi