SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• split big query into two different query using global temp table

  Hi All, I need urgent help, i have a query which has more than 4000 char and SSIS 2008 R2 support …

  latitiacasta

  3 replies

  11 years, 11 months ago

  By: David Burrows

• Hash match

  Hello, I checked Hash match in my query... I saw that Probe Residual is this.. [MCS_MESDB].[dbo].[T…

  tony28

  4 replies

  11 years, 11 months ago

  By: tony28

• Insert into table varying with time

  Inserting from my current table to archive table on same database Insert into archivetable Select *…

  yuvipoy

  2 replies

  11 years, 11 months ago

  By: free_mascot

• CLR stored procedure runs slowest on server than on workstation

  Hello, For months, we are wondering why one of our CLR stored procedures is running slowest on a se…

  mg61

  2 replies

  11 years, 11 months ago

  By: mg61

• rebuild increases memory

  Hello, it is possible to handle increasing memory by rebuild and update statistics ? Every weekend…

  tony28

  2 replies

  11 years, 11 months ago

  By: Gail Shaw

• Why would you create a foreign key and then disable it?

  I have an application that has been around for a long time. Most of the FKs are disabled. referen…

  souLTower

  11 replies

  11 years, 11 months ago

  By: Jeff Moden

• The data types datetime2 and varchar are incompatible in the add operator.

  DID is a varchar(20) and i cant seem to get past the above error msg. Thx. if (@OrderBy = 'Postedda…

  isuckatsql

  14 replies

  11 years, 11 months ago

  By: isuckatsql

• how to find the difference between two date time fields in minutes and hours

  Hi Team, I have couple of datetime fields in a table called "Appointment". They are Appstart and A…

  kish1234

  4 replies

  11 years, 11 months ago

  By: Lynn Pettis

• Variables inside linked server queries... stumped!

  Hi everyone, Was hoping you could help me on this one. Posted this on another forum, but no luck so…

  ollas87

  13 replies

  11 years, 11 months ago

  By: rVadim

• Using column data from excel to use in a sql query/statement.

  I have been given an excel spreadsheet that contains a column with about 10000 ids. I need to use t…

  Sabio

  4 replies

  11 years, 11 months ago

  By: rVadim

• replication

  i need to drop replication on some tables , how can i do ?

  ramyours2003

  4 replies

  11 years, 11 months ago

  By: ramyours2003

• Shrink Database

  I have a database which is 306 GB and only 171GB of it is used. I need to shrink this database to b…

  M.DBA

  3 replies

  11 years, 11 months ago

  By: M.DBA

• How to concatenate the one column rows and sum the other columns

  Hi All , table : Subject mark1 --------- ------------ Matchs 90 Physics 85 English …

  s.chandrahasan

  4 replies

  11 years, 11 months ago

  By: klini

• query to check time taken by snap shot replication to transfer data

  Hi friends, Let us assume, I have created snapshot replication from Server A to Server B for transf…

  sundar329

  3 replies

  11 years, 11 months ago

  By: rVadim

• Number of columns in table

  I've been researching issues on the number of columns in a table vs performance. I have a Customer …

  matt6749

  15 replies

  11 years, 11 months ago

  By: matt6749