SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Manipulation on Excel generated XML file in sql server 2005

  Hi, I have an excel generated XML file(automatically generated). I'm able to store this compl…

  rekha_sara

  6 replies

  15 years, 4 months ago

  By: rekha_sara

• Will Virtual Machines slow down T-SQL queries??

  Hi All, I have this problem killing me! A job that generally takes 1 hour to complete on physical m…

  ColdCoffee

  17 replies

  15 years, 4 months ago

  By: Dan.Humphries

• Database migration between hosts

  One of our clients wishes to move their database from our servers to their own hosting solution. Is…

  Hunnie

  7 replies

  15 years, 4 months ago

  By: SD1999

• Possible parameter sniffing?

  Hi, I hope I have picked the right sub-forum for this. I have a problem on an internal web-based a…

  paul.goldstraw

  24 replies

  15 years, 4 months ago

  By: paul.goldstraw

• How to Fetch the Data Recursivly with Prior to Parent in Flat View

  hi i have Design the Table To maintain Folder Data in Hierachical Fashion .The Below is the Table S…

  deepak.a

  3 replies

  15 years, 4 months ago

  By: deepak.a

• Query Error

  Hi All, I have written a query to get count of various fields. This is based on the users table. I …

  malavika.ramanathan

  3 replies

  15 years, 4 months ago

  By: malavika.ramanathan

• database (in recovery) , what is the normal cause

  recently my databases in SQL2005 sometimes suddenly try to recovery (i.e. database (in recovery) .…

  kingsofconvenience

  1 replies

  15 years, 4 months ago

  By: Steve Jones - SSC Editor

• SQL Server 2000 msdb Integrity check fails

  My SQL Server msdb Integrity job fails with 2 consitency errors. Unfortnately there are no good bac…

  kwame poku

  5 replies

  15 years, 4 months ago

  By: kwame poku

• updating changes from one database to another database in the same server

  I have a copy of client database say 'DBCopy' which already contains modified data. The copy of the…

  Pavan Kumar Renjal

  2 replies

  15 years, 4 months ago

  By: Pavan Kumar Renjal

• How to change what getdate() returns

  select getdate() returns the result in the format 5/12/2010 9:43:20 Am but i want it to return the…

  nandish7

  2 replies

  15 years, 4 months ago

  By: Dave Ballantyne

• Conbersion error - urgent!

  am trying to update my table with a simple conversion but I am getting error. I have a duration col…

  malavika.ramanathan

  4 replies

  15 years, 4 months ago

  By: malavika.ramanathan

• Shrinking a SQL 2005 database

  Hi All, I've taken over a SQL 2005 Enterprise Edt server. It has a database that has been created w…

  Denesh Naidoo

  3 replies

  15 years, 4 months ago

  By: Denesh Naidoo

• get rows from joins which doesn't match

  SELECT EP.EMPLOYEE_ID, EP.FIRST_NAME + ' ' + ISNULL(EP.MIDDLE_NAME, ' ') + ' ' + ISNULL(EP.LAST_NAM…

  sachinrshetty

  7 replies

  15 years, 4 months ago

  By: Gail Shaw

• Monitor CPU usage using Task Manager..

  Hi, I remember my DBA 10 years ago advised not to have more than one DBA monitoring CPU usage using…

  lkean66

  3 replies

  15 years, 4 months ago

  By: Grant Fritchey

• Check NOT EXISTS against two tables

  Hello, I have three tables TableA TableB TableC I want to check for rows (that do not exists) in Ta…

  donato1026

  19 replies

  15 years, 4 months ago

  By: donato1026