SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• DOUBLE precision for calculations / CONVERT TO DOUBLE?

  I am performing a series of calculations where accuracy is very important, so have a quick question…

  bkmooney

  2 replies

  11 years ago

  By: Orlando Colamatteo

• Clone Store procedures from Database A to database B

  Hello all I have this requirement where some store procedures from a "seed" database need to be rep…

  ricardo_chicas

  4 replies

  11 years ago

  By: Grant Fritchey

• How to return 1 particular column from another table in join

  Hello, I'm creating a sql stored procedure inside this proc it returns some information about the u…

  .Netter

  3 replies

  11 years ago

  By: Ed Wagner

• Add ID and Primary Key to Large Table(s)

  Background: * SQL Server 2008 R2 * Database was created from a third party product. The product wr…

  tking 39890

  10 replies

  11 years ago

  By: ScottPletcher

• Table Valued Function

  Hi, I would like to create a table valued function that fetch through the table below using a curso…

  forrest77

  16 replies

  11 years ago

  By: Lynn Pettis

• Importing Large Datasets

  SQL Server 2008 R2 We have an application that essentially sits and waits for external text files t…

  BSavoie

  4 replies

  11 years ago

  By: BSavoie

• How to find statements that cause large mamory paging?

  I am monitoring our production server, and noticed that periodically we have spikes of Memory Pagin…

  SQL Guy 1

  5 replies

  11 years ago

  By: SQL Guy 1

• How to improve speed of initial query vice subsequent queries

  I know it's been asked but: I have a pretty large DB and a fairly complex query. If I drop buffers…

  souLTower

  5 replies

  11 years ago

  By: Grant Fritchey

• xp_create_subdir() returned error 183, 'Cannot create a file when that file already exists.'

  Using the below xp to create folder to a network share. But getting error:- EXECUTE master.dbo.xp…

  SQL_Hunt

  5 replies

  11 years ago

  By: cunningham

• SQL Linked Server Column Names

  Hi, I have a very weird situation in my SQL Server instance that I'm hoping someone might know some…

  Mike Scalise

  3 replies

  11 years ago

  By: cunningham

• how to assess a sql expert for a job?

  Hi, I need to create a job description for a SQL developer. My company has several applications wh…

  sqlguy-736318

  4 replies

  11 years ago

  By: ScottPletcher

• SQL Server Setup has encountered the following error: There was an error generating the XML document. Error code 0x84B10001

  When i try to Installing SQL 2008 r2, I have a problem : TITLE: SQL Server Setup failure. ---------…

  ngochoang297

  6 replies

  11 years ago

  By: serg-52

• Error log getting full.

  My error log was keep on increasing and consuming entire disk space because of below error. An e…

  m.rajesh.uk

  5 replies

  11 years ago

  By: Gail Shaw

• Set null does not work for more than one field

  Hello. I have the Person table with the following fields: Id_Person Nm_Person Id_AddressResidential…

  wcarvalho

  5 replies

  11 years ago

  By: Matt Miller (4)

• Any way to count the number of files deleted from share path?

  SET NOCOUNT ON Declare @daysOld int,@deletedate nvarchar(19) ,@strDir varchar(250) declare @cmd11 n…

  SQL_Hunt

  1 replies

  11 years ago

  By: Jeff Moden