SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• What Could Cause large Gaps In SQL Servers Default Trace

  I have the default trace on a SQL Server 2008R2 instance enabled and found today that there is a ga…

  YSLGuru

  1 replies

  11 years, 2 months ago

  By: YSLGuru

• How to find who is indirectly connected to a database?

  Recently I needed to find all processes connected to a particular database, let's call it Test_db. …

  SQL Guy 1

  7 replies

  11 years, 2 months ago

  By: SQL Guy 1

• Litespeed Vs Native Backup?

  We have upto 1TB DBs in our environment and total size of all the backups reach upto 48TB. Any head…

  luckysql.kinda

  13 replies

  11 years, 2 months ago

  By: EMarkM

• backups running hours..

  Hi, Currently, working with SQL backups. I am looking for the route cause of slow backups. Our cur…

  ramana3327

  9 replies

  11 years, 2 months ago

  By: EMarkM

• How to Update multiple column with Multiple condition

  I need to update multiple columns in a table with multiple condition. For example, this is my Query…

  venkaat105

  7 replies

  11 years, 2 months ago

  By: venkaat105

• What is the impact of running 'sys.dm_os_wait_stats', CLEAR on production server

  Is there any impact running 'sys.dm_os_wait_stats', CLEAR on production? Thanks

  iqbalbutt

  2 replies

  11 years, 2 months ago

  By: Grant Fritchey

• SQL Query

  Hi, I have a table with the following columns: cod_rep_fiscal, cod_met_tributario, ctb, status Note…

  river1

  2 replies

  11 years, 2 months ago

  By: Pulivarthi Sasidhar

• Date CONVERT Errors

  Hi there - I have a very strange error which keeps occurring whenever I run a convert statement. …

  arrjay

  1 replies

  11 years, 2 months ago

  By: arrjay

• select query works but delete query throws error

  Hi All, I have two tables , one is main table and another one is Duplicate check table. I need to f…

  passiondba

  5 replies

  11 years, 2 months ago

  By: passiondba

• SSIS 2008 package running slow in dtexec than BIDS

  Hi All, Bringing to life this old topic: http://www.sqlservercentral.com/Forums/Topic1307523-364-1.…

  rocho09

  5 replies

  11 years, 2 months ago

  By: Koen Verbeeck

• 64 bit Text Qualifier Issue

  Hi I've discovered an issue with the text qualifier field in the file connection manager when upgra…

  Hughesy

  9 replies

  11 years, 2 months ago

  By: g_code_llc

• How are these unique keys generated ?

  2c92a0f93b5aafef013b670d44184e86 Sales Force and other applications are using these huge, character…

  mar.ko

  8 replies

  11 years, 2 months ago

  By: Steve Jones - SSC Editor

• Disaster Recovery Test and [master]

  I've created an automated DR test to test my backups. It restores databases to a test/sandbox inst…

  Dave Mason

  2 replies

  11 years, 2 months ago

  By: Dave Mason

• Moving Backups & Restoring databases

  Hi All, I am working on a task. Currently we are taking a database backup and keeping that backups …

  ramana3327

  9 replies

  11 years, 2 months ago

  By: Steve Jones - SSC Editor

• Sql Server DATALENGTH() function in C# or SQL CLR

  Need help, I am looking for Sql Server DATALENGTH() alternative or equivalent function in C#, that…

  aifaz.khan

  4 replies

  11 years, 2 months ago

  By: aifaz.khan