SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SQL 2008 - CXPACKET

  I have an table with half a million records. A simple SELECT of 500 rows takes very long to finish.…

  balasach82

  6 replies

  11 years, 5 months ago

  By: Gazareth

• Insert Data into Access

  Hello All, I am trying to insert sql data into access database but having the error. "Test Connect…

  Shaun2012

  21 replies

  11 years, 5 months ago

  By: Shaun2012

• What could be disabling triggers?

  Everyone: In a couple of occasions, on two different databases, on two different servers (two diffe…

  Giorgio Vidali

  4 replies

  11 years, 5 months ago

  By: Giorgio Vidali

• How this works?

  Hi there , I got this code from web, I cant understand how it works can anybody suggest me with li…

  vignesh.ms

  5 replies

  11 years, 5 months ago

  By: vignesh.ms

• Need help with basic spatial query

  I have a table with events that took place at specific x,y coordinates and another table with a lis…

  Mark Harley

  13 replies

  11 years, 5 months ago

  By: Eirikur Eiriksson

• Query on Linked Server

  Hi, I have a query if we can populate the same table A in a database D with data coming from 2 diff…

  mallikachowdhary 98955

  3 replies

  11 years, 5 months ago

  By: mallikachowdhary 98955

• Index grows really fast!

  Hi all , I have just created an index but it grows so fast... in 3 hours it becomes 95% fragmented …

  WhiteLotus

  18 replies

  11 years, 5 months ago

  By: WhiteLotus

• Help with creating a SQL script.

  I am wondering if I can get some help with what I am trying to achieve here. I have no development …

  LearningDBA

  8 replies

  11 years, 5 months ago

  By: Jeff Moden

• Backup on shared drive failing

  Hi, I have a 4 node cluster with 6 instances. Lets said my 4 nodes are named as Node A, Node B, Nod…

  Benki Chendu

  3 replies

  11 years, 5 months ago

  By: Benki Chendu

• How to efficiently import data in .rpt format into SQL 2008

  Good day, I have been told to import 100G data generated in SSMS and in .rpt format (10+ files) bac…

  halifaxdal

  58 replies

  11 years, 5 months ago

  By: Alvin Ramard

• Backup Testing

  Hi guys, How often should I test my backups? We do full backups Weekly, every Sunday. Daily for dif…

  whitesql

  2 replies

  11 years, 5 months ago

  By: Gail Shaw

• What causes my log size to get bigger ? Difference btw dbcc opentran and Select * from sysprocesses where open_tran>0

  Hi Guys, Somehow my db log size was increased suddenly. This is happening very frequently recently.…

  Akayisi

  1 replies

  11 years, 5 months ago

  By: Gail Shaw

• 1 Quick question for all the DBA's

  I am wondering if someone can help me out. I have become a SQL Server DBA about 7 months ago, but h…

  LearningDBA

  25 replies

  11 years, 5 months ago

  By: Jeff Moden

• disk space 90% full...

  Hi friends, Today i found that one server is having space issue, it has 90% disk space full and in …

  mohan.bndr

  17 replies

  11 years, 5 months ago

  By: Jeff Moden

• 'PARSENAME' not working

  I'm trying to learn how to use PARSENAME... there is probably an easier way to do this but I'm real…

  SQLalchemy

  2 replies

  11 years, 5 months ago

  By: Lynn Pettis