SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Index creation on lookup table

  Our lookup table contains only 10 records. But the transaction table, which has referenced the look…

  Pothiraj R

  5 replies

  14 years, 10 months ago

  By: Ninja's_RGR'us

• SQL Agent Job failing mysteriously

  Hi Guys, I have an issue where my scheduled job just seems to fail sometimes for no reason. Here is…

  stormsentinelcammy

  9 replies

  14 years, 10 months ago

  By: stormsentinelcammy

• manually do windows update patching.

  Hello every , i know some of you might say that its a sql server forum not windows.. but i am a sq…

  BoobyB

  2 replies

  14 years, 10 months ago

  By: BoobyB

• Killed a PID, in rollback now but.....

  OK, I had a user that needed me to kill their PID/session. The table is pretty big, 1.5million reco…

  Warren Peace

  1 replies

  14 years, 10 months ago

  By: Welsh Corgi

• Can we increase @query_result_width (size) when using MSDB.DBO.SP_SEND_DBMAIL (stored procedure)

  Hello All, I am getting problem when i am getting result of my user defined stored procedure I am u…

  vishal_mca2005

  1 replies

  14 years, 10 months ago

  By: Orlando Colamatteo

• SQL Newbie in Need of Help!!!

  I am in the process of creating a DB in SQL Server 2008 R2 and am having a couple of problems. I h…

  Aaron.Kelly 14475

  2 replies

  14 years, 10 months ago

  By: Aaron.Kelly 14475

• Scalar Functions (UDF's) compile at runtime causing locks

  It appears that scalar functions compile at runtime and require a exclusive lock. We have stored p…

  SMAAG

  6 replies

  14 years, 10 months ago

  By: TheSQLGuru

• Pass a table variable to a stored procedure

  I have been trying to figure out the correct syntax for passing a table variable to a stored proced…

  TT-131210

  6 replies

  14 years, 10 months ago

  By: TT-131210

• Importing from Excel into SQL using the Import Wizard

  I'm driving myself crazy over this and can't figure out a solution. What I'm trying to do is import…

  bgolembiesky

  9 replies

  14 years, 10 months ago

  By: AppleMouth

• SSIS Package in Production Takes Way Too Long to Execute

  I suspect I am having a memory issue on my production box but I am not clear as to why this might b…

  Aaron G

  3 replies

  14 years, 10 months ago

  By: Aaron G

• How to Datewise backup

  i m using SQL 2008 and i just want to know ,,How i will take a database backup datewise in a same f…

  prash7shinde

  2 replies

  14 years, 10 months ago

  By: AverageDBA

• how the Microsoft Access forms are accesable after the Migration into SQL ??

  Hello All, I have an Access application in the fron end and access database in the backend. Recentl…

  mpalaparthi

  2 replies

  14 years, 10 months ago

  By: Dan.Humphries

• SQL Server 2008 / R2 date vs int

  Hi guys, the date-datatypes have always been an big discussion point in SQL Server < 2008 while …

  christian_t

  5 replies

  14 years, 10 months ago

  By: Orlando Colamatteo

• Securables of a user at DB level

  Hi, I got to copy a database from one server to another. So copied it and transfered all the loging…

  tripri

  2 replies

  14 years, 10 months ago

  By: BLOB EATER

• Parameter sniffing and index rebuilds

  Hi, I was wondering if someone could clarify something for me. I have a query that I beleive is hav…

  InvisibleCat

  2 replies

  14 years, 10 months ago

  By: InvisibleCat