SQL Server 2005 Strategies

• Topics

  Started by

  Posts

  Last post

• more cores vs higher CPU speed

  we're looking to buy new server hardware next month and i have to configure it properly. for an OLT…

  alen teplitsky

  14 replies

  14 years, 11 months ago

  By: Nadrek

• Extracting Data from a column of XML data type using SSIS 2005

  I am using ssis 2005 in order to migrate data from my source to target database. I have a source ta…

  vivekamalakshan

  4 replies

  14 years, 11 months ago

  By: vivekamalakshan

• decimal or money

  I am designing a table with lot of dollar values. What are the pros/cons to use decimal Vs money da…

  repent_kog_is_near

  16 replies

  14 years, 11 months ago

  By: jesse.brandon

• SQL Server Database mirroring

  Afternoon, I am in the process of designing DB mirroring with High safety and automatic failover fo…

  Danb7183

  3 replies

  14 years, 11 months ago

  By: Lynn Pettis

• Changing an ID interger type field to a bigint field in a HUGE table

  Hi 🙂 I need some geniouses enlightment please ^^ Here's the problem: One huge table (600 Go, close …

  Louis Ventura

  4 replies

  15 years ago

  By: Derrick Smith

• sql job - sp input dates need to be different in first run

  I have a sql job which is supposed to execute an SP weekly that queries a table for new entries sin…

  sajaff

  3 replies

  15 years ago

  By: sajaff

• Best Way to track changes in Strored procedures sql2k5

  Hi , i will be grateful if somebody will suggest me how to know when and what was changed in a spec…

  faheemahmad14

  3 replies

  15 years ago

  By: Grant Fritchey

• Affects of several VarChar fields in a table

  Hi, I was thinking about placing several VarChar fileds in a single table called tblContent. It wou…

  mike-939611

  9 replies

  15 years ago

  By: Gail Shaw

• Find and Highlight keywords in Full Text Search Results

  Hi, I am working on the Full Text Search in Sql Server 2005. I have created a catalog and then an i…

  calyan 7420

  1 replies

  15 years ago

  By: chenhongjuandyn

• Implementing Either This One OR these two Logic

  On my current project we need to be store what we are calling citizenship documents (SSN, Passport,…

  Jack Corbett

  24 replies

  15 years ago

  By: WayneS

• Strategies for search and match queries

  Hi everyone, My current problem lies with coming up with a good way to solve a search and match pro…

  kiev.leong

  1 replies

  15 years ago

  By: kiev.leong

• Clustered index on DATETIME: hidden problems?

  I have a event logging table (planned to receive millions of rows) that is clustered on a DATETIME …

  Jesse Reich

  6 replies

  15 years ago

  By: Michael Valentine Jones

• Linked Server security

  Greetings all, I have a vendor provided database called Database1 on SERVER1. The users log in to t…

  emily-1119612

  1 replies

  15 years ago

  By: pankushmehta

• New Identical Table or New Column

  Good day to everyone, I have a table that is used for one particular module in a system. Then a new…

  richarddelcarmen

  5 replies

  15 years, 1 month ago

  By: Toby Harman

• Can you join on text?

  I have two tables that have nothing in common except for a text Desc column. I've tried casting the…

  Billy - a cool nerd

  2 replies

  15 years, 1 month ago

  By: Michael Valentine Jones