SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• how to retrive a password for sql auth account

  Hello, How can to retrive a password for sql auth account Thank you

  Krasavita

  2 replies

  14 years, 7 months ago

  By: Nicholas Cain

• How to improve Join performance for big tables join

  Hi, I am actually having some problem to improve the performance of this query: INSERT INTO bigw.PL…

  wilson_acong

  9 replies

  14 years, 7 months ago

  By: Evil Kraig F

• Create a view from tables having similar column names

  I'm trying to create a view which selects from tables which have same column names. I can specify a…

  svakka

  3 replies

  14 years, 8 months ago

  By: SQLRNNR

• Is it Possible to pass parameters from one Job step to another?

  I'm just wondering if it's do-able.

  Khades

  2 replies

  14 years, 8 months ago

  By: Khades

• Error using "Script table as.." option in SSMS

  Hello, I am using SQL Server 2008R2 SP1 and have a problem when it comes to getting SSMS to script …

  raotor

  8 replies

  14 years, 8 months ago

  By: raotor

• Index on View or Table

  Hi, Today one of the proc in DB is running slow and when dug into it i found that the proc is using…

  raghu.sudheer

  2 replies

  14 years, 8 months ago

  By: Evil Kraig F

• Parallel update on the same partitioned table generating deadlocks

  Hi folks, I have a table partitioned on the date, with one partition per year. I need to update one…

  babagulu

  8 replies

  14 years, 8 months ago

  By: Gail Shaw

• sys.dm_db_index_usage_stats question

  Going back to last weeks questions on Clustered Index Update. I found out that when the Non Cluster…

  Grizzly Bear

  9 replies

  14 years, 8 months ago

  By: Gail Shaw

• SQL 2000 to SQL 2008..slow UDF queries

  We recently went from SQL 2000 to SQL 2008 and about 100 of our stored procedures are running very …

  herbe

  3 replies

  14 years, 8 months ago

  By: herbe

• SQL XML Plan

  How to read SQL Query XML Plan?

  SQlLogic

  3 replies

  14 years, 8 months ago

  By: SQlLogic

• Re-format datetime data

  Some datetime data like "2011-09-30 23:59:59.000", "2012-01-30 23:59:59.000"... need to be re-forma…

  adonetok

  1 replies

  14 years, 8 months ago

  By: Gail Shaw

• Loading 1000s of small csv files with SSIS crashes BIDS

  Hi I have a curious problem. I am trying to load many 1000s of small csv files into a table with an…

  Tempest

  7 replies

  14 years, 8 months ago

  By: Tempest

• INSERT INTO versus SELECT INTO data import strategy

  We have a temporary table defined as: CREATE TABLE #tmp_wages( [ssn] [varchar](9) NULL, [firs…

  Jim Mace

  3 replies

  14 years, 8 months ago

  By: SQLRNNR

• How to update the database table by removing trailing spaces from one of the columns?

  I am trying to write some SQL statement so I can update my entire database table by removing all th…

  fawadafr

  12 replies

  14 years, 8 months ago

  By: fawadafr

• Best software to image servers

  I have 5 Servers. Two are SQL 2008 server setting on a 2008 server OS. Two SQL 2005 servers runnin…

  techzone12

  3 replies

  14 years, 8 months ago

  By: techzone12