SQL Server 2005 Strategies

• Topics

  Started by

  Posts

  Last post

• How do you use parameters in SSIS lookup functionality

  Hi everybody...I"m new to SSIS, a tool my company is making us use primarily as a DTS tool. What I'…

  mikelordi2

  3 replies

  11 years, 9 months ago

  By: peterzeke

• XMLDocuments growing bigger

  I have a xml table in which it has 10 million records in it . Every day there will be approx 5000 f…

  SQLAddict01

  2 replies

  11 years, 10 months ago

  By: SQLAddict01

• SQL 2005 Mirroring Power Loss (No Witness)

  Hi We have a basic SQL Mirroring setup with 2 servers with No Witness or Automatic Failover. I have…

  Bristolred

  1 replies

  11 years, 11 months ago

  By: DNA_DBA

• Database mirrioring Error (Microsoft SQL Server, Error: 1418)

  Hello All , Can you please tell me about database mirroring configuration setup I have created prin…

  sarang.dalal

  7 replies

  11 years, 11 months ago

  By: rupesh.rams

• Deleting Large Volumes of records

  I have a logging table that has 130+million rows in it and it is taking up over 11gb in disk space …

  alan_b

  2 replies

  11 years, 11 months ago

  By: Eric M Russell

• Table partition Vs FileGroup

  should we create the equal number of filegroups for eqaul number of table partitions. like if one t…

  nitin.varshney

  3 replies

  11 years, 11 months ago

  By: Gail Shaw

• How can i know which stored procedure is executed when and by which program?

  I want to know which stored procedures are executed in the last 24 hour in my database and i wish i…

  zeeshan malik-467318

  8 replies

  12 years ago

  By: appuraj

• Random number generator

  Ok.Guys I need your help. I have a table of about 60000 records. I want to add a column say random …

  sudrav

  20 replies

  12 years, 1 month ago

  By: Jeff Moden

• Disk strategy for new SQL infrastructure in VM-ware

  Hi all I'm looking for some feed back in regards to the below mentioned challenges. In our organisa…

  Soren Nielsen

  4 replies

  12 years, 1 month ago

  By: paultormey

• Moving prod DBs from local disk to SAN with absolute minimal downtime

  Background I have a number of production databases that are currently on the local disk on the serv…

  RossRoss

  9 replies

  12 years, 1 month ago

  By: RossRoss

• To Database or File System

  I was looking for others thoughts on topic of saving pdf to Database or File System. Currently we …

  Degradable

  2 replies

  12 years, 2 months ago

  By: Degradable

• TempDB optimization

  hello, in ma current configuration i have one data file and one log file of a tempdb database. as a…

  Zeal-DBA

  4 replies

  12 years, 3 months ago

  By: Meet George Jetson

• Keeping two databases in Sync

  Ok, we have an office in London and one in Boston. We have an application (winforms) that connects…

  patrick ryan-390269

  2 replies

  12 years, 3 months ago

  By: osss_au

• Run stored procedure when temp table is created/dropped

  Hi guys and girls, I need to update 1 or 2 records in my database each time a temp table with the n…

  jo.wouters

  8 replies

  12 years, 4 months ago

  By: jo.wouters

• How implement object orientation features in sql server?

  I know features of object orientation could not implemented, but i want to find a way to implement …

  tz.bahrami

  15 replies

  12 years, 5 months ago

  By: GSquared