SQL Server 2005 Strategies

• Topics

  Started by

  Posts

  Last post

• Get Work system - avoid duplicate inserts

  I keep struggling to figure out how to explain this, so this is the best I can come up with. I am a…

  kdfischer

  5 replies

  9 years, 12 months ago

  By: ChrisM@Work

• How can I audit how many times a Trigger in sql2005 fires

  Hi we have a legacy application running on sql2005. We suspect part of our performance issues is f…

  SlapShot John

  5 replies

  10 years ago

  By: Jeff Moden

• What is the equivalent to Yes/No data type in SQL?

  Hi everyone! Which SQL data type is equivalent to Yes/No [ms access]? I am new to SQL[using sql exp…

  ed-1075072

  39 replies

  10 years, 2 months ago

  By: Tim Walker.

• High volumn query notifications

  Does anyone have any experience using query notifications with a high volume of data changes and a …

  Gail Shaw

  3 replies

  10 years, 4 months ago

  By: Orlando Colamatteo

• Table partitioning and file grouping adding....

  I have a big database and 75% space is taken by a table around 490 GB. Now I am told to partition t…

  Tac11

  1 replies

  10 years, 7 months ago

  By: spaghettidba

• Upgrading SQL Server 2000 to 2005. Best practice for a tidy install.

  Hi All. I'm planning to upgrade a SQL 2000 instance to 2005, and wondering what approach would giv…

  thepotplants

  6 replies

  10 years, 10 months ago

  By: pikevillebastage

• Table Partitioning as it relates to table escalation

  In SQL 2005, can I partition a table to help with more row and page locks versus immediately jumpin…

  SQL_Enthusiast

  2 replies

  11 years, 1 month ago

  By: Gail Shaw

• Alter A Partitioned Table Column DataType.

  The BOL: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/5b21c53a-b4f4-4988-89a2-801f512126e4.h…

  bhushanvinay

  13 replies

  11 years, 1 month ago

  By: drc2100

• Random rows generator:

  I have a table of 100 records. I need a random of 2.5% of the reocrds. If I use Select Top (2.5) Pe…

  sudrav

  7 replies

  11 years, 2 months ago

  By: Jeff Moden

• Splitting DBs into multiple files for IO spread

  We have a shared SQL server with a few hundred small DBs on it. Currently all the DBs consist of a …

  Cairbre

  21 replies

  11 years, 4 months ago

  By: Perry Whittle

• Keeping at table lean and highly available

  Hi folks, I have a question in regards to a design I've been pondering. Perhaps i'm merely over an…

  Y.B.

  23 replies

  11 years, 4 months ago

  By: Jeff Moden

• IDENTIFY CHANGES TO TRANSFER IN ANOTHER DBSERVER - DATAWAREHOUSE

  SQLServer2005 EE. Morning all, I need to identify records that are changed since 'last time' (e.g. …

  registrazioni 75612

  1 replies

  11 years, 4 months ago

  By: Christian Graus

• How disable DBCC CHEKCDB command

  Hi, For error someone run DBCC CHECKDB in production database, now i want disable or cancel this co…

  wolf_Ste

  21 replies

  11 years, 6 months ago

  By: Nadrek

• Join of two tables of the different database.

  Is it any impact on the performance if we join the two tables of the different database. my current…

  nitin.varshney

  6 replies

  11 years, 7 months ago

  By: Bhuvnesh

• need to delete backup file before 8 PM

  hello experts, i have some error in using "sp_delete_file" Stored procedure. so looking some other …

  Zeal-DBA

  2 replies

  11 years, 7 months ago

  By: Zeal-DBA