SQL Server 2005 Strategies

• Topics

  Started by

  Posts

  Last post

• To Parent/Child or Not To Parent/Child

  I have a Bulletins table, where I want to indicate which Customers will see a particular bulletin. …

  kanejeeves

  6 replies

  15 years, 8 months ago

  By: Brad-1060956

• Colums Data Size

  Hi, is there any way that find columns size ? thanks

  QML

  5 replies

  15 years, 8 months ago

  By: Lowell

• Best way to append data from other non-MSSQL database via ODBC

  I have a table in a non-MSSQL database that tracks transactions. Everytime someone does a transacti…

  phonetictalk

  4 replies

  15 years, 8 months ago

  By: SQLRNNR

• Standard and Enterprise editions on the same cluster

  We are currently running a two node cluster on SQL 2005 Enterprise with one Database Instance. I wo…

  derald-764731

  5 replies

  15 years, 8 months ago

  By: EdVassie

• way to find out from where or how the data loaded into table

  is there a way to find out from where or how the data loaded into table for eg. data can be loade…

  tabrez.test

  7 replies

  15 years, 8 months ago

  By: emily-1119612

• Best way forward for system that requires its own instance?

  My client went shopping and bought a system designed for use in the US after being told it would wo…

  dgunner

  2 replies

  15 years, 9 months ago

  By: Steve Jones - SSC Editor

• How to monitor the executed SQL in SQL 2005

  Hi: I have project running on SQL 2005. There 2/3 users only have delete permission and 4 users hav…

  h_maksuda

  7 replies

  15 years, 9 months ago

  By: Steve Jones - SSC Editor

• Using a view is degrading Select performance

  Hi All, I'm trying to troubleshoot a query in someone else's (honestly it is someone else's) databa…

  Will Casey

  12 replies

  15 years, 9 months ago

  By: Dave Ballantyne

• Accessing Multiple SQL Server

  I have been asked to provide a solution for the following architecture.. 1) Multiple SQL Server 200…

  sihaab

  4 replies

  15 years, 9 months ago

  By: sihaab

• Clustering or Mirroring for High Availability

  I just started working for a company that retrieves location information via the Internet and suppl…

  Ray Laubert

  3 replies

  15 years, 9 months ago

  By: happycat59

• Best approach for updating from SQL 2000? (new hardware)

  I'm a sysadmin that does a lot of support for SQL (with the exception of the "internals" which is h…

  thefourthdoctor

  12 replies

  15 years, 9 months ago

  By: Bru Medishetty

• Read an excel file stored as varbinary in the DB?

  So this works fine SELECT * FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0', 'Data Source=D:\TestJET…

  Shane N

  6 replies

  15 years, 9 months ago

  By: chrisn-585491

• DB getting large because of the varbinary. Possible actions...

  Ok Folks I have been saving files (20K to 250K) into varbinaries in a table. The number of records …

  zaebis 88446

  3 replies

  15 years, 9 months ago

  By: PaulB-TheOneAndOnly

• Anything other than Trigger ?

  I have a small situation, we are hosting a third party application which uses SQL 2005 as a back en…

  sihaab

  10 replies

  15 years, 9 months ago

  By: Eoin The Forge

• SQL Server 2005 Best Practices - How Best To Change The Ownership Of Many Objects

  There are several posts in the SQLServerSentral.com Forums on this but what I'm looking for is inpu…

  YSLGuru

  1 replies

  15 years, 9 months ago

  By: GSquared