SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Execute server DTEXEC from a PC

  Hello, I want to give a user with Windows 7 PC, a batch file which can execute a DTexec on a server…

  datsun

  3 replies

  10 years ago

  By: John Mitchell-245523

• Count differs while using the date values

  Hi, I'm an Oracle developer and new to SQL Server. I ran the following queries in SQL Server 2008 a…

  pstanand

  9 replies

  10 years ago

  By: Sergiy

• Not able to retrieve the records checking the exact data stored in Description field

  Hi I am trying to retrieve the records using the following query, the "Descrip" column data type i…

  saisrikar

  8 replies

  10 years ago

  By: saisrikar

• SQL Server 2008 to 2014 upgrade - performance degradation

  We upgraded SQL Server from 2008R2 to 2014 and we've seen severe performance degradation of stored …

  N_Muller

  2 replies

  10 years ago

  By: Grant Fritchey

• sql loop with insert

  I've placed data into a temp table as such: declare @i as int declare @nmbrRow as int declare @dM …

  wdmm

  2 replies

  10 years ago

  By: wdmm

• How to find sql installed services on server

  Hi Fnds, I am looking to find out ssis, ssrs, ssas installed on which server, i have several server…

  mac_live

  8 replies

  10 years ago

  By: srivivek84

• Intermittent poor query performance

  Hello, each week a process is ran from the front end system that sometimes will take at least twice…

  cunningham

  8 replies

  10 years ago

  By: Sergiy

• Linked Server and changing Catalog names

  Hi, We created linked servers for AS400 from SQL 2008R2. Is it possible to change the catalog name …

  ramana3327

  2 replies

  10 years ago

  By: ramana3327

• Trigger - Display Updated Fileds

  Is there a way with a trigger to display only the fields that were updated? My issue is it could be…

  Ebays7

  4 replies

  10 years ago

  By: Steve Jones - SSC Editor

• multiple tempdb files - no sgam contention.

  I can't see any sgam contention. Is there any point in me having multiple tempdb files? Background…

  snomadj

  4 replies

  10 years ago

  By: Steve Jones - SSC Editor

• Open Excel File

  Is there a script out there or some sort of stored procedure that will open an Excel file?

  jonathanm 4432

  4 replies

  10 years ago

  By: Steve Jones - SSC Editor

• sql query issue

  Hi, How can I get the query below to show the invoice delivery date to be 2015-12-12? Drop table #…

  cajsoft

  10 replies

  10 years ago

  By: Luis Cazares

• SQLServer 2008R2 Min & Max meory settings question

  Hi, One of my production server running on sql server 2008R2 Standard Edition with Two Instances (D…

  jamessdba

  1 replies

  10 years ago

  By: Grant Fritchey

• DDL trace: why TextData is null?

  I created a trace for 3 events: 46 - Object:Created 47 - Object:Deleted 164 - Object:Altered Here i…

  SQL Guy 1

  1 replies

  10 years ago

  By: Jacob Wilkins

• Linked server with DB2 required files are missing.

  How can I install Microsoft Visual C++ 2010 x86 Runtime on a SQL Server 2008. This server do no hav…

  shamshad.ali

  3 replies

  10 years ago

  By: shamshad.ali