SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SQL Server Monitoring - Is it reasonable to use the monitored SQL Servers resources such as tempdb?

  I recently ran into a potential issue with a SQL Server monitoring application and I'm wondering if…

  YSLGuru

  1 replies

  9 years, 9 months ago

  By: Steve Jones - SSC Editor

• Not able to download SSRS reports 2008 from the reports manager

  Hi all, I am stuck with a problem. I am trying to download the reports from theSSRS reports manager…

  fareedhmohamed

  2 replies

  9 years, 9 months ago

  By: fareedhmohamed

• In Payoll query Allowance Deduction Amount in multiple row

  SELECT EmployeeCode,Name,Allowance,Allow,Deduction,Dedu FROM ( SELECT E.EmployeeCode …

  tamil.selvanmca

  1 replies

  9 years, 9 months ago

  By: Steve Jones - SSC Editor

• after uninstalling MSSQL 2008 R2 I cannot install it again.

  Even though I used iObit uninstaller... still a bunch of errors come up at the beginning of new ins…

  VoldemarG

  1 replies

  9 years, 9 months ago

  By: FridayNightGiant

• operating system error 665

  Hi All, I am maintaining 2 days snapshots for my database.one snapshot a day. i am getting operat…

  m.rajesh.uk

  4 replies

  9 years, 9 months ago

  By: m.rajesh.uk

• Remove namespace in each child node in xml output using sql

  Hi all, i am generating one xml columns. in that root i am having some namespaces. my quer…

  Kasinathan

  4 replies

  9 years, 9 months ago

  By: mister.magoo

• SSIS derived column transformation failing on converting Blank rows from excel while converting the column from string to int

  Hi, I have flat file source from which data is imported to a Sql table.The target column is int and…

  bpsavi123

  8 replies

  9 years, 9 months ago

  By: jonathan 49687

• How to use a table value function that splits a string

  I have a TVF that takes two parameters, string and delimter but, I don't know how to pass the field…

  NineIron

  13 replies

  9 years, 9 months ago

  By: Ed Wagner

• High Latch Waits/Sec

  Hi, One of my Servers running on SQL Server 2008 R2 , while monitoring perfmon I can see high value…

  Sanz

  9 replies

  9 years, 9 months ago

  By: Database admin(DBA)

• Get start and end date row by row calculation based on duration

  I have a scenario in which I get startdate as a parameter and based on the start date I need to cal…

  vamsye

  3 replies

  9 years, 9 months ago

  By: vamsye

• how to search a text on a database

  Hello: I want to ask for a variable anf then search it on a database. I have this: declare @key as…

  bajarchi

  1 replies

  9 years, 9 months ago

  By: Grant Fritchey

• Select and select into calulation produces Different result ??? HELP

  I have a Calculation in a query that is producing two different results. when used in a query stat…

  rmurray 17656

  4 replies

  9 years, 9 months ago

  By: rmurray 17656

• Copy huge table from one server to another

  Hi there, I have a table with 500 million records on server1 Create table dbo.temp(ID INT not null,…

  rash3554

  3 replies

  9 years, 9 months ago

  By: SQLBill

• Combine rows into one row with line break by querying with XML

  Hi, I have a table like this: Create table Tbl_Test01 ( Name nvarchar(20), Item nvarchar(30) ) ; i…

  shogunSQL

  5 replies

  9 years, 9 months ago

  By: Jeff Moden

• SPID trace from Activity monitor

  Hello, I have a long running SPID on a database. It's from a script of many SQLs all glued together…

  datsun

  4 replies

  9 years, 9 months ago

  By: datsun