SQL Server 2005 Strategies

• Topics

  Started by

  Posts

  Last post

• Caching a table

  Hi! I am trying to find best strategy for following scenario: - One or more applications wants to q…

  neelsmail

  6 replies

  15 years, 7 months ago

  By: Johan Bijnens

• Sparse Column

  HI, Can any one explain me why non null values in Sparse column takes 4 bytes extra? Regards JIM

  Jim-1146873

  2 replies

  15 years, 7 months ago

  By: Pedro DeRose [MSFT]

• Documentation - Is it good to use the extended properties as data dictionary?

  Hello friends, In my company we use SQL 2005 and we don't use any CASE tools. I am studying a new w…

  DBA Cabuloso

  4 replies

  15 years, 7 months ago

  By: davidr@uslfinancials.com

• Need to read from a web application into SQL Server 2005 - how to choose between MySql and xml?

  Hi, A freelance web developer is writing an online job application for my company's website. I need…

  Louise Boulton

  7 replies

  15 years, 7 months ago

  By: Louise Boulton

• Preventing users whose logins have access to a database through an application from accessing the database through SQL Client tools

  I'm wondering: what strategies are employed out there for preventing users (whose logins have acces…

  Marios Philippopoulos

  7 replies

  15 years, 7 months ago

  By: Marios Philippopoulos

• Establishing RI on an Existing Database

  I have inherited a 100GB database with over 200 tables. All the tables have primary keys defined, b…

  Treehouse

  6 replies

  15 years, 7 months ago

  By: Johan Bijnens

• 3rd-party enterprise-level backup tools - Should DBAs still be in charge of backups/restores?

  With the advent of third-party enterprise-level backup solutions, such as Symantec or CommVault, ho…

  Marios Philippopoulos

  32 replies

  15 years, 7 months ago

  By: Indianrock

• HP PolyServe Software for MS Sql Server

  I am currently in the information gathering phase of our sql server consolidation project. We were…

  SQLdba-473999

  13 replies

  15 years, 7 months ago

  By: Brookstone

• Analysis Services and Excel 2007

  I understand that Excel 2007 has some Analysis Services capabilities. Can someone point me in the …

  S Hodkinson

  3 replies

  15 years, 7 months ago

  By: S t e f

• Can we run SQL Standard edition instance in the cluster along side the existing Production Enterprise instance.

  Hi Experts, Currently we are running the Navision reporting on SRV-Report via a daily process that …

  Eswin

  3 replies

  15 years, 7 months ago

  By: SQLRNNR

• Advice? Server migrations with replication.

  I have been tasked with migrating our sql servers to new hardware, about 6 of them are standard 200…

  VoltronSabreRider

  1 replies

  15 years, 7 months ago

  By: S t e f

• Agent Job Owner - What do you do?

  Our agent jobs are owned by either a windows user or the sa account. I was considering creating a …

  LeeM

  5 replies

  15 years, 7 months ago

  By: Alan. T.

• Central database data repository

  Hey, I am facing the following requirements from my client. - My client has N shops. He has install…

  stelianx

  2 replies

  15 years, 7 months ago

  By: Lynn Pettis

• Linked Server View - Production vs Test

  I have 2 servers one for accounting and one for business activity (orders,qc,etc...) These are con…

  brian.neumeier-603907

  4 replies

  15 years, 7 months ago

  By: Steve Jones - SSC Editor

• BULK INSERT - Inconsistent number of columns in DAT file

  Hi guys!! I need your help in resolving this issue: Description: ------------------ I have a Table …

  ColdCoffee

  2 replies

  15 years, 7 months ago

  By: ColdCoffee