SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SOS_SCHEDULER_YIELD waits gradually increasing over time for same query

  I have a job that does the following via C sharp code: -opens a connection to sql server (keeps it …

  NJ-DBA

  5 replies

  14 years, 1 months ago

  By: NJ-DBA

• Uploading a file into a website using SSIS

  Hi, Can any one guide me how to upload a xml file into a website using SSIS? Is it possible to upl…

  prasadau2006

  2 replies

  14 years, 1 months ago

  By: Derek Robinson

• SQL Server Joins

  Does SQL Server 2008 and higher version supports *= operator of Joins?

  Boby B Jacob

  3 replies

  14 years, 1 months ago

  By: GSquared

• Integration Services on a cluster

  I have a default instance on a WIn2008R2\SQL2008R2 cluster and I want to save and use an Integratio…

  Anonymous

  3 replies

  14 years, 1 months ago

  By: Anonymous

• Stack dump occured unable to understand and find the cause

  Hi All, I overserved some messeges in sql error log stating Using 'dbghelp.dll' version '4.0.5' Exc…

  vinod.saraswat

  4 replies

  14 years, 1 months ago

  By: vinod.saraswat

• how to avoid null or ' ' value in a select query and replace that value as 0 in a select query not in the table?

  here i am having table declare @test1 table( id int, val varchar(20), ser int, sa int ) insert in…

  Sivaganesh Tamilvendhan

  7 replies

  14 years, 1 months ago

  By: Gazareth

• Backup and restoration

  i am confused in one scenario please help every Saturday full back : 10 PM daily differential backu…

  Zeal-DBA

  10 replies

  14 years, 1 months ago

  By: SQLisAwe5oMe

• Need advice - good place to start learning SSAS

  Any suggestions would be very appreciated. Currently I have experience with TSQL, SSIS Thanks in ad…

  ntuschiev

  7 replies

  14 years, 1 months ago

  By: Jared

• Manually Created statistics on a table on a column but it is seen nothing

  Hi All, I created some statistics on a table on column. But when i examine statistics detail, it is…

  Thinky Night

  7 replies

  14 years, 1 months ago

  By: SQL Show

• Excel to Database - validate and import

  New website has been activated this morning http://leansoftware.net/en-us/products/exceltodatabase.…

  C# Gnu

  1 replies

  14 years, 1 months ago

  By: C# Gnu

• Full Text Search Estimated Update Time

  Hi I want to learn that when we create full text indexes in auto change tracking mode, how much tim…

  sporoy

  1 replies

  14 years, 1 months ago

  By: William Melcher

• Mirroring with witness end point on mirror server

  hi, i have only 2 servers and also want to configure witness with that i want to configure witness …

  shah.smit

  4 replies

  14 years, 1 months ago

  By: shah.smit

• Count Per Hour By User By Day

  I'm trying to create two reports that would look like this; passing a date range for start/end: Rep…

  texpic

  5 replies

  14 years, 1 months ago

  By: ChrisM@Work

• RESTORE

  every Saturday full back : 10 PM daily differential backup : 10AM Tlog bkup happenes at every 1 hr …

  Zeal-DBA

  1 replies

  14 years, 1 months ago

  By: Gail Shaw

• Subquery returned more than 1 value. This is not permitted

  I am getting the above error when running the below code. This has started happening on this bit of…

  erics44

  15 replies

  14 years, 1 months ago

  By: erics44