SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Split path folder into subfolder.

  I have a two column ID and Path that contains below information. I have almost 1000 records but I …

  patla4u

  8 replies

  11 years, 4 months ago

  By: Cadavre

• Troubleshoot the SQL server error log

  Hi All, I would like to troubleshoot the error that comes up in my production SQL Server System Log…

  WhiteLotus

  3 replies

  11 years, 4 months ago

  By: WhiteLotus

• Table size is Huge!!!

  I have a database around 600 GB out of that A table is 398 GB, index size is 3 GB free space arund …

  Tac11

  28 replies

  11 years, 4 months ago

  By: SQLRNNR

• Loading data from multiple flat files to sql server using SSIS

  How should I approach on creating SSIS package to load data from multiple files to multiple tables.…

  2sbhagat

  7 replies

  11 years, 4 months ago

  By: Evil Kraig F

• Need help for Non-Printable characters for decimal values in VARCHAR field

  I have an excel file load to a staging table using powershell, the load is completed, but facing ch…

  dchung 4500

  2 replies

  11 years, 4 months ago

  By: Jason Selburg

• Deadlock during insert activity

  Hi Gurus, i am facing deadlock issues and performance hit, this is my deadlock graph. please provid…

  vkundar

  3 replies

  11 years, 4 months ago

  By: Rudyx - the Doctor

• complex query

  hi all, i need to find gap in time (minutes) when value exceed the value: 55. create table #temp ( …

  sharon-472085

  3 replies

  11 years, 4 months ago

  By: Lynn Pettis

• how to speed up update statistics full scan

  hi, i have a 20G table which takes 40 minutes to update statistics with full scan. i want to perfor…

  rajsin7786

  6 replies

  11 years, 4 months ago

  By: Rudyx - the Doctor

• simple division

  I do this: select 18/94 and got 0! answer is supposed to be .19. I tried select convert(decimal(5,…

  KoldCoffee

  7 replies

  11 years, 4 months ago

  By: SQLRNNR

• Help to add money value

  I am trying to add a field (bank_chk_amt] from a table in to my query to bring in a dollar amount..…

  wallywizard

  3 replies

  11 years, 4 months ago

  By: Luis Cazares

• handled NA values after'-' symbol in sql server

  hi friends i have small doubt in sql server how to solve this issue Table:emp sn | code | sa…

  asranantha

  3 replies

  11 years, 4 months ago

  By: Cadavre

• Max Function

  I am a newbie. I am trying to get the most recent date in a list of dates. Here is the script: MA…

  et2brutuss

  9 replies

  11 years, 4 months ago

  By: et2brutuss

• lock acquisition order in sp_lock

  Hi all, I need to discover the actual order in which locks are acquired on a table during a query. …

  marcocrocevia

  11 replies

  11 years, 4 months ago

  By: marcocrocevia

• Difference In Query Plans while Executing Same Query Independently and Within Stored Proc

  Hi All, While working on some queries, I came across a scenario where the same query when running s…

  er.mayankshukla

  11 replies

  11 years, 4 months ago

  By: ScottPletcher

• Query Running at Management Studio stops SQL Server from responding to queries fired through ASP .net Application

  We have a SQL Server 2008 running which provides data base access to out asp.net applications. But …

  dibakar

  3 replies

  11 years, 4 months ago

  By: Eric M Russell