SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Shrinking log

  Hi, In general how often we can shrink the logs. Does shrinking the log will effect the point in t…

  ramana3327

  3 replies

  11 years, 3 months ago

  By: Gail Shaw

• Do data flow through SSIS server to the destination database server?

  We have three servers(A,B and C) . We have a SSIS package on the (C) to load data from (A) into (B)…

  Aspet Golestanian Namagerdi

  1 replies

  11 years, 3 months ago

  By: Koen Verbeeck

• Shrinking T-Log files

  I need to shrink Transaction Log files since they have grown too much. Also all the databases have …

  Aatish Patel

  4 replies

  11 years, 3 months ago

  By: lmarkum

• Dropping and adding the Unique Nonclustered Index

  Hi, I have a index on a column. That index is unique nonclustered index. After recreate that I wan…

  ramana3327

  6 replies

  11 years, 3 months ago

  By: Grant Fritchey

• Select data from another database without reference

  Last week I had a to migrate a database from SQL2003 to SQL2008. The 2003 Server had several databa…

  terry.home

  2 replies

  11 years, 3 months ago

  By: ScottPletcher

• Cache question - sys.dm_exec_procedure_stats

  I am running the following query to find some store procedure that ran today on a specific databas…

  Guras

  2 replies

  11 years, 3 months ago

  By: ScottPletcher

• MSDB Log HUGE and growing, cannot shrink

  So, I have run into a bit of a problem. I have gotten a run away MSDB log file. 184GB to be exact, …

  mhughes 28924

  5 replies

  11 years, 3 months ago

  By: Guras

• Is there a better way to write this query.

  I am trying to load data in batches on 10 K. The select statement at the bottom is taking about 60 …

  curious_sqldba

  10 replies

  11 years, 3 months ago

  By: Alexander Suprun

• Question about "Client Statistics"

  Hi, SQL Server 2008R2. Are the "Trial #" columns in this tab database independent, i.e. are they …

  davidgray

  1 replies

  11 years, 3 months ago

  By: Grant Fritchey

• DBCC CHECKDB on a very big database.

  Hello smart people, I just want your opinion on this, I have very large Database and need to run DB…

  Tac11

  3 replies

  11 years, 3 months ago

  By: Gail Shaw

• Extracting data using an ODBC connection in SSIS

  Hi All, I need some help. I have Visual Studio 2008 setup on my machine and I just recently got my…

  skaggs.andrew

  2 replies

  11 years, 3 months ago

  By: skaggs.andrew

• get table size and row count

  Hi, i need separated db tables size and row_count details. share the script.

  sivakumar.thangavel

  6 replies

  11 years, 3 months ago

  By: Brian Hibbert

• Row index and Row number

  Is there any difference between Row index and row number in sql?

  hazeenahazu

  12 replies

  11 years, 3 months ago

  By: Gail Shaw

• Error with named pipe in 2008 R2 (stopped listening)

  Guys, i'm facing this problem below: Server named pipe provider has stopped listening on [ \\.\pi…

  Scarlet Muniz

  5 replies

  11 years, 3 months ago

  By: Scarlet Muniz

• Query help please !

  I have the following table where I log the database file size database_id Space_Used_in_MB file_…

  Guras

  2 replies

  11 years, 3 months ago

  By: Xedni