SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Use 'case-when' But error conditions overlap in query.

  I try 'case when' with 'null' and 'not null' set to value 'ErrorCode' field. Ex. EmpNo|ChkDate …

  ppc493

  3 replies

  13 years, 5 months ago

  By: sturner

• How to join multiple rows of subtable to parent table

  I have 2 related tables and the second table can have many rows associated with the parent table. I…

  haagendaz

  6 replies

  13 years, 5 months ago

  By: haagendaz

• Specify multiple file extensions in maintenance cleanup task

  Is it possible to specify more than one file extension in a single Maintenance Cleanup Task or do y…

  AVB

  5 replies

  13 years, 5 months ago

  By: Dennis Post

• Transfer Data from Table to TextFile

  how to transfer data from table to textfile with upto date range.

  rahulostwal

  1 replies

  13 years, 5 months ago

  By: Lowell

• SQL Trace causes application to hang

  Hi, We've recently upgraded to Windows 2008 R2, SQL Server 2008 R2 SP + CU4, multi-instance cluster…

  adb2303

  13 replies

  13 years, 5 months ago

  By: GSquared

• Database Backup Strategy

  Dear, Currently we are taking full database backup twice. There is no log backup in our plan. If tr…

  shohelr2003

  6 replies

  13 years, 5 months ago

  By: sanket kokane

• Merge replication changing the distributor

  I have a client who has a single SQL server that is currently their OLTP database server and is han…

  Rooster

  1 replies

  13 years, 5 months ago

  By: Rooster

• Database Mirroring Testing & Configuration

  Dear, 1. I want to configure database mirroring with automatic failover option. Now I backup databa…

  shohelr2003

  2 replies

  13 years, 5 months ago

  By: shohelr2003

• Alter TempDB !! Same disk or seperate ??

  i read an article http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-(1230)-tempd…

  Bhuvnesh

  4 replies

  13 years, 5 months ago

  By: Bhuvnesh

• Log File Reuse Reason Explain

  Dear, If I execute the following query, select name, log_reuse_wait, log_reuse_wait_desc from sys.…

  shohelr2003

  2 replies

  13 years, 5 months ago

  By: Gail Shaw

• how to write a stored procedure to check if the members membership has expired

  i have a table named users where i have two three column userid, email, membershipexpiry i want to …

  sanjay.dakolia

  9 replies

  13 years, 5 months ago

  By: Vedran Kesegic

• How to check mirrored database

  Dear, I have implemented database mirroring with automatic failover option. My principal database i…

  shohelr2003

  21 replies

  13 years, 5 months ago

  By: shohelr2003

• Calculated for the two columns of the table

  I have two columns. Name column 1 is F1 Name column 2 is F2 I would calculate two columns And the t…

  kiasystemsoft

  9 replies

  13 years, 5 months ago

  By: Bhuvnesh

• Amount of data

  I was wondering if there is a way to "trap" or track the amount of data (in bytes) that a select st…

  sqldummy79

  5 replies

  13 years, 5 months ago

  By: Jeff Moden

• Mirror and Clustering

  Hi, I have a principal instance(db mirror) which is required to be failed over from node 1 to node …

  M&M

  1 replies

  13 years, 5 months ago

  By: M&M