SQL Server 2005 Strategies

• Topics

  Started by

  Posts

  Last post

• Product to Catalog

  I really thought I would find a vsd or a diagram that has the following elements on the interweb Pr…

  JKSQL

  1 replies

  13 years, 10 months ago

  By: Sean Lange

• Which Is More Effeceint Case or IF Then - When No Table Is Involved

  QUESTION: If you have an SP that takes in a number and then returns a value and the contents of the…

  YSLGuru

  5 replies

  13 years, 10 months ago

  By: GSquared

• Storing Hexadecimal Datatypes

  I have two columns, in a new table I created, that will store hexadecimal values. One will be 8bit …

  bpowers

  3 replies

  13 years, 10 months ago

  By: bpowers

• Changing an existing column to identity

  My current project for performance improvement of a database includes changing from a sequence gene…

  Jack Corbett

  2 replies

  13 years, 11 months ago

  By: Jack Corbett

• SQL Review --Process

  Hello Friends, I am working on a SQL review process and need to prepare a document which will help …

  sqlquest2575

  1 replies

  13 years, 11 months ago

  By: Grant Fritchey

• High Availability Architecture

  Hi Everyone, We are embarking upon a SQL Server consolidation project. I have been appointed fairly…

  chris webster

  3 replies

  13 years, 11 months ago

  By: San-Man

• Shrinking database without impact to performance

  Hi all, My database has 220GB, but there is 75Gb free space (in mdf) - we dropped one big table and…

  Martin Reiser

  1 replies

  13 years, 11 months ago

  By: Ninja's_RGR'us

• Add Letter to Identity Column

  I have an Identity column in my table and would like to append a letter to the front. What is the b…

  bpowers

  6 replies

  13 years, 11 months ago

  By: bpowers

• Failed call to stored procedure on linked server with error "current transaction cannot be committed"

  If I run the following, there are no errors: exec LINKEDSERVER1.DATABASE1.dbo.SPROC1 @parm1 = 'my_v…

  Kenny-303346

  3 replies

  13 years, 12 months ago

  By: GSquared

• Lookup Table

  I am building a small database for one of our developers. Their application will include several dr…

  bpowers

  14 replies

  14 years ago

  By: Nadrek

• What would you move (in your DB ) to a new Drive If Your DB Server Got One

  If you had a DB that was several hundred GB’s in size that consisted of a single mdf and ldf file a…

  YSLGuru

  11 replies

  14 years ago

  By: YSLGuru

• How to find X job run on which time?X job already created,DO we know

  How to find X job run on which time?X job already created,how to find the job scheduled details for…

  KumarVelayutham

  1 replies

  14 years ago

  By: ps.

• Best Practice Upgrading SQL 2005 to SQL 2008

  I have been tasked to migrate our SQL databases from 2005 to 2008. I searched and couldnt find anyt…

  D-SQL

  2 replies

  14 years ago

  By: Steve Jones - SSC Editor

• At what size db does it make sense to split into multiple files?

  I'm wondering if there is really a benefit to splitting a db into multiple files on smaller db's? I…

  Tom Leykis

  40 replies

  14 years ago

  By: Brandie Tarvin

• Clustered or non Clustered index??

  Hi All, I need one help in deciding index to be used in my table. I have a table with around 200,00…

  sam 55243

  11 replies

  14 years ago

  By: Welsh Corgi