SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Tempdb is full for Large Table Joins

  Hi, I'm joining few large tables for loading historical load. 4 of these tables are about 10-15 mi…

  facticatech

  10 replies

  11 years, 12 months ago

  By: ScottPletcher

• Using DBCC Traceon - Help

  I set up a couple traces yesterday, 1222 for lock info and 4001 for getting extended login informat…

  joshdbguy

  13 replies

  11 years, 12 months ago

  By: Adi Cohn-120898

• XP_FIXEDDRIVES Error/Missing MB Free Column when trying to perform a MSSMS Backup

  Hi, Can someone move this to the Administration section? I'm sorry I posted in the wrong place. I'm…

  pmal

  6 replies

  11 years, 12 months ago

  By: pmal

• Excessive amount of Virtual Log files?!

  Hello, As I am monitoring my sql servers, I noticed something in one server. In the error log, I s…

  WebTechie

  16 replies

  11 years, 12 months ago

  By: SQLBlimp

• SQL Agent won't process Cube

  Hi All I am having trouble getting my SQL Agent job to process a cube on SQL Svr 2008. I can run th…

  ayfour

  5 replies

  11 years, 12 months ago

  By: Eric M Russell

• DTSRun to DTSExec

  Hi all, We are migrating SQL 2K db's to a new box and to SS2K8. We've got nearly a hundred sprocs a…

  Jake Shelton

  1 replies

  11 years, 12 months ago

  By: SQLBuddy123

• Partitioning table on a column that is not part of clustered index

  HI I need to partition a table with existing data based on a column "ColumnA" which is not part of …

  S_Kumar_S

  5 replies

  11 years, 12 months ago

  By: Gail Shaw

• Straight Question:In Partitioning,Is it mandatory for partitioned column to be part of clustered Index?

  Hi The question is in subject itself: In Partitioning,Is it mandatory for partitioned column to be …

  S_Kumar_S

  7 replies

  11 years, 12 months ago

  By: Gail Shaw

• Long Running SQL Query .. Looking for recommendations for improvement.

  Hi Guys, I have a query I have written to join 3 tables, run a CASE statement for two columns and p…

  mrupperman

  16 replies

  12 years ago

  By: Gail Shaw

• search string that does not contain a string

  declare @test-2 varchar(1000) set @test-2 = 'alksjdfhkalsdhf update a;slkfjdlakjsdf where sadlkfj…

  pramod.gururaj

  2 replies

  12 years ago

  By: Adi Cohn-120898

• Update value of column in specific row, if a specific string exists somewhere in that row

  I am running a very large database with many large tables. This database tracks who did what in ref…

  robertsquednau

  2 replies

  12 years ago

  By: CKX

• Help with joins for maintaining history table

  Hi there, I have 3 tables. Step1) Table1 called BulkCopy gets repopulated 1st of the month. Step …

  rash3554

  4 replies

  12 years ago

  By: rash3554

• Help needed to calculate last n months moving average from given date for a each and every process name.

  Hi, I have a requirement to calculate the moving average for last 2 months from given date in the …

  sana786

  2 replies

  12 years ago

  By: sana786

• New to SQL Server 2008 Querying

  Hi All Myself is Mohammad Naveed and i am new to this Nice Forum. Just few days back i have started…

  arifshaik1125

  4 replies

  12 years ago

  By: Grant Fritchey

• Issue sql server query and restart windows service

  How can i best issue an sql query and also restart a windows service from a remote machine? “When I…

  kapfundestanley

  4 replies

  12 years ago

  By: paul.knibbs