SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• TEMPDB on RAM

  Configuring SQL to put TEMPDB completely on RAM? .If RAM is dedicate to TempDB will improve perform…

  Admingod

  29 replies

  12 years ago

  By: Jeff Moden

• empty string INSERTs as 0 to INT column - how to prevent it?

  While coding in Powershell, due to happenstance, an update was sent to SQL Server that referenced a…

  sqlnyc

  2 replies

  12 years ago

  By: sqlnyc

• 17GB of data. Database is 290GB. Why???

  I ran the below query and I got 17GB of data. Why is the database 290 GB. DECLARE @TableName VARCHA…

  Alan Naylor

  8 replies

  12 years ago

  By: joshdbguy

• UNIQUE constraint mystery

  Hi everyone, Running SQL 2008R2 Standard with SP2, and db comparability level = 90 (SQL 2005). Per…

  sqlnyc

  3 replies

  12 years ago

  By: Grant Fritchey

• Is there an easy way to get the scripts of a table with only t-sql, not with the wizard?

  Hi I am trying to build something that needs to be very dynamic that mimic a replication, for that …

  ricardo_chicas

  6 replies

  12 years ago

  By: Lowell

• How can I get the minimum value for columns group per row ??

  Purpose : I would like to get the minimum value for columns group per row. Example : ID , ProductN…

  ahmedhussein874

  8 replies

  12 years ago

  By: Luis Cazares

• Question regarding setting up Xlog backup.

  I have a database (Prod) which is about 10 GB and I am supposed to setup a transactional log backup…

  LearningDBA

  1 replies

  12 years ago

  By: MyDoggieJessie

• please give answer to this Interview question

  Can anyoine answer this interview question Please?? A DBA accidentally dropped a critical highly tr…

  rraza

  14 replies

  12 years ago

  By: SQLRNNR

• A user database listed under System Databases

  Hello SQL Community, I don't even know where to start... well, I know.. google didn't tell me anyth…

  MiguelSQL

  4 replies

  12 years ago

  By: SQLRNNR

• Convert Column to Row

  Can some one help me to fix my issue now. On Entering a query , I get Ouput as below col1col2col3…

  jeganbenitto.francis

  1 replies

  12 years ago

  By: HanShi

• Round off sum values

  Hi, I have already summed the values and this below query sum the values and returns zero if there …

  vigneshkumart50

  1 replies

  12 years ago

  By: HanShi

• intersect

  i have the below table.. i need the intersection of j with group by of i column, which is 4. pls le…

  karthik babu

  11 replies

  12 years ago

  By: karthik babu

• Need to load double pipe || delimited data in a table by using SSIS

  Hello, Recently in an interview , Interviewer asked me below question : I have an Excel where data …

  dharmendra.mittal

  2 replies

  12 years ago

  By: dharmendra.mittal

• disable windows auth and change and change user password from script

  Hi all is it possible to change the password of a user from a script and at the same time disable w…

  jerome.morris

  1 replies

  12 years ago

  By: jerome.morris

• SSIS: Using a Full Result Set variable in a Data Flow Task

  I attempting to find a solution for data extraction from a remote Oracle server using SSIS. I have…

  Ryan-257272

  4 replies

  12 years ago

  By: tzvikl